Need help setting up SQL

[423hURfi]

First, here is the quick summary of my project: I have a SQL database (mySQL) on a computer that runs linux and I want to build a program that runs on another computer (that runs on windows) and can access the database from there.

I initially tried using mysql-connector/c++ binary along with the required boost binary. That almost worked but apparently a .dll or .lib file or something (I was trying to use static setup so I thought I didn't need this) in the working directory was missing and I couldn't find it in its installed directory.

So I am hoping that someone can point me to another SQL c++ library that would be a lot easier to install and to setup in VS 2012. Or at least provide me with easy step-by-step instructions to build mysql-connector/c++ from source (because the only instructions I could find seem dated and a little hard to follow). Its not often I actually have to build things from source and it adds to the stress that I already have dealing with VS 2012 linker. Thanks in advance.

[coder777]

Take a look at the POCO library:

http://pocoproject.org/
http://pocoproject.org/docs/


There's also SOCI:

http://soci.sourceforge.net/

But I found that it's not that stable under windows