unable to load libmysql.dll

Juan Ortanobas

unread,

Oct 28, 2007, 4:57:07 PM10/28/07

to

Hi guys,

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

Bill Todd

unread,

Oct 28, 2007, 5:00:48 PM10/28/07

to

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.

--
Bill Todd (TeamB)

Marco Caspers

unread,

Oct 30, 2007, 5:54:31 AM10/30/07

to

Bill Todd wrote:

> 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..

--

Anthony Williams

unread,

Oct 30, 2007, 7:19:21 AM10/30/07

to

"Juan Ortanobas" <bo...@boostnetwork.net> writes:

> 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

Bill Todd

unread,

Oct 30, 2007, 9:54:23 AM10/30/07

to

Marco Caspers wrote:

> 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)

Stephane Wirtel

unread,

Nov 13, 2007, 7:22:09 AM11/13/07

to

Bill Todd a écrit :

> 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.
>

You can use mysql 4 or 5 with D6, D7, I don't see why you can't to use it.

Bill Todd

unread,

Nov 13, 2007, 8:51:34 AM11/13/07

to

Stephane Wirtel wrote:

> 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)

teo

unread,

Jan 26, 2008, 5:33:28 PM1/26/08

to

Juan Ortanobas schreef:

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