ADODB SQL Server连接不IE9唯一的工作 [英] ADODB SQL Server connection not working only in IE9

问题描述

有一个有点古怪的问题。

这code在其他浏览器工作正常，只是没有在IE9。使用标准ADODB连接字符串：

<$p$p><$c$c>Provider=sqloledb;Server=localhost\\sqlex$p$pss;Database=DB;uid=DBuser;password=DBPassword;MultipleActiveRecordSets=true;

这样执行：

 暗淡dbGlobal
设置dbGlobal =的Server.CreateObject（ADODB.Connection）
dbGlobal.Open sConnectionString
 

在每一个浏览器这个作品，然后应用程序继续加载，在IE9中我得到了以下错误消息后面：

-2147467259：[DBNETLIB] [ConnectionOpen（连接（））] SQL Server不存在或拒绝访问

解决方案

很好用的以下的答案对SO（http://stackoverflow.com/a/260861/418151）的帮助下，我设法避开工作。根据这个问题的答案我试图运行IE作为管理员，现在它连接细到SQL Server！

我只能假设，在过去的两个星期我已经安装了一些更新的Windows已经稍微改变的SQL Server的权限和/或IE9。

不过还是不知道到底为什么我现在要运行IE作为管理员，以连接到SQL Server！？

Got a bit of an odd problem.

This code works fine in every other browser, just not in IE9. Standard ADODB connection string being used:

Provider=sqloledb;Server=localhost\sqlexpress;Database=DB;uid=DBuser;password=DBPassword;MultipleActiveRecordSets=true;

Executed thus:

Dim dbGlobal
Set dbGlobal = Server.CreateObject("ADODB.Connection")
dbGlobal.Open sConnectionString

In every browser this works and the application then goes on to load, in IE9 I get the following error message back:

-2147467259: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

解决方案

Well with the help of the following answer on SO (http://stackoverflow.com/a/260861/418151), I managed to get a work around. As per that answer I tried running IE as admin and now it connects fine to the SQL Server!

I can only assume that in the last week or two I've installed some Windows Update that has slightly altered the permissions of SQL Server and/or IE9.

Still got no idea why exactly I now have to run IE as admin in order to connect to SQL Server!?

这篇关于ADODB SQL Server连接不IE9唯一的工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！