RE: [DUG] remote MySQL via dbExpress

David McNeill Sat, 18 Dec 2004 01:10:20 -0800

We use ZeosLib for remote MySQL, works well. Fast, easy to use.

Check you have the right version of libmysql.dll for your sql server, libmysql40.dll for 4.0 SQL servers, and it’s in the same dir as your exe.

DaveMc

McPond eCommerce Software

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

RE: [DUG] remote MySQL via dbExpress

Reply via email to