Check your version of libMysql.dll.  I had this problem with an earlier version and got the latest which fixed the problem
 
also check where it is... If you have Delphi installed it always uses the one on the Common Files/DBExpress. (trap for young players)
 
 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Middlemiss
Sent: Friday, 17 December 2004 10:19 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] remote MySQL via dbExpress

Hi all, due to mail server difficulties I have not received any responses (or even my earlier post) about connecting to MySQL (if there were any). But I've had a go at configuring a connection to MySQL. When ever I try to establish the connection I get an eDatabaseError "Unable to Load libmySQL.dll". I do have MySQL loaded locally on my machine.
 
I've configured the bdExpress control as follows:
 
  object SQLConnection1: TSQLConnection
    ConnectionName = 'MSConnection'
    DriverName = 'MYSQL'
    GetDriverFunc = 'getSQLDriverMYSQL'
    LibraryName = 'dbexpmys.dll'
    Params.Strings = (
      'BlobSize=-1'
      'Database=myDBname'
      'DriverName=MYSQL'
      'ErrorResourceFile='
      'HostName=mtsl.co.nz'
      'LocaleCode=0000'
      'Password=mypassword'
      'User_Name=myusername')
    VendorLib = 'libmySQL.dll'
    Left = 144
    Top = 40
  end
 
Any tips anyone?
 
Cheers,
Phil.
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to