Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: Problems with reverse-engineering Oracle 8i DB with CaseStudio 2.0

    hi all,

    i am trying to reverse-engineer an Oracle 8i DB using CaseStudio 2 and here is what happens:
    i connect succesfully, but when i hit "Execute" to see the results from the reverse-engineering, first i get a dialog box telling me "Unspecified Error" , which i hit "OK" on and ignore, but then i get two "Error 8" dialog boxes one after the other and when i click "OK" on that, it just stops and says:

    "
    .
    .
    Reversing sequences...
    Done
    Reversing users...
    Done
    Reversing roles...
    Done
    Reversing permissions...
    Done
    Error 1
    No attribute found in child table "XXXXXXXXXXXXX", that would belong to the foreign key item"

    anyone know what the problem could be?

    thanks all.
    Last edited by my_lou; 10-27-03 at 18:02.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Problems with reverse-engineering Oracle 8i DB with CaseStudio 2.0

    Originally posted by my_lou
    hi all,

    i am trying to reverse-engineer an Oracle 8i DB using CaseStudio 2 and here is what happens:
    i connect succesfully, but when i hit "Execute" to see the results from the reverse-engineering, first i get a dialog box telling me "Unspecified Error" , which i hit "OK" on and ignore, but then i get two "Error 8" dialog boxes one after the other and when i click "OK" on that, it just stops and says:

    "
    .
    .
    Reversing sequences...
    Done
    Reversing users...
    Done
    Reversing roles...
    Done
    Reversing permissions...
    Done
    Error 1
    No attribute found in child table "XXXXXXXXXXXXX", that would belong to the foreign key item"

    anyone know what the problem could be?

    thanks all.
    You might get better answers in the "CaseStudio 2" forum.
    I for one never heard of the tool.
    Why are you using a tool which you can't make work?

  3. #3
    Join Date
    Oct 2003
    Posts
    57
    nm, i figured it out. the problem was i was using the wrong OLE DB provider. instead of "Microsoft OLE DB provider for ODBC" drivers, i was supposed to use "Oracle provider for OLE DB".

    it's a very nifty program for charting ERD's and reverse-engineering a DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •