如何连接sql server 2008

2025-03-07 07:21:44
推荐回答(1个)
回答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);