2009/9/29 Herbert König <herbertkoe...@gmx.net>
> Hello Mariano Norbert,
>
> wouldn't the cheapest way be to just build a special case into
> SqueakDBX error handling that could be activated via some option?
>
>
This, this can be perfectly done (I think). I also have thought in this
solution. I will review the code and commit a version so that you can test
it.
The thing is that I don't know what happens if you open a connection with
this error. What happens with all of the queries you do then ? will them
work?
It's a recoverable error after all.
>
> Same for OpenDBX, couldn't it just be an option? Me talking about
> something I know nothing about.
>
> And about supporting an extra built I'd say it's a pain that isn't
> worth it. (Talking about something I know). So it can either be a
> parameter in OpenDBX or it can be done in SqueakDBX.
>
>
ok.
> As time permits I will try a port to see if I find more problems than
> the recoverable connection error.
>
> I will let you know.
>
>
Thanks.
>
> Thanks
>
> Herbert
> MMP> 2009/9/29 Mariano Martinez Peck <marianop...@gmail.com>
>
>
> MMP> 2009/9/29 Norbert Sendetzky <norb...@linuxnetworks.de>
>
> MMP> 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.
>
>
> MMP> It's in backends/mysql/mysql_basic.c, line 761 (trunk)
>
>
>
>
> MMP> Wow....my total commander didn't find it....weird :(
> MMP>
>
> MMP> Unfortunately, sql_mode is only supported since 4.1, so it's not
> possible to
> MMP> connect to a MySQL 4.0 server using the standard OpenDBX source. The
> only way
> MMP> to use the library would be to comment out the call to
> mysql_priv_setmode() in
> MMP> line 197 and recompile but this would require to start the MySQL
> server in
> MMP> ANSI mode (--sql-mode=ANSI) to get the same behaviour.
>
>
>
>
>
> MMP> Thanks for the explanation Norbert. Now I am intrigued why
> MMP> OpenDBX needs to set something in that variable. I mean, what
> MMP> happens if you remove that call in line 197?
>
>
>
>
>
>
> MMP> Herbert if you want, I can compile a new dll with the
> MMP> changes Norbert said justto see if it works. Then you can decide
> MMP> if you want to use SqueakDBX orthe native driver :(
>
> MMP> For every new release of OpenDBX I can create a special
> MMP> MySQL dll for4.0x MySQL compatibility. I have no problem at all
> MMP> doing that. It isjust a couple of minutes.
>
> MMP> Norbert: if this changes work, what do you think in
> MMP> including to the website a MySQL-4.0x special dll for every new
> MMP> release?
>
> MMP> Best,
>
> MMP> mariano
>
> MMP>
> MMP> Cheers,
>
> MMP> Mariano
> MMP>
>
> MMP> Norbert
> MMP> --
> MMP> OpenPGP public key
> MMP> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thanks,
>
> Herbert mailto:herbertkoe...@gmx.net
>
>
------------------------------------------------------------------------------
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
