Saturday, February 25, 2012

C++ and SQL Server programming

Are there any good resources (books, websites, etc) for programming SQL
Server using Visual C++? I am currently using C# but I really want to learn
how to do it using C++, but it appears to be much more difficult using C++.

ThanksHi

It depends on what you are using to interface with the database, with SQL
Server there are quite a few C++ examples check out samples in the index of
Books Online. Also there are others on MSDN e.g
http://support.microsoft.com/?kbid=184968&sd=msdn from
http://msdn.microsoft.com/visualc/d...es/default.aspx

It may be worth avoiding DB Library and Embeded SQL for C as this has
started to be deprecated in SQL 2005.

John

"Brooke" <tbrooked@.hotmail.com> wrote in message
news:Qgirf.12123$g_6.9870@.tornado.texas.rr.com...
> Are there any good resources (books, websites, etc) for programming SQL
> Server using Visual C++? I am currently using C# but I really want to
> learn how to do it using C++, but it appears to be much more difficult
> using C++.
> Thanks|||John Bell (jbellnewsposts@.hotmail.com) writes:
> It may be worth avoiding DB Library and Embeded SQL for C as this has
> started to be deprecated in SQL 2005.

Actually, it have been deprecated for longer than so. With these interfaces
you don't have full support for features added to SQL7 and SQL 2000.

The best interface for C++ programming is probably ODBC. OLE DB is an
alternative, but it's more cumbersome to use, no matter if you use the
raw interface or the consumer templates.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment