Question about libMySql.dll, MySql++ and MySql v4.1.1

[Tony Baker]

Hi, is there anything wrong with using and older version of
libMySql.dll to build version 1.7.1 of MySql++, which is then used by
my C++ programs (building with Visual Studio v6) to access MySql
v4.1.1? Things seem fine that way so far... Here's why I want to do
that:

a) I can't seem to find v1.7.9 of MySql++ that I can build with Visual
Studio v6 (i.e. no .dsw and project file, tried looking here
http://www.mysql.com/downloads/api-mysql++.html). Anyone have a link?

b) If I use the libMySql.dll that comes with version 4.1.1 of MySql,
build MySql++ with it and try to build my C++ programs, my programs
(at the end of building) produce the error:
mysql++.lib(connection.obj) : error LNK2001: unresolved external
symbol _mysql_connect@16

I guess I'm asking two things, is there anything wrong with using the
old libMySql.dll or can you help me solve that link error message!

Many thanks,

Tony.

P.S. One more thing, am I correct in assuming that libMySql.dll is
only there to pass commands to MySql and return results?

[Aggro]

Tony Baker wrote:

b) If I use the libMySql.dll that comes with version 4.1.1 of MySql,
build MySql++ with it and try to build my C++ programs, my programs
(at the end of building) produce the error:
mysql++.lib(connection.obj) : error LNK2001: unresolved external
symbol _mysql_connect@16

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.

Now, the problem is, that there is no mysql\cppinclude\ folder. You need
to create it, and get the files in it. There something like 70 or 80
files there, atleast some .hh type of files. You get them in a folder
with some of those mysql++-api things, but I don't remember more, and I
don't have Visual Studio here. But I hope this was some help to you.

[Aggro]

Tony Baker wrote:

b) If I use the libMySql.dll that comes with version 4.1.1 of MySql,
build MySql++ with it and try to build my C++ programs, my programs
(at the end of building) produce the error:
mysql++.lib(connection.obj) : error LNK2001: unresolved external
symbol _mysql_connect@16

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.

Now, the problem is, that there is no mysql\cppinclude\ folder. You need
to create it, and get the files in it. There something like 70 or 80
files there, atleast some .hh type of files. You get them in a folder
with some of those mysql++-api things, but I don't remember more, and I
don't have Visual Studio here. But I hope this was some help to you.

[Aggro]

Tony Baker wrote:

b) If I use the libMySql.dll that comes with version 4.1.1 of MySql,
build MySql++ with it and try to build my C++ programs, my programs
(at the end of building) produce the error:
mysql++.lib(connection.obj) : error LNK2001: unresolved external
symbol _mysql_connect@16

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.

Now, the problem is, that there is no mysql\cppinclude\ folder. You need
to create it, and get the files in it. There something like 70 or 80
files there, atleast some .hh type of files. You get them in a folder
with some of those mysql++-api things, but I don't remember more, and I
don't have Visual Studio here. But I hope this was some help to you.

[Tony Baker]

Thanks for your help, but unfortunatly that is nothing new to me!
Doing that with version 4.1.0 is fine, but won't work with 4.1.1 as I
guess they must have changed some connection method so it's no longer
compatable.
Bummer.

Still, can anyone explain the exact purpose of libMySql.dll to me
(does it simply/basically pass sql commands to MySql and return the
response?) and whether it is ok to use version 4.0 of libMySql.dll
with version 4.1.1 ?

I have been for a few days now, and everything seems just fine... so
far!

Cheers.

Tony.

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.

[Tony Baker]

Thanks for your help, but unfortunatly that is nothing new to me!
Doing that with version 4.1.0 is fine, but won't work with 4.1.1 as I
guess they must have changed some connection method so it's no longer
compatable.
Bummer.

Still, can anyone explain the exact purpose of libMySql.dll to me
(does it simply/basically pass sql commands to MySql and return the
response?) and whether it is ok to use version 4.0 of libMySql.dll
with version 4.1.1 ?

I have been for a few days now, and everything seems just fine... so
far!

Cheers.

Tony.

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.

[Tony Baker]

Thanks for your help, but unfortunatly that is nothing new to me!
Doing that with version 4.1.0 is fine, but won't work with 4.1.1 as I
guess they must have changed some connection method so it's no longer
compatable.
Bummer.

Still, can anyone explain the exact purpose of libMySql.dll to me
(does it simply/basically pass sql commands to MySql and return the
response?) and whether it is ok to use version 4.0 of libMySql.dll
with version 4.1.1 ?

I have been for a few days now, and everything seems just fine... so
far!

Cheers.

Tony.

I will try to tell how how to do it, but I don't remember it perfectly:

1. Somewhere at the project settings there is a "link" tab, where you
need to add: mysql++.lib (Make sure you are assigning it to both debug
and release versions, or you run into problems later when trying to
build release version)
2. Somewhere there are other settings that affect all VC projects, where
you assign the library and include paths. There you need to add
This to library path:
c:\mysql\lib\opt\
And these to include path:
c:\mysql\include\
c:\mysql\cppinclude\
3. You need to add
#include <mysql++>
At the beginning of the file, where you use mysql++ stuff.