ADO远程连接SQL SERVER 2005数据库不通,哪位高手帮忙看看!!!!
以下是代码:
CString mDBparam ="";
tProvider = "sqloledb';
tDBServer = "192.168.22.211";
tDataBaseName = "evcs";
tUserName="sa";
tPassword="evcs";
mDBparam.Format("Provider='%s'; Network Library=DBMSSOCN; Data Source='%s';Persist SecurityInfo=False;Initial Catalog='%s';UID='%s';PWD='%s';", tProvider, tDBServer, tDataBaseName, tUserName, tPassword);
try
{
if (FAILED(tpCon->CreateInstance("ADODB.Connection")))
{
AfxMessageBox("Connection Create Instance failed!");
}
(*tpCon)->CommandTimeout = 20;
if ((*tpCon)->State==adStateOpen)
{
(*tpCon)->Close();
}
(*tpCon)->Open((_bstr_t)mDBparam, (_bstr_t)tUserName,(_bstr_t)tPassword, adConnectUnspecified);
}
catch(_com_error e)
{
TRACE("%s\n", (char *)e.Description());
return FALSE;
}
远程SQL SERVER服务器的ip地址是:192.168.22.211,数据库名是evcs,登录模式是混合登录模式,SQL SERVER身份验证下的用户名是SA,密码是EVCS;在服务器本机上用SQL SERVER身份验证可以登录,但是在另一台机子上用ADO登录就连不上,调试下报错为“SQL SERVER不存在或拒绝访问”,在SQL SERVER2005 management studio下已经将服务器设置为允许远程连接,在网络配置上已经禁用VIA协议,其他协议启用,两机子防火墙都关了。试了好多次都连不上,检查了代码无错误,请哪位大侠帮忙看看!小弟感激不尽!!!!!!!!!!!