ora28500 mysql_ORA-28500 and ORA-02063 while connecting MySQL from Oracle- — oracle-tech

Hi,

In your listener.ora for the DG4ODBC entry you had -

(ENVS=LD_LIBRARY_PATH = /usr/local/lib:/u01/app/oracle/product/11.2.0/dbhome_1/lib)

but this should also include the path for the driver manager directory which in your case is /usr/lib64 so could you add this ?

The error -

Failed to load ODBC library symbol: /usr/lib64/libmyodbc3.so(SQLSetDescRec)

indicates the /usr/lib64 directory cannot be accessed.

The entry should then look like -

(SID_DESC =

(PROGRAM = dg4odbc)

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

(SID_NAME = test)

(ENVS=LD_LIBRARY_PATH = /usr/local/lib:/usr/lib64:/u01/app/oracle/product/11.2.0/dbhome_1/lib)

)

The spaces may have bene lost when posting but there should be at least one space in the file as indicated by the .

After making the change then stop and start the listener.

If you still have problems then please post again the current versions of the configuration files, the full errors shown in SQLPLUS for a select and the output from a debug trace showing the errors.

The information shows you are using the 3.51 MySQL ODBC driver so could you also try with the latest version of the 5.1 driver and see if you have the same problem ?

Regards,

Mike

0