Re: [DUG] remote MySQL via dbExpress

Sun, 19 Dec 2004 15:45:54 -0800

I tried ZeosLib and a few other options.. I'm not entirely sure, but I think ZeosLib opened up a connection on the mysql server for each query which I did not like.
 
I'm currently using the Microolap alternative and it works really well.
 
Matt.
----- Original Message -----
Sent: Monday, December 20, 2004 10:22 AM
Subject: RE: [DUG] remote MySQL via dbExpress

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
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to