Re: [opendbx] Should MySQL 4.0.15. work with OpenDBX ?

[Mariano Martinez Peck]

2009/9/29 Norbert Sendetzky <norb...@linuxnetworks.de>

> 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)
>

Wow....my total commander didn't find it....weird :(


>
> 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.
>
>
Thanks for the explanation Norbert. Now I am intrigued why OpenDBX needs to
set something in that variable. I mean, what happens if you remove that call
in line 197?

Cheers,

Mariano


>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry&reg; 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&#45;12, 2009. Register now&#33;
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