<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1479" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=919532621-16122004><FONT face=Arial
color=#0000ff size=2>Check your version of libMysql.dll. I had this
problem with an earlier version and got the latest which fixed the
problem</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=919532621-16122004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=919532621-16122004><FONT face=Arial
color=#0000ff size=2>also check where it is... If you have Delphi installed it
always uses the one on the Common Files/DBExpress. (trap for young
players)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=919532621-16122004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=919532621-16122004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Phil
Middlemiss<BR><B>Sent:</B> Friday, 17 December 2004 10:19 a.m.<BR><B>To:</B> NZ
Borland Developers Group - Delphi List<BR><B>Subject:</B> [DUG] remote MySQL via
dbExpress<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've configured the bdExpress control as
follows:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> object SQLConnection1:
TSQLConnection<BR> ConnectionName =
'MSConnection'<BR> DriverName = 'MYSQL'<BR>
GetDriverFunc = 'getSQLDriverMYSQL'<BR> LibraryName =
'dbexpmys.dll'<BR> Params.Strings =
(<BR>
'BlobSize=-1'<BR>
'Database=myDBname'<BR>
'DriverName=MYSQL'<BR>
'ErrorResourceFile='<BR>
'HostName=mtsl.co.nz'<BR>
'LocaleCode=0000'<BR>
'Password=mypassword'<BR>
'User_Name=myusername')<BR> VendorLib =
'libmySQL.dll'<BR> Left = 144<BR> Top =
40<BR> end<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any tips anyone?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cheers,</FONT></DIV>
<DIV><FONT face=Arial size=2>Phil.</DIV></FONT></BODY></HTML>