Re: C++ and SQL Server programming



John Bell (jbellnewsposts@xxxxxxxxxxx) 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@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: Application, database and schema?
    ... > hardware interface for the monitoring. ... This subsystem understands how to talk to the ... > this case an RDB with a SQL interface. ...
    (comp.object)
  • Re: user wants access
    ... I would strongly recommend you read Books Online for this information. ... the db_securityadmin fixed database role. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.server)
  • Re: reclaiming LOB space
    ... Books Online says "Reclaims space from dropped variable-length ... But as I understood Mike, he did not drop the column, only setting the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • RE: open a text file using sp_oamethod
    ... sp_OAGetProperty Fails on Properties From Inherited Interface ... Source: ODSOLE Extended Procedure ... When no OUTPUT parameter is supplied, ... Microsoft has confirmed this to be a problem in SQL Server 7.0. ...
    (microsoft.public.sqlserver.programming)
  • Re: HELP - Ideas for Oracle / MS Sql Interface.
    ... Sql Server DB running on Windows and accessed via a VPN. ... I need to develop an interface that will copy the data from Oracle to ... The interface will be located on the Oracle unix server. ...
    (comp.databases.oracle.server)