[unixODBC-support] -

Mani Athiappa Gounder (mgounder) mgounder at cisco.com
Tue Oct 18 16:51:38 BST 2011


We are tyring to connect from oracle 11g database driver dg4odbc to
connect to mysql database.
We are using UnixODBC-2-3-0 as odbc driver to make whole connection to
work.

I am getting the below error while accessing from oracle via Database
link. 

ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[MySQL][ODBC 5.1 Driver][mysqld-5.1.22-rc]You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near
'"model",A1."model_desc",A1."end_of_sale_date",A1."end_of_renewal_date",
A1."end_o' at line 1 {42000,NativeErr = 1064}
ORA-02063: preceding 2 lines from MYODBC5

To isolate issue and make sure odbc driver is working fine, could you
help me to provide the steps
On how to test connecitivity using ODBC-driver

>From my Red-hat Lunix 
-sh-3.00$  cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 6)


MYSQLODBC driver: /mysqlodbc/odbc-5.1.8/lib/libmyodbc5.so


UnixODBC-2.3.0 version/Libs  as below 

/d22/gateway/db/mysqlodbc/unixODBC-2.3.0/lib
-sh-3.00$ ll
total 2208
-rwxr-xr-x  1 oradev dba     989 Sep 12 19:51 libodbccr.la
lrwxrwxrwx  1 oradev dba      18 Sep 12 19:55 libodbccr.so ->
libodbccr.so.1.0.0
lrwxrwxrwx  1 oradev dba      18 Sep 12 19:55 libodbccr.so.1 ->
libodbccr.so.1.0.0
-rwxr-xr-x  1 oradev dba  459334 Sep 12 19:51 libodbccr.so.1.0.0
-rwxr-xr-x  1 oradev dba    1001 Sep 12 19:51 libodbcinst.la
lrwxrwxrwx  1 oradev dba      20 Sep 12 19:55 libodbcinst.so ->
libodbcinst.so.1.0.0
lrwxrwxrwx  1 oradev dba      20 Sep 12 19:55 libodbcinst.so.1 ->
libodbcinst.so.1.0.0
-rwxr-xr-x  1 oradev dba  361695 Sep 12 19:51 libodbcinst.so.1.0.0
-rwxr-xr-x  1 oradev dba     977 Sep 12 19:51 libodbc.la
lrwxrwxrwx  1 oradev dba      16 Sep 12 19:55 libodbc.so ->
libodbc.so.1.0.0
lrwxrwxrwx  1 oradev dba      16 Sep 12 19:55 libodbc.so.1 ->
libodbc.so.1.0.0
-rwxr-xr-x  1 oradev dba 1408651 Sep 12 19:51 libodbc.so.1.0.0



Could you help to provie steps on how to test the Driver Manager
unixODBC-2.3.0  and Driver mysqlodbc/odbc-5.1.8 connections
Before I intergrate with oracle environment.

Thanks
Mani



More information about the unixODBC-support mailing list