[unixODBC-support] -

Nick Gorham nick at lurcher.org
Tue Oct 18 19:48:15 BST 2011


On 18/10/2011 16:51, Mani Athiappa Gounder (mgounder) wrote:
> 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

Well, you are getting a error back from the MySQL driver

[MySQL][ODBC 5.1 Driver][mysqld-5.1.22-rc]

So the unixODBC setup looks right

You can use isql in unixODBC to connect to the driver

isql -v dsn user password.

You may find that unixODBC or dg4odbc logging may give more clues. There 
is some info on the logging available here.

http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html

-- 
Nick

>
> > 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
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support



More information about the unixODBC-support mailing list