RE: [DUG] remote MySQL via dbExpress

Jason Saggers Sun, 19 Dec 2004 13:23:29 -0800

Yes, that was the one I was referring to. Very easy and reliable.

And yes, you need to ether fully path the dll or have it in the EXE directory.

Jason

From: David McNeill [mailto:[EMAIL PROTECTED]
Sent: Saturday, 18 December 2004 10:10 p.m.
To: 'NZ Borland Developers Group - Delphi List'
Cc: [EMAIL PROTECTED]
Subject: RE: [DUG] remote MySQL via dbExpress

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