Migration using ODBC drivers
Posted by: Dean Campbell
Date: May 18, 2018 03:48PM

I'm trying to run the migration wizard.
I'm accessing my source database through ODBC.

But when I select "Generic RDBMS":
a.) Using a DSN, it doesn't provide me any place to input User name -- it simply uses <dsn_user> and prompts for password.

b.) Using "ODBC manually entering parameters", it uses "SERVER" for "hostname" field, which is not recognized by my driver. And the connection string gets "DRIVER=" added with no place to enter driver name. Both of these cause fatal errors.

c.) when using "ODBC Connection string" -- every permutation of any/all parameters result in "operation cancelled" error message.

If I select "SQL92 compliant" database.
a.) Using "ODBC manually entered parameter" -- It allows me to enter driver name, and works (makes a connection), except that during the migration actual migration, it fails on the initial call to "TABLEs" when examining the schema.

I'm sort of stuck.... any ideas?

Options: ReplyQuote

Written By
Migration using ODBC drivers
May 18, 2018 03:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.