鄙人用sql2005建了一个数据库note.mdf,表名Table,用windows身份验证 没有输用户名和密码
请问在vc2005里的连接字符串怎么写
_ConnectionPtr pMyConnect=NULL;
HRESULT hr = pMyConnect.CreateInstance(__uuidof(Connection)));
if( FAILED(hr) ) return;
_bstr_t strConnect="Provider=SQLOLEDB; Server=lenove123;"
"Database=note.mdf; uid=; pwd=;"; //这里的lenove123是本机名,uid pwd怎么写try{pMyConnect->Open(strConnect,"","",NULL);}
请问在vc2005里的连接字符串怎么写
_ConnectionPtr pMyConnect=NULL;
HRESULT hr = pMyConnect.CreateInstance(__uuidof(Connection)));
if( FAILED(hr) ) return;
_bstr_t strConnect="Provider=SQLOLEDB; Server=lenove123;"
"Database=note.mdf; uid=; pwd=;"; //这里的lenove123是本机名,uid pwd怎么写try{pMyConnect->Open(strConnect,"","",NULL);}
HRESULT hr = pMyConnect.CreateInstance(__uuidof(Connection)));
if( FAILED(hr) ) return;
_bstr_t strConnect="Provider=SQLOLEDB; Server=lenove123;"
"Database=note.mdf; uid=sa; pwd=sa;"; //这里的lenove123是本机名,uid pwd分别为satry{pMyConnect->Open(strConnect,"","",NULL);}
到这里弹出个【DBNETLIB】[ConnectionOpen(Connect()).]SQL Server 不存在或拒绝访问
try
{
pConn->ConnectionString="Provider=Microsoft.ACE.OLEDB.12.0;\
Data Source=data.accdb;Persist Security Info=False";
pConn->Open("","","",adConnectUnspecified);
}
catch(_com_error e)
{
AfxMessageBox(_T("Opening Connection...")+e.Description());
return;
}
以上是我连access的,仅供参考。
楼主你的数据库mdb放到工程目录下了么?还有你的import怎么写的放哪了?