Scott, Thank you for your reply. I have found my issue. The instance was being monitored actively but by another server looking for failed jobs. I was pointed in the wrong direction for a solution.
ok thank you. i wonder how ODBC works for smaller number of tables at once
Using the Native/Direct connection requires the full Oracle client to be installed. It then uses the Oracle tnsnames.ora alias as the datasource to connect to the database. Here are links to some of our docs: http://docwiki.embarcadero.com/ERStudioDA/170/en/Using_Native_or_Direct_Database_Connections http://docwiki.embarcadero.com/ERStudioDA/170/en/Reverse_Engineering_an_Existing_Database Regards, Stan
i used at jdbc:oracle:thin:@hostanme/servicename did not work
Thank you. Choosing Native/Direct Connection: what would be the Data Source? Do i need to create one? and how?
Are you using ODBC to reverse engineer or the native client connection? I believe that in the other thread you mentioned that your database is Oracle. If that’s the case then I would suggest using the native client and the Oracle alias to connect to the database. I’ve only seen this error with ODBC connections.