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. >
