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. > 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 --------------------------------- Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. [Non-text portions of this message have been removed]
