Hi Mariano, Herbert > Ok. Now it is almost working. He is using the MySQL 5 client library to > talk to a MySQL 4.0.15 server. I saw this: > > The problem now is that when he is trying to open the connection > (odbx_bind) he gets a "unknown system variable "sql_mode"". > I looked in OpenDBX code and you don't have "sql_mode" in your source code.
It's in backends/mysql/mysql_basic.c, line 761 (trunk) Unfortunately, sql_mode is only supported since 4.1, so it's not possible to connect to a MySQL 4.0 server using the standard OpenDBX source. The only way to use the library would be to comment out the call to mysql_priv_setmode() in line 197 and recompile but this would require to start the MySQL server in ANSI mode (--sql-mode=ANSI) to get the same behaviour. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
