I was drawing from my experience with ADS server. it appears to be ignoring the ip address you configured in the Host param. I would try:
1 - putting a regular name for host parameter (pinging it first to see it if can be resolved. If not you need to configure an entry for it in DHCP or DNS server or enable WINS on your windows network). 2 - google "dbexpress" along with "Can't connect to MySQL server on 'localhost' (10061)" and see if anyone else has figured it out. 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. > Paul Bennett <[EMAIL PROTECTED]> 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] > 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 --------------------------------- Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. [Non-text portions of this message have been removed]
