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?