Re: The best way to connect to SQL Server from C++

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

xcppcoder@xxxxxxxxx wrote:
Hello All
I want to connect to SQL Server from Visual C++, and I'm wonder which
technology is best to use (ODBC, ADO, ...)?

Best according to what criteria?

Best performance - probably OLE DB.
Easiest - either ADO or ODBC.
Most portable (to another database) - probably ODBC.

If you can used managed code, consider ADO.NET.

-cd


.

Relevant Pages

  • Re: Connection from ASP- ODBC vs. SQLOLEDB
    ... The ASP code is already using ADO (adodb.connection, ... The new provider is better than ODBC isn't it, ... SQL Server Client Network Utility- "Enable Shared Memory": ... ASP, ASP.NET as well as Microsoft Content Management Server 2002 SP1a. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: Heres a rather broad question...
    ... ADO.NET and not its predecessor, will they fix any ADO problems that arise? ... authentication or permission issues with SQL Server 2000. ... The only thing I would say is that Microsoft have frozen development on ODBC ...
    (microsoft.public.data.ado)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... My fix was to use ADO ... With ODBC the connection remains open the ...
    (comp.databases.ms-access)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... against the sql server (ADO was specifically designed for use with sql ... the connection is closed. ...
    (comp.databases.ms-access)