Thread: Re: Problem connecting to MySQL database with dbExpress
Re: Problem connecting to MySQL
database with dbExpress
United States
2007-08-31 09:11:16
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 delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, David Smith <djsmith_1998...>
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 <rm28157...> wrote:
> > ----- Original Message -----
> > From: "David Smith" <djsmith_1998...>
> > To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
> > 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.
>