Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows:

Database System: Generic RDBMS 
Connection Method: ODBC(Manually Entered parameters)
Driver:Oracle RDB driver
Hostname: 127.0.0.1  Port:1521
Username: user
Database:db

But I seem to be receiving the following error when testing the connection:

ERROR: Error during Connect to source DBMS: Error("('HY093', '[HY093] [Oracle][ODBC]
[Rdb]Invalid parameter number. (-2000) (SQLDriverConnect);

[HY093] [Oracle][ODBC][Rdb]Invalid parameter number. (-2000)')"):
error calling Python module function DbGenericRE.connect

I am struggling to figure out what parameter is wrong, any one have an idea what could be causing this?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.