Cheers Dave, Sorry for the delay in replying, been away on long weekend!
I decided that dbexpress was just to hard to get working, so I switched to ZEOS 6.6 Beta and all is now sweetness and light. Everything worked at the first attempt. Paul > ----- Original Message ----- > From: "Dave Murray" <[EMAIL PROTECTED]> > To: [email protected] > Subject: [delphi-en] Re: Problem connecting to MySQL database with dbExpress > Date: Fri, 31 Aug 2007 14:11:16 -0000 > > > Hi, > > The property value '10.2.200.224' in dbxconnections.ini is an IP > address not a host name. Also you seem to have specified this > property as 'ServerName' in dbxdrivers.ini. You should specify the > host name of the same server in both these properties. > > Dave. > > Dave Murray > Glasgow, UK > > > > --- In [email protected], David Smith <[EMAIL PROTECTED]> > wrote: > > > > The help file says you're supposed to use dbexpress components with > a TClientDataset.. which probably means a TProvider component as > well. Are you doing all of that? > > > > Dave > > > > Paul Bennett <[EMAIL PROTECTED]> wrote: > > > ----- Original Message ----- > > > From: "David Smith" <[EMAIL PROTECTED]> > > > To: [email protected] > > > Subject: Re: [delphi-en] Problem connecting to MySQL database > with dbExpress > > > Date: Wed, 29 Aug 2007 10:10:56 -0700 (PDT) > > > > > It thinks that the SQL server is local. I would say that you > have > > > the db driver configured for local mode. Look around for a > setting > > > to get it to look on a remote machine. > > > > Dave > > > Thanks for the reply Dave, > > > > I've checked the MySQL sections in dbxconnections.ini and > dbxdrivers.ini and can't find any entry that would configure the > driver to local mode! > > > > dbxdrivers.ini > > ... > > [MySQL] > > GetDriverFunc=getSQLDriverMYSQL > > LibraryName=dbexpmysql.dll > > VendorLib=libmysql50.dll > > HostName=ServerName > > Database=DBNAME > > User_Name=user > > Password=password > > BlobSize=-1 > > ErrorResourceFile= > > LocaleCode=0000 > > > > dbxconnections.ini > > ... > > [MySQLConnection] > > DriverName=MySQL > > HostName=10.2.200.224 > > Database=pheonix > > User_Name=PheonixAdmin > > Password=****** > > BlobSize=-1 > > ErrorResourceFile= > > LocaleCode=0000 > > > > any other ideas?? > > > > Paul. > > > Experience is something you don't get until just after you need it. -- _______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 9 at http://www.opera.com Powered by Outblaze
