In my previous mysql++ installations I believe that mysql++ was using the libmysqld.dll
(the embedded server that it had linked to) to access the mysql database. So in this
case, users could run my mysql++ using applications without starting the Mysql Windows
Service.
And for these previous installations, running the Windows service version (C:\Program
Files\MySQL\MySQL Server 5.1\bin\mysqld) would block mysql++ access to the database
causing the mysql++ using application to hang until the Windows service was halted.
Only in the VS2008/mysql++ 3.0.9 case the applications require the Windows Service to be
running, which will not be the case on the systems of users who have the mysql++ using
applications installed on their systems.
----- Original Message -----
From: Adam Nielsen<mailto:adam.nielsen@stripped>
To: Thomas Volckhausen<mailto:TomVolckhausen@stripped>
Cc: plusplus@stripped<mailto:plusplus@stripped>
Sent: Thursday, November 19, 2009 5:11 PM
Subject: Re: VS2008 Examples Don't Connect Unless Windows Service Is Started Up?
> But the examples only connect to mysql if the "C:\Program
> Files\MySQL\MySQL Server 5.1\bin\mysqld" windows service is started
> up. Otherwise I get a connection failure like the following
> command-line text:
>
> C:\Documents and Settings\User\My Documents\My
> Downloads\mysqlplusplus\Copy of Copy of mysql++-3.0.9>exrun simple2
> -u mysqlpp_test -p nunyabinness DB connection failed: Can't connect
> to MySQL server on 'localhost' (10061)
That makes sense. You're trying to connect to a database server on your
local PC, but there is no database server running, hence "can't connect".
> If I start up the Mysql windows service I get the following
> successful result from the command-line:
>
> C:\Documents and Settings\User\My Documents\My
> Downloads\mysqlplusplus\Copy of Copy of mysql++-3.0.9>exrun simple2
> -u mysqlpp_test -p nunyabinness Item Num
> Weight Price Date
>
> N??rnberger Brats 97 1.5 8.79
> 2005-03-10 Pickle Relish 87 1.5 1.75
> 1998-09-04 Hot Mustard 73 0.95 0.97
> 1998-05-25 Hotdog Buns 65 1.1 1.10
> 1998-04-23
Now you are running a database server on your PC, so there is something
to connect to and retrieve data.
> In general my applications will not have the mysql windows service
> runnning, so does anyone know what switch/setting/etc. I need to
> modify to make the examples (and any other VS2008 mysql++ 3.0.9
> application ) connect to the database without having the mysql
> Windows service running??
I'm not sure I understand - you need to connect to a MySQL server
somewhere, be it on your local machine or an external server. If your
server is not on your local PC, change 'localhost' to point to the
server name.
Cheers,
Adam.
--
MySQL++ Mailing List
For list archives:
http://lists.mysql.com/plusplus<http://lists.mysql.com/plusplus>
To unsubscribe: http://lists.mysql.com/plusplus?unsub=1
