<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>In playing with it in the past, I have found that
it works slightly differently on a development machine than on a client machine.
But check the following.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1. Database driver dll is in project
directory</FONT></DIV>
<DIV><FONT face=Arial size=2>2. Midas.dll is in the client directory... (not
entirely sure if required, best practice or licensing issues...).</FONT></DIV>
<DIV><FONT face=Arial size=2>3. dbxconnection.ini and dbxdriver.ini file in the
project directory also.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>You will find that if running on your dev machine
that it will load the connection and driver files from the borland common
files/dbexpress directory from memory... so thats a bit of a
gotcha.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Matt.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=matt@ferndigital.com href="mailto:matt@ferndigital.com">Matt Comb</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">NZ Borland Developers Group - Delphi
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 17, 2004 4:04
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [DUG] remote MySQL via
dbExpress</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Have you tried putting the database driver dll in
your project directory ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Matt.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=phil@tumonz.co.nz href="mailto:phil@tumonz.co.nz">Phil
Middlemiss</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">NZ Borland Developers Group - Delphi
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 17, 2004 10:18
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [DUG] remote MySQL via
dbExpress</DIV>
<DIV><BR></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>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BODY></HTML>