Trouble Connecting to Oracle Database via ODBC

[bjw122]

I'm evaluating the trial version of EA 10 as a Database Engineering tool before potentially making a purchase.

I'd like to use the "Database Engineering" --> "Import DB From ODBC..." option against my Oracle 11gR2 database.

I'm on Windows 7 x64 so I installed the "Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64)" software so that the correct ODBC drivers get installed.  After that I started the "Windows ODBC Data Source Administrator" application by running "C:\Windows\SysWOW64\odbcad32.exe" and created a data source.  When I use the option to test my connection, the test completes successfully.

See image here:
http://home.comcast.net/~bjw122/images/1.jpg

Now I start up EA 10.0 and go to "Import DB From ODBC...".  I select the "Machine Data Source" that I had defined, and I immediately get an error "Unable To Obtain Table Information".

See images here:
http://home.comcast.net/~bjw122/images/2.jpg
http://home.comcast.net/~bjw122/images/3.jpg

Oddly enough, if I go to create a new Data Source using the EA screens, I don't see my Oracle Driver listed so that could be an indication of where the underlying problem is.  See images here:
http://home.comcast.net/~bjw122/images/4.jpg

Thank you for your assistance.

[Geert Bellekens]

EA is know to be very picky when it comes to Oracle drivers.
A search for "Oracle" in either the help or the forum (use top left search button) should yield some useful results.

Geert

[bjw122]

Thank you.

EA Support contacted me and said:

Thanks for the note.
 
That the Oracle ODBC driver does not appear in EA's ODBC Data Sources suggests the 32-bit client is not installed.
 
EA requires 32-bit drivers.
 
Please refer to the Notes section on page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/importdatabaseschemafromod.html
 
 
Please uninstall the 64-bit client and install the 32-bit client. We recommend ODTwithODAC1110720 - available here ...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html




This resolved my issue.