sql 2005 与microsoft visual c++连接。。有连接过的嘛

Question

感觉难吗我正在尝试。。 

Answer 1

有两种方法.
一种是:
_ConnectionPtr pMyConnect=NULL;
pMyConnect.CreateInstance(__uuidof(Connection)));
_bstr_t strConnect="Provider=SQLOLEDB; Server=server_name;Database=database_name; uid=user_name; pwd=password;"; 
pMyConnect->Open(strConnect,"","",NULL);也可以用:
string ConnectionString = "Provider=SQLOLEDB;server=(local);database=databaseName";
m_pConnection->ConnectionString = ConnectionString.c_str();
m_pConnection->Open("", user, password, adConnectUnspecified);