Sql Native Client 10.1 [best] Access

Provider=SQLNCLI10;Server=myServer;Database=myDB;Uid=myUser;Pwd=myPass;

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv); SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0); SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); sql native client 10.1

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

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

Provider=SQLNCLI10;Server=myServer;Database=myDB;Trusted_Connection=yes;MARS Connection=True; Standard

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

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;