[Lazarus] MySQL 5.1

[Andrew Brunner]

Hi Michael,

I have a wrapper API for SQL Database access.  I support MySQL by way
of TMySQL50Connection.  Since my system has the client and server at
5.1 and I can hard-code this new component so I don't throw the
exception...

Will an exception be thrown for all users who try to use client/server
5.0 when the actual component is assigned as TMySQL51Connection?  Is
TMySQL51Connection backwards compatible to 5.0?

I'm hoping I don't need to expand my Database API to handle the many
flavors of MySQL.

Thanks for your insight.

2010/9/18 Michael Van Canneyt <michael at freepascal.org>:
>
> Hello,
>
> There is a new TMySQL51Connection component that is suitable for use with
> MySQL 5.1.
> Therefor, TMySQL50Connection now no longer supports 5.1 connections.
>
> You should use the new TMySQL51Connection instead, but you'll need to
> recompile FPC and sqldblaz to see it on the component palette (I just
> committed the SQLDBlaz support for 5.1)
>
> Michael.
>
> On Fri, 17 Sep 2010, Andrew Brunner wrote:
>
>> No there was no problem a few versions ago. Someone had to change
>> something that created this issue.
>>
>> Anyone else???
>>
>> On Sep 17, 2010, at 5:07 PM, ik <idokan at gmail.com> wrote:
>>
>>      MySQL changes it's API call every version that is out, regardless how
>> small that version is. So in order to provide the proper API you need to
>> apply your
>>      code to specific MySQL version.
>>
>>      Personally I recommend everyone to stay away from this database:
>> http://idkn.wordpress.com/2009/03/15/why-i-find-mysql-to-be-so-bad/
>>
>>      Ido
>>
>>      On Fri, Sep 17, 2010 at 23:37, Andrew Brunner
>> <andrew.t.brunner at gmail.com> wrote:
>>            Hi there,
>>
>>            TApplication.HandleException TMySQL50Connection can not work
>> with the
>>            installed MySQL client version: Expected (5.0), got (5.1.49).
>>
>>            I'm getting this error when I try to connect to my db.
>>
>>
>>            Free Pascal Compiler from SVN...
>>            At revision 16002.
>>            Lazarus from SVN...
>>            At revision 27399.
>>
>>            I've never had this problem before.  I did recently upgrade to
>> Ubuntu
>>            10.10 daily though.  The box I'm on is the server and the
>> client.
>>
>>            Any help would be greatly appreciated.
>>
>>            --
>>            _______________________________________________
>>            Lazarus mailing list
>>            Lazarus at lists.lazarus.freepascal.org
>>            http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>>
>>
>>      --
>>      _______________________________________________
>>      Lazarus mailing list
>>      Lazarus at lists.lazarus.freepascal.org
>>      http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>>
>>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>
>