<br><br><div class="gmail_quote">2009/9/29 Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com">marianopeck@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote">2009/9/29 Herbert König <span dir="ltr"><<a href="mailto:herbertkoenig@gmx.net" target="_blank">herbertkoenig@gmx.net</a>></span><div class="im"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello Mariano Norbert,<br>
<br>
wouldn't the cheapest way be to just build a special case into<br>
SqueakDBX error handling that could be activated via some option?<br>
<br></blockquote></div><div><br>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. <br> <br>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?<br>
</div></div></blockquote><div><br>Can you put a breakpoint in DBXPlatform>>errorCode:handle:<br><br>And then when you have the error "unknown system variable" debug it and tell me the values of "err" and "description" please ?<br>
<br>Cheers,<br><br>Mariano<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div>
<br></div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
It's a recoverable error after all.<br>
<br>
Same for OpenDBX, couldn't it just be an option? Me talking about<br>
something I know nothing about.<br>
<br>
And about supporting an extra built I'd say it's a pain that isn't<br>
worth it. (Talking about something I know). So it can either be a<br>
parameter in OpenDBX or it can be done in SqueakDBX.<br>
<br></blockquote></div><div><br>ok.<br> </div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
As time permits I will try a port to see if I find more problems than<br>
the recoverable connection error.<br>
<br>
I will let you know.<br>
<br></blockquote></div><div><br>Thanks.<br> </div><div><div></div><div class="h5"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Thanks<br>
<br>
Herbert<br>
MMP> 2009/9/29 Mariano Martinez Peck <<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>><br>
<br>
<br>
MMP> 2009/9/29 Norbert Sendetzky <<a href="mailto:norbert@linuxnetworks.de" target="_blank">norbert@linuxnetworks.de</a>><br>
<br>
MMP> Hi Mariano, Herbert<br>
<div><br>
>> Ok. Now it is almost working. He is using the MySQL 5 client library to<br>
>> talk to a MySQL 4.0.15 server. I saw this:<br>
>><br>
<br>
>> The problem now is that when he is trying to open the connection<br>
>> (odbx_bind) he gets a "unknown system variable "sql_mode"".<br>
>> I looked in OpenDBX code and you don't have "sql_mode" in your source code.<br>
<br>
<br>
</div>MMP> It's in backends/mysql/mysql_basic.c, line 761 (trunk)<br>
<br>
<br>
<br>
<br>
MMP> Wow....my total commander didn't find it....weird :(<br>
MMP> <br>
<br>
MMP> Unfortunately, sql_mode is only supported since 4.1, so it's not possible to<br>
MMP> connect to a MySQL 4.0 server using the standard OpenDBX source. The only way<br>
MMP> to use the library would be to comment out the call to mysql_priv_setmode() in<br>
MMP> line 197 and recompile but this would require to start the MySQL server in<br>
MMP> ANSI mode (--sql-mode=ANSI) to get the same behaviour.<br>
<br>
<br>
<br>
<br>
<br>
MMP> Thanks for the explanation Norbert. Now I am intrigued why<br>
MMP> OpenDBX needs to set something in that variable. I mean, what<br>
MMP> happens if you remove that call in line 197?<br>
<br>
<br>
<br>
<br>
<br>
<br>
MMP> Herbert if you want, I can compile a new dll with the<br>
MMP> changes Norbert said justto see if it works. Then you can decide<br>
MMP> if you want to use SqueakDBX orthe native driver :(<br>
<br>
MMP> For every new release of OpenDBX I can create a special<br>
MMP> MySQL dll for4.0x MySQL compatibility. I have no problem at all<br>
MMP> doing that. It isjust a couple of minutes.<br>
<br>
MMP> Norbert: if this changes work, what do you think in<br>
MMP> including to the website a MySQL-4.0x special dll for every new<br>
MMP> release?<br>
<br>
MMP> Best,<br>
<br>
MMP> mariano<br>
<br>
MMP> <br>
MMP> Cheers,<br>
<br>
MMP> Mariano<br>
MMP> <br>
<br>
MMP> Norbert<br>
MMP> --<br>
MMP> OpenPGP public key<br>
MMP> <a href="http://www.linuxnetworks.de/norbert.pubkey.asc" target="_blank">http://www.linuxnetworks.de/norbert.pubkey.asc</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Thanks,<br>
<br>
Herbert mailto:<a href="mailto:herbertkoenig@gmx.net" target="_blank">herbertkoenig@gmx.net</a><br>
<br>
</blockquote></div></div></div><br>
</blockquote></div><br>