Board index » delphi » MySql - newbie Q.: "Unable to Load LIBMYSQL.dll"
MySql - newbie Q.: "Unable to Load LIBMYSQL.dll"
2004-11-07 10:10:45 PM
I've installed mySQL (as a service), I can see mysqld-nt.exe in
TaskManager, and running
mysqlshow mysql -u root -p
returns a list of tables in the standard mysql database (after prompting
for the password).
Starting with File|New|Application, I placed a TSQLConnection
(dbExpress) component on the form and filled in some fields in the
Params property. This is how it looks:
object cnTEST: TSQLConnection
ConnectionName = 'MSConnection'
DriverName = 'MYSQL'
GetDriverFunc = 'getSQLDriverMYSQL'
LibraryName = 'dbexpmys.dll'
Params.Strings = (
VendorLib = 'LIBMYSQL.dll'
This is meant to connect to the database (mysql) I tested with mysqlshow
When I try to set the "Connected" property to true, I get an error:
Unable to Load LIBMYSQL.dll
LIBMYSQL.dll resides on the folder where it was installed, and I have also
tried to copy it to WINNT, WINNT/system32 and the folder of the new app.
Still the same error.
I've downloaded a trial version og mysqldac (not installed yet) - will
this make life easier? Any recommendations for a set of components?
I will just use this to transfer some data from another database -
nothing advanced at all.