我ADO连SQL的连接字串是不是有问题,请大家来看看.

Question

CString ConnStr = "Provider=SQLOLEDB.1;Persist Security Info=True;Server=192.168.0.1;DATABASE=JianTong;UID=sa;PWD=sa";
if (m_pConnection->State == 1)
m_pConnection->Close();
    m_pConnection->Open(_bstr_t(ConnStr), "", "", adModeUnknown);一连接就报错!

Answer 1

_T("Driver={SQL Server}; Server=192.168.0.1;" "Trusted_Connection=no;" "Database=JianTong; Uid=sa; Pwd=sa;")

Answer 2

为什么用Driver={SQL Server}就可以了,但Provider=SQLOLEDB.1却不行呢?

Answer 3

还是不行,我发现是打开对方的IPC$后才行,不打开依然不行?

Answer 4

HRESULT hr;
try
{
hr=pConnection.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr))
{
CString sql; 
sql.Format("driver={SQL Server};Server=%s;DATABASE=%s;UID=%s;PWD=%s",serverip,dsn,UserName,dbpass);
hr=pConnection->Open((LPCTSTR)sql,"","",adModeUnknown);
}
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("连接数据库失败！\r\n错误信息:%s又出毛病了:(",e.ErrorMessage());
AfxMessageBox(errormessage);
}

Answer 5

Provider=SQLOLEDB.1;Persist Security Info=False;Server=192.168.0.1;Initial Catalog=JianTong;UID=sa;PWD=sa

Answer 6

或者Provider=SQLOLEDB.1;Persist Security Info=False;Server=(Local);Initial Catalog=JianTong;UID=sa;PWD=sa

Answer 7

http://dev.csdn.net/develop/article/19/19016.shtm