Client 10.1 [better]: Sql Native

// Set connection properties (simplified) DBPROP InitProps[2]; // ... set server, db, auth ...

Provider=SQLNCLI10;Server=myServer;Database=myDB;Trusted_Connection=yes;MARS Connection=True; Standard sql native client 10.1

hr = pDBC->Initialize(); // use connection... pDBC->Release(); CoUninitialize(); return 0; #include <windows.h> #include <sql.h> #include <sqlext.h> #include <iostream> int main() SQLHENV henv; SQLHDBC hdbc; SQLRETURN ret; // ... set server

Driver=SQL Server Native Client 10.0;Server=myServer\instance;Database=myDB;Trusted_Connection=yes; auth ... Provider=SQLNCLI10

Driver=SQL Server Native Client 10.0;Server=myServer;Database=myDB;Uid=myUser;Pwd=myPass;