SQL连接问题
下面这段代码也是模仿其他人的,但是我在试验的时候一直连接不上,报错Unspecified error. 然后我用VB尝试了下,同样的连接字符串,在VB下就没任何问题,高手帮忙看看问题出在哪里,谢谢。我是新手,个人电脑上没装SQL客户端
******* 以下为MFC,无法连接SQL ********************************
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn-> ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=123;Password=123;Initial Catalog=CimitarTest;Data Source=10.86.130.128\MSSQL03 ";
pConn-> Open( " ", " ", " ",adConnectUnspecified))
******* 以下为VB,正常连接SQL ********************************
Dim conn As New ADODB.Connection
Dim rst As ADODB.Recordset
conn.ConnectionString = "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=123;Initial Catalog=CimitarTest;Data Source=10.86.130.128\MSSQL03 "
conn.Open
[解决办法]
Data Source=10.86.130.128\\MSSQL03
为何不转义下?
[解决办法]
inline HRESULT Connection15::Open ( _bstr_t ConnectionString, _bstr_t UserID, _bstr_t Password, long Options )
你用open来连接,第一项不能为空,你把那个pConn-> ConnectionString,放到open第一个参数,后两个参数为空,不要填" ",这是空格,不是空.ConnectionString最后一个参数你可以改ip+端口的形式也可以10.86.130.128\\MSSQL03 试试