Original Post
I''m working on a project where I will need to fetch data from Microsoft SQL Server. Previously I have only worked with MySQL, and then using the MySQL++ API.
While researching on how I should go about connecting to MS SQL Server, I discover a (percieved) djungle of ways to do it. There is DAO, ADO, DAC, ODBC, ABCDE, ADACDOADAODBCD... and whatnot that Microsoft suggest, and another thousand 3rd party wrappers and APIs out there. Too many choices can be bad.
I don''t know exactly how ODBC works, but as I figure you use some "connector" that must be setup/installled previously. I''d like to avoid something like that, if possible.
I don''t really feel motivated to read up on each and every API to determine which API is best, as I doubt not that almost all would do. I''ve seen some samples using some MFC class, but I will NOT convert my project to MFC. Is there a way to use those classes without MFC?
So, my question is, what API is easiest to use? Also including if it enables me do implement it "cleanly" using C++. A quick outline on how to use said API would be appriciated, but not necessary.
