Dear Mr.Loskot,
Thank you for your help. I was using old solutions for Visual Studio. I will
try to use cmake.
Thank you
With Kind Regards
P.R.Dinesh
________________________________
From: Mateusz Loskot <[email protected]>
To: General-purpose list for SOCI users. <[email protected]>
Cc: Dinesh SOCI <[email protected]>
Sent: Sat, 23 October, 2010 8:49:42 PM
Subject: Re: [SOCI-users] SOCI MySQL and SQLite
On 23/10/10 14:07, Dinesh SOCI wrote:
> Dear SOCI-Users,
>
> I want to use SOCI with MySQL and SQLite. I used the latest SOCI from
> git repository. I tried to use Visual Studio to compile the SOCI. I
> have successfully compiled SQLite and Core Libraries, but couldnt find
> the MySQL Project in it.
How do you build SOCI?
Using the old solutions for the Visual Studio or the new CMake-based
configuration?
> Later I tried to compile MySQL on my own but
> end up in errors. From the Documentation page I found the following
> comments.
>
> "*NOTE:* Currently, MySQL backend compilation is not supported due to
> some problems with linking to MySQL client library. If you know how to
> use it from Visual C++ 2005 and without rebuilding MySQL libraries on
> your own, please let us know."
>
> Please let me know how to compile the MySQL library to link it with SQLite.
This note is relevant to the last stable release.
The Git repository has been undergoing serious updates with migration to
CMake as one of the most "revolutionary". Thus, the pre-configured
Visual Studio you can find in build directory are deprecated
and will be removed in the upcoming release.
Quick guide for using CMake:
git clone git://soci.git.sourceforge.net/gitroot/soci/soci
<you will get soci directory, don't enter it>
mkdir build
cmake-DWITH_MYSQL=ON -DWITH_SQLITE3=ON -G <your generator> ../soci
If you like, you can request to build tests adding
-DSOCI_TESTS=ON
with connection strings configured this way:
-DSOCI_MYSQL_TEST_CONNSTR:STRING="db=x user=y password=z"
The CONNSTR variables are named as SOCI_<BACKEND NAME>_TEST_CONNSTR
Here you can find more on running CMake:
http://www.cmake.org/cmake/help/runningcmake.html
Please try CMake and report details back in case of any problems.
I will help.
Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
