Re: Re: Problem connecting to MySQL database with dbExpress

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 -----
&gt; From: "David Smith"; < djsmith_1998%40yahoo.com">djsmith_1998yahoo.com>
>; To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
&gt; Subject: Re: [delphi-en] Re: Problem connecting to MySQL database with dbExpress
> Date: Thu, 6 Sep 2007 07:02:06 -0700 (PDT)
&gt;
>
> 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 < rm28157%40operamail.com">rm28157operamail.com> wrote:
> Cheers Dave,
&gt;
> 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.
&gt;
> Everything worked at the first attempt.
>
> Paul
>;
> > ----- Original Message -----
&gt; > From: "Dave Murray&quot; < irongut%40paranoia.clara.co.uk">irongutparanoia.clara.co.uk>
&gt; > To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
&gt; > Subject: [delphi-en] Re: Problem connecting to MySQL database
> with dbExpress
> > Date: Fri, 31 Aug 2007 14:11:16 -0000
&gt; >
>; >
>; > 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.
&gt; >
>; > Dave Murray
&gt; > Glasgow, UK
> >
>; >
>; >
>; > --- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, David Smith <djsmith_1998...>
> > wrote:
&gt; > >
>; > > 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?
&gt; > >
>; > > Dave
>; > >
>; > > Paul Bennett <rm28157...> wrote:
&gt; > > > ----- Original Message -----
&gt; > > > From: "David Smith"; <djsmith_1998...>
> > > > To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
&gt; > > > Subject: Re: [delphi-en] Problem connecting to MySQL database
> > with dbExpress
> > > > Date: Wed, 29 Aug 2007 10:10:56 -0700 (PDT)
&gt; > > > > > 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,
&gt; > >
>; > > 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!
&gt; > >
>; > > dbxdrivers.ini
> > > ...
> > > [MySQL]
> > > GetDriverFunc=getSQLDriverMYSQL
> > > LibraryName=dbexpmysql.dll
&gt; > > VendorLib=libmysql50.dll
> > > HostName=ServerName
> > > Database=DBNAME
>; > > User_Name=user
> > > Password=password
&gt; > > BlobSize=-1
> > > ErrorResourceFile=
> > > LocaleCode=0000
>; > >
>; > > dbxconnections.ini
> > > ...
> > > [MySQLConnection]
&gt; > > DriverName=MySQL
&gt; > > HostName=10.2.200.224
> > > Database=pheonix
&gt; > > User_Name=PheonixAdmin
> > > Password=******
&gt; > > BlobSize=-1
> > > ErrorResourceFile=
> > > LocaleCode=0000
>; > >
>; > > any other ideas??
> > >
>; > > Paul.
&gt; > >
>;
> >
>;
> 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.
&gt;
> [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

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Hi Paul,

Good to hear you've got Zeos working. I tried using Zeos with SQLite
last month and gave up after a few days because the Aducom components
were much easier to use. I couldn't find the documentation either and I
spent a couple of days reading their websites and forums.

Out of interest, anyone else using SQLite? What components do you
recommend? I'm using the Aducom components here:

http://www.aducom.com/cen/news.php

Thanks,
Dave.

Dave Murray
Glasgow, UK

--- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "Paul Bennett&quot; <rm28157...> wrote:
&gt;
>
> 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.
&gt;
> 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
>;

Messages in this topic (0) Reply (via web post) | Start a new topic

.