List Info

Thread: Problem connecting to MySQL database with dbExpress




Problem connecting to MySQL database with dbExpress
country flaguser name
United States
2007-08-29 10:27:06

Hi all,

I am trying to connect to a MySQL database using dbexpress (delphi 7
enterprise on Win XP PC). MySQL is located on one of our servers

I have setup the params thus:

DriverName=MySQL
HostName=10.2.200.224
Database=pheonix
User_Name=PheonixAdmin
Password=*******
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000

The path to MySQL is correct and the user/password are good When I
try to connect the login box appears as expected but I get the
following error message after entering the username/password:

dbExpress Error: [0x000C] Invalid Username/Password
SQL Server Error: Can't connect to MySQL server on 'localhost' (10061)

Since I have already set the Hostname in the params, and the database
login box is displayed, I don't understand the reference to
'localhost'!!

Anyone have any idea whats going on here??

Paul.

__._,_.___
.

__,_._,___
Re: Problem connecting to MySQL database with dbExpress
country flaguser name
United States
2007-08-29 12:10:56

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

Paul Bennett < rm28157%40operamail.com">rm28157operamail.com> wrote:
Hi all,

I am trying to connect to a MySQL database using dbexpress (delphi 7
enterprise on Win XP PC). MySQL is located on one of our servers

I have setup the params thus:

DriverName=MySQL
HostName=10.2.200.224
Database=pheonix
User_Name=PheonixAdmin
Password=*******
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000

The path to MySQL is correct and the user/password are good When I
try to connect the login box appears as expected but I get the
following error message after entering the username/password:

dbExpress Error: [0x000C] Invalid Username/Password
SQL Server Error: Can't connect to MySQL server on 'localhost' (10061)

Since I have already set the Hostname in the params, and the database
login box is displayed, I don't understand the reference to
'localhost'!!

Anyone have any idea whats going on here??

Paul.

---------------------------------
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )