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
