2009/9/29 Mariano Martinez Peck <marianop...@gmail.com>
>
>
> 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?
>
Herbert if you want, I can compile a new dll with the changes Norbert said
just to see if it works. Then you can decide if you want to use SqueakDBX or
the native driver :(
For every new release of OpenDBX I can create a special MySQL dll for 4.0x
MySQL compatibility. I have no problem at all doing that. It is just a
couple of minutes.
Norbert: if this changes work, what do you think in including to the website
a MySQL-4.0x special dll for every new release?
Best,
mariano
> Cheers,
>
> Mariano
>
>
>>
>> Norbert
>> --
>> OpenPGP public key
>> http://www.linuxnetworks.de/norbert.pubkey.asc
>>
>>
>
------------------------------------------------------------------------------
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
