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

Martin Evans martin.evans at easysoft.com
Thu Feb 8 15:58:27 GMT 2007


Buecker, Martin wrote:
> 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

Martin,

Are you looking at the log files you post here?

It says

"Transactions are not enabled"

and

"Underlying server does not support transactions, upgrade to version >= 
3.23.38"

Looks like you need a version of mysql odbc driver (and/or server) which 
supports transactions. Also, I don't know how it affects the mysql ODBC 
driver but I believe you can only really have transactions (at the 
server end) if you are using innodb.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com



More information about the unixODBC-support mailing list