Oracle 10g ODBC Connection

[DSS]

Hi,

I have created File and machine DSN, but I am not able to get ERDiagram (Import DBSchema from ODBC). It gives error "Unable to obtain table."

Thanks & REgards,
-Rajeev

[Geert Bellekens]

please search the forum using the top left button.

Geert

[DSS]

Still I am not able to find the solution, Even I have already installed updated ODBC Drivers from Microsoft site.

Machine DSN, I've verify with "Test Connection", connection establised successfully.

After restarted machine, again I am getting same error "Unable to Obtain Table Information".

Can you provide me, How can I import database table into EA (using as reverse engg)?

Thanks & Regards,
-Rajeev

[hd]

I believe you should be using Oracle's ODBC driver, not Microsoft's. See Notes at bottom of this page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/database_engineering/importdatabaseschemafromod.html

[Matt Seaborn]

I experience the same problem, and am using Oracle's own ODBC driver.

Did you have any luck getting this to work?

[hd]

I use ODTwithODAC1110720 - works perfectly...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html