There's documentation? ;-o It just worked 'straight out of the box', not that I was trying to do anything difficult. Just connect to a MySQL database using dbExpress was a real pain.
I can highly recommend the ZEOS components (version 6.6.1 beta), I will recommend it even higher if I ever find the documentation ;-) Paul > ----- Original Message ----- > From: "David Smith" <[EMAIL PROTECTED]> > To: [email protected] > Subject: Re: [delphi-en] Re: Problem connecting to MySQL database with > dbExpress > Date: Thu, 6 Sep 2007 07:02:06 -0700 (PDT) > > > That's good to know Paul, I had the same kinds of problems trying > to get ZEOS to work a while back.. they must have improved it and > the documentation. > > Dave > > Paul Bennett <[EMAIL PROTECTED]> wrote: > Cheers Dave, > > Sorry for the delay in replying, been away on long weekend! > > I decided that dbexpress was just to hard to get working, so I > switched to ZEOS 6.6 Beta and all is now sweetness and light. > > Everything worked at the first attempt. > > Paul > > > ----- Original Message ----- > > From: "Dave Murray" <[EMAIL PROTECTED]> > > To: [email protected] > > Subject: [delphi-en] Re: Problem connecting to MySQL database > with dbExpress > > Date: Fri, 31 Aug 2007 14:11:16 -0000 > > > > > > 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. > > > > > > > > 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 > > > > > > --------------------------------- > Choose the right car based on your needs. Check out Yahoo! Autos > new Car Finder tool. > > [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
