Hi there
I have set up a database link to connect to a MySQL database, however when I try to connect, I get the following error
An error was encountered performing the requested operation:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1. Please refer to the log file for details.
ORA-02063: preceding 2 lines from MYSQL_DB
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
Vendor code 28500
Does anybody have any idea what the problem could be? The MySQL database I am trying to connect is pre 4.1.1 and I am using the MySQL ODBC connector 3.5.1 driver. I am running Oracle 10g.
Any insight would be greatly appreciated. Thanks...