说明下;ADOConn 使用属性配置的ConnectionString 运行没有问题!
但是如果用代码给ADOConn 的ConnectionString 写进去连接信息,就抱错!
说明的是:
1)两种连接办法的ConnectionString是完全一致的,我已经读取并且逐个核对过了!
2)经过测试连接返回值为True ( RetValue = True ),只是在adoQuery执行Open的时候提示"无效的授权说明"
3)代码
.....................
strConnString := 'Provider=SQLOLEDB.1;Password='+Trim(strPassword)
+';Persist Security Info=True '
+';User ID='+Trim(strUserName)
+';Initial Catalog='+Trim(strDBName)
+';Data Source='+Trim(strServerName);
adocntAccount.Connected := false;
adocntAccount.ConnectionString := strConnString;
try
adocntAccount.Connected := True;
RetValue := True;
except
end;
但是如果用代码给ADOConn 的ConnectionString 写进去连接信息,就抱错!
说明的是:
1)两种连接办法的ConnectionString是完全一致的,我已经读取并且逐个核对过了!
2)经过测试连接返回值为True ( RetValue = True ),只是在adoQuery执行Open的时候提示"无效的授权说明"
3)代码
.....................
strConnString := 'Provider=SQLOLEDB.1;Password='+Trim(strPassword)
+';Persist Security Info=True '
+';User ID='+Trim(strUserName)
+';Initial Catalog='+Trim(strDBName)
+';Data Source='+Trim(strServerName);
adocntAccount.Connected := false;
adocntAccount.ConnectionString := strConnString;
try
adocntAccount.Connected := True;
RetValue := True;
except
end;
+';Persist Security Info=True '
+';User ID='+Trim(strUserName)
+';Initial Catalog='+Trim(strDBName)
+';Data Source='+Trim(strServerName);
adocntAccount.Connected := false;
adocntAccount.ConnectionString := strConnString;
try
adoCntAccount.Connection := nil; ///////////////////////////////////////
adocntAccount.Connected := True;
RetValue := True;
except
raise;
end;
已经写过了!
adoCntAccount.Connection := nil; ///////////////////////////////////////
没有这个属性呀!