读书人

ado sqlserver 连接字符串如何写

发布时间: 2012-02-01 16:58:19 作者: rapoo

ado sqlserver 连接字符串怎么写
鄙人用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);}


[解决办法]

C/C++ code
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;    }
[解决办法]
Provider=SQLOLEDB.1;Persist Security Info=False;User ID='your id';Password = 'your pwd';Initial Catalog='your db';Data Source=SXL
[解决办法]
driver={SQL SERVER};Server=note.mdf;DataBase=Table;
[解决办法]
blog.csdn.net/jxufeng,我的博客里有

读书人网 >VC/MFC

热点推荐