I'm trying to connect to mysql 5.0 from delphi 7.
The thing is that no matter where libmysql.dll is when opening the database
connection an error raises "unable to load libmysql.dll".
I have read older post at google groups and here, but sadly failed to find a
solution to my problem
this is very disapointing if someone may please let me know what am I doing
wrong it would be very much appreciated.
I have assured that libmysql.dll is accessible to delphi via PATH
environment variable.
any help please?
thanks
Juan Ortanobas
> I'm trying to connect to mysql 5.0 from delphi 7.
I am not a MySQL user but I do recall that D7 does not support MySQL 5.
--
Bill Todd (TeamB)
> Juan Ortanobas wrote:
>
> > I'm trying to connect to mysql 5.0 from delphi 7.
>
> I am not a MySQL user but I do recall that D7 does not support MySQL
> 5.
Nothing from Borland connects to MySQL 5.
The only exception might be D2007 (didn't test), but that's CodeGear..
--
> I'm trying to connect to mysql 5.0 from delphi 7.
Which driver are you using?
As others have said, the Borland drivers don't work with MySQL 5, you need a
third-party driver for that, such as our free (LGPL) dbxexpress drivers for
MySQL 5:
http://www.justsoftwaresolutions.co.uk/delphi/dbexpress_and_mysql_5.html
Anthony
--
Anthony Williams
Just Software Solutions Ltd - http://www.justsoftwaresolutions.co.uk
Registered in England, Company Number 5478976.
Registered Office: 15 Carrallack Mews, St Just, Cornwall, TR19 7UL
> Nothing from Borland connects to MySQL 5.
> The only exception might be D2007 (didn't test), but that's CodeGear..
I believe you will find that D2007 does support MySQL 5.
--
Bill Todd (TeamB)
> You can use mysql 4 or 5 with D6, D7, I don't see why you can't to
> use it.
The question was specifically about using dbExpress. The Borland
dbExpress driver for MySQL in D7 does not support MySQL 5. If you want
to connect to MySQL 5 in D7 you have to use a third party driver or a
different component set, for example, ADO.
--
Bill Todd (TeamB)
Hello Juan,
The error depends on what components you use.. I know this from Zeos
where the libmysql.dll should be named after the MySQL version you select.
Maybe this helps.
Regards,
Teo