Description:
I am trying to migrate an Oracle database to a MySQL database using MySQL Workbench. I created an ODBC connection to the database schema in Oracle. Under "Source Selection", I selected "Generic RDBMS" for the database systesm, "ODBC Data Source" as the connection method and for the DSN used the ODBC connection I created earlier. I Clicked on "Test Connection" and I get an error message. This is the content of the error message "Could not connect to Source DBMS. Error("(108004', '[08004][ODBC][Ora]ORA-12154:TNS:could not resolve the connect identifier specified\n(12154)(SQL DriverConnect')"): error calling Python module function DbGenericRE.connect ODBC connection string: DSN:abc;PWD=W@sh1ngt0N"
----- Developer Notes -----
MySQL Workbench CE for Windows version 5.2.41 revision 9727
Configuration Directory: C:\Users\Santhosh.Balla\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM) i5-2520M CPU @ 2.50GHz, 3.9 GiB RAM
Active video adapter (0): Intel(R) HD Graphics Family
Installed video RAM: 1797 MB
Current video mode: 1366 x 768 x 4294967296 colors
Used bit depth: 32
Driver version: 8.15.10.2321
Installed display drivers: igdumd64.dll,igd10umd64.dll,igd10umd64.dll,igdumdx32,igd10umd32,igd10umd32
Active video adapter (1): LANDesk Remote Control Mirror Driver
Installed video RAM: 0 MB
Current video mode: 1680 x 1050 x 4294967296 colors
Used bit depth: 32
Driver version: 9.0.0.0
Installed display drivers: NULL
Current user language: English (United States)
How to repeat:
1. Create an ODBC connection to an Oracle database.
2. Use MySQL Workbench Migration, under Source RDBMS Connection Parameter, use Generic RDBMS as the Database System and ODBC Data Source as the Connection Method.
3. Select the DSN entry you created before
4. Click Test Connection.
Description: I am trying to migrate an Oracle database to a MySQL database using MySQL Workbench. I created an ODBC connection to the database schema in Oracle. Under "Source Selection", I selected "Generic RDBMS" for the database systesm, "ODBC Data Source" as the connection method and for the DSN used the ODBC connection I created earlier. I Clicked on "Test Connection" and I get an error message. This is the content of the error message "Could not connect to Source DBMS. Error("(108004', '[08004][ODBC][Ora]ORA-12154:TNS:could not resolve the connect identifier specified\n(12154)(SQL DriverConnect')"): error calling Python module function DbGenericRE.connect ODBC connection string: DSN:abc;PWD=W@sh1ngt0N" ----- Developer Notes ----- MySQL Workbench CE for Windows version 5.2.41 revision 9727 Configuration Directory: C:\Users\Santhosh.Balla\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE Cairo Version: 1.8.8 OS: Microsoft Windows 7 Service Pack 1 (build 7601), 64-bit CPU: 4x Intel(R) Core(TM) i5-2520M CPU @ 2.50GHz, 3.9 GiB RAM Active video adapter (0): Intel(R) HD Graphics Family Installed video RAM: 1797 MB Current video mode: 1366 x 768 x 4294967296 colors Used bit depth: 32 Driver version: 8.15.10.2321 Installed display drivers: igdumd64.dll,igd10umd64.dll,igd10umd64.dll,igdumdx32,igd10umd32,igd10umd32 Active video adapter (1): LANDesk Remote Control Mirror Driver Installed video RAM: 0 MB Current video mode: 1680 x 1050 x 4294967296 colors Used bit depth: 32 Driver version: 9.0.0.0 Installed display drivers: NULL Current user language: English (United States) How to repeat: 1. Create an ODBC connection to an Oracle database. 2. Use MySQL Workbench Migration, under Source RDBMS Connection Parameter, use Generic RDBMS as the Database System and ODBC Data Source as the Connection Method. 3. Select the DSN entry you created before 4. Click Test Connection.