AW: [unixODBC-support] Could not find symbol 'SQLAllocConnect'

Buecker, Martin Martin.Buecker at t-systems.com
Thu Feb 8 14:46:39 GMT 2007


Hello,

it seems that I now have the correct lib, now another error occurs

select count(*) from cr_bemerkung at mysql
                     *
ERROR at line 1:
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

Trace:
hoauldt (5): ; hoauldt Exited with retcode = 0.
hoabegn (9): ; hoabegn Entered. formatID = 306206, hoagttln = 31, hoagttid =
PBN.WORLD.fe06de28.18.91.253247, hoagtbln = 10, hoagtbid = ^R, tflag = 0,
initial = 1
e:1124 0 SQLGetConnectOption:- hdbc=31BBE0, fop=102 , pvprm=FFBEE464
e:1090 0 SQLGetInfo:- hdbc=31BBE0, fit=72 ,rif=ffbee388, civm=4, piv=0
e:1129 0 SQLTransact:- henv=0,hdbc=31BBE0, ftp=0
e:1134 0 SQLSetConnectOption:- hdbc=31BBE0, fop=108 , vprm=2
e:1139 -1 SQLSetConnectOption:- hdbc=31BBE0, fop=102 , vprm=0
i:1023 0 SQLError:- hnv=319970,hdbc=3259360,hst=0,sss=S1C00,pne=FFBEE1CC,
                cemm=-4267532,pem=1FF
           sem = [MySQL][ODBC 3.51 Driver]Transactions are not enabled
i:1023100 SQLError:- hnv=319970,hdbc=3259360,hst=0,sss=00000,pne=FFBEE1CC
                ,cemm=-4267532,pem=1FF
           sem = [MySQL][ODBC 3.51 Driver]Transactions are not enabled
errors.h (1141): ; [MySQL][ODBC 3.51 Driver]Transactions are not enabled (SQL
State: 00000; SQL Code: 4000)
DRV_TransBegin: errors.h (1141): ; [MySQL][ODBC 3.51 Driver]Transactions are
not enabled (SQL State: 00000; SQL Code: 4000)

e:1187 -1 SQLTransact:- henv=0,hdbc=31BBE0, ftp=1
i:1023 0 SQLError:- hnv=319970,hdbc=3259360,hst=0,sss=S1C00,pne=FFBEE07C,
                cemm=-4267868,pem=1FF
            sem = [MySQL][ODBC 3.51 Driver]Underlying server does not sup
               port transactions, upgrade to version >= 3.23.38
i:1023100 SQLError:- hnv=319970,hdbc=3259360,hst=0,sss=00000,pne=FFBEE07C
                ,cemm=-4267868,pem=1FF
            sem = [MySQL][ODBC 3.51 Driver]Underlying server does not sup
               port transactions, upgrade to version >= 3.23.38
errors.h (1189): ; [MySQL][ODBC 3.51 Driver]Underlying server does not support
transactions, upgrade to version >= 3.23.38 (SQL State: 00000; SQL Code: 536)
DRV_TransRollback: errors.h (1189): ; [MySQL][ODBC 3.51 Driver]Underlying
server does not support transactions, upgrade to version >= 3.23.38 (SQL
State: 00000; SQL Code: 536)

nvRETURN (./nav_tm.c 278): -1
nvRETURN (./nav_tm.c 141): -1
nvRETURN (./geterror.c 59): -1231
apiutil.c (913): ; [S1000] [9013]General error in nvITrans_BeginT - rc = -1.
Please refer to the log file for details.
HOabegn (9): ; hoabegn Exited with retcode = 28500.

Is this a problem on MySQL side?

Thanks and regards

Martin Buecker


-----Ursprüngliche Nachricht-----
Von: unixodbc-support-bounces at easysoft.com [mailto:unixodbc-support-bounces at easysoft.com] Im Auftrag von Nick Gorham
Gesendet: Donnerstag, 8. Februar 2007 12:53
An: Support for the unixODBC project
Betreff: Re: [unixODBC-support] Could not find symbol 'SQLAllocConnect'


Buecker, Martin wrote:

>Hello Norman,
>
>trying to read a table in the remote mysql db, I get the error:
>
>SQL> select count(*) from cr_bemerkung at mysql;
>select count(*) from cr_bemerkung at mysql
>                                  *
>ERROR at line 1:
>ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
>[Generic Connectivity Using ODBC][C078] Dynamic library
>'/usr/local/lib/mylibodbc3.so' was not found
>ORA-02063: preceding 2 lines from MYSQL
>
>  
>
Your oracle is 32 bit and trying to open a 32 bit lib.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support




More information about the unixODBC-support mailing list