Sql Native | Client 10.1

// CoCreateInstance for SQLNCLI10 provider hr = CoCreateInstance(CLSID_SQLNCLI10, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&pDBC); if (FAILED(hr)) return 1;

// Connection string SQLWCHAR connStr[] = L"Driver=SQL Server Native Client 10.0;" L"Server=localhost;Database=master;Trusted_Connection=yes;"; ret = SQLDriverConnectW(hdbc, NULL, connStr, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_COMPLETE); 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; if (FAILED(hr)) return 1

Driver=SQL Server Native Client 10.0;Server=myServer;Database=myDB;Uid=myUser;Pwd=myPass; ret = SQLDriverConnectW(hdbc

Provider=SQLNCLI10;Server=myServer\instance;Database=myDB;Trusted_Connection=yes;

if (SQL_SUCCEEDED(ret)) std::cout << "Connected!" << std::endl; SQLDisconnect(hdbc);