Book a Demo

Author Topic: Schema Import from Oracle 12c: no objects in list  (Read 3044 times)

Colin_Nicholls

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Schema Import from Oracle 12c: no objects in list
« on: March 23, 2014, 05:30:48 pm »
I recently upgraded (replaced) my local development instance of Oracle to 12c.
Enterprise Architect will no longer display any tables when I select to "import DB schema from ODBC source".

Has anyone else encountered this problem?

Note that:
  • I am using the 32-bit ODBC driver for Oracle Client 12c (32-bit);
  • I have also tried the 11g client (32-bit) with same results;
  • I have used Excel+MS Query to successfully view a schema object listing via the 12c ODBC driver;
  • I have used the 12c ODBC driver in EnterpriseArchitect to retrieve the schema object list from an external 10g Oracle DB.

I have also used FlexTracer to attach to EA.EXE and observe the difference in ODBC calls between the local 12c DB and the external 10g DB.
This is what I see for the local 12c DB:


Call                  Result      Parameters
:
SQLDriverConnectW     1           InConnectionString='DSN=localdb;UID=T2_X;PWD=xx;DBQ=local12c ...
SQLDisconnect         1           ConnectionHandle=746715320


So it disconnects before it even issues a SELECT O.OBJECT_NAME... etc. I'm stumped as to what to try next. Anyone have any creative ideas?

Thanks in advance.