Database Access from a C++ App

Question

Hello,

I have a C++ app written in Visual Studio 2015, from which I'd like to connect to an SQL Server 2008 database. I haven't been able to find a code example that both specifies the necessary header files and builds. Any help will be appreciated.

Dave

Answer 1

See this on ODBC as the primary support for SQL Server with native C++:

Microsoft is Aligning with ODBC for Native Relational Data Access - FAQ

https://social.msdn.microsoft.com/Forums/en-US/e696d0ac-f8e2-4b19-8a08-7a357d3d780f/microsoft-is-aligning-with-odbc-for-native-relational-data-access-faq?forum=sqldataaccess

Here's a link to a word document for those moving from OLEDB to ODBC.

https://msdn.microsoft.com/en-us/library/hh967418.aspx?f=255&MSPPError=-2147217396

Looks like COM is the best way to access ODBC and that's pretty easy in MS C++.

Answer 2

I have a C++ app written in Visual Studio 2015, from which I'd like to connect to an SQL Server 2008 database. I haven't been able to find a code example that both specifies the necessary header files and builds. Any help will be appreciated.

For ODBC, you could find some samples on MSDN, for example this:

ODBC database sample

And for more information about ODBC development, please check this:

ODBC Programmer's Reference

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 3

Thank you, this is exactly what I was looking for :)

Dave

Answer 4

Thank you, this is exactly what I was looking for :)

Dave