一个奇怪的ADO连接问题：错误信息：provide cannot be found. it may not be properly installed

[nanhui]

如题，我试过多个连接字符串“Provider=sqloledb.1;Data Source=127.0.0.1,1433;Network Library=DBMSSOCN;Initial Catalog=FuYang;User ID=sa;Password=sa;”
“Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=FuYang;Data Source=CXH”
“Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=FuYang;Data Source=127.0.0.1;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CXH;Use Encryption for Data=False;Tag with column collation when possible=False”

但都有问题，而且这个问题是今天突然出现的，前几天打过一个补丁“MDAC_TYP2.8”（从微软网站上下载的）

[Jute]

您详细看一下连接情况如下
第一种：有用户和密码登入
Provider=SQLOLEDB.1;
Persist Security Info=False;
User ID=sa;
Initial Catalog=Restaurant_Server;
Data Source=RDS-13
第二种：Windows的混入模式登入
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=Restaurant_Server;
Data Source=RDS-07

[Jute]

你对应一下，假如有问题再找我。我的QQ是57166296

[bee2518]

到这里http://218.14.180.20/shux/gbook/index.asp
然后输入“provide cannot be found. it may not be properly installed ”
搜索后里面有需要升级的链接，你试试

[bee2518]

估计是补丁惹的祸

[budded]

hehe, 重新安装 MDAC 吧

[aiirii]

用odbc 試下：

* Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"


* Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"


* Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"

[GoldShield]

可能上版本不对造成的

[nanhui]

MDAC我也重新安装过了，但是还是不行，
另外，设置连接字符串之后，用“test connection”是正常的