vs 2008连接sql server 2008 r2连不上
// 初始化COM库并连接数据库
CoInitialize(NULL);
try{
// 创建Connection对象
hr = m_pConnection.CreateInstance("ADODB.Connection");
m_pRecordset.CreateInstance("ADODB.Recordset");
if(SUCCEEDED(hr)){
// ACCESS2000,Provider=Microsoft.Jet.OLEDB.3.51;
// ACCESS97,Provider=Microsoft.Jet.OLEDB.3.51;
// SQLSERVER2005,Provider=SQLOLEDB;
// SQLSERVER2008,Provider=SQLOLEDB;
// Provider=SQLOLEDB; Server=server_name;Database=database_name; uid=user_name; pwd=password;
// Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=mydb;Data Source=.\sqlexpress如果有密码再增加一句:Password=密码
//sprintf( ConnectBuf,"Provider=%s;Server=%s;Database=%s;uid=%s;pwd=%s", g_svr.db_Provider,g_svr.db_Server,g_svr.db_Database,g_svr.db_uid,g_svr.db_pwd );
sprintf( ConnectBuf,"Provider=SQLOLEDB;Persist Security Info=False;User ID=sa;Initial Catalog=AAAA;Data Source=192.168.1.4;Password=abc@123" );
strConnect = ConnectBuf;
try{
hr = m_pConnection->Open( strConnect,"","",adModeUnknown );
m_Connected = TRUE;
return TRUE;
}catch( _com_error e ){
DWORD KKKKKK = GetLastError();
RTUSvr_LogEvent(TEXT("连接数据库失败!\r\n错误信息"));
return FALSE;
}
}
}
如上代码,open每次返回的hr值是hr|S_OK 但是直接跳进catch里去了
我需要连接192.168.1.4的数据库表,用户名sa,密码abc@123,一直不知道问题在哪,我也试过几种连接串都不成功,麻烦哪位大仙指导一下......