“需要MDAC”但它安装了...... [英] "MDAC required" but it's installed...
问题描述
我在VB.NET应用程序中遇到此错误，此时我尝试从
读取数据SQL Server：
.Net Data SQL Provider（System.Data.SqlClient）需要Microsoft Data
Access Components（MDAC）2.6或更高版本。 at
System.Data.SqlClient.ConnectionPool.GetConnection（Boolean& isInTransaction）
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection （SqlConnec
tionString选项，布尔& isInTransaction）
在System.Data.SqlClient.SqlConnection.Open（）
无法加载调用数据呼叫数据故障
但是安装了MDAC 2.7！当我查看注册表时，
表示也已安装：
HKEY_LOCAL_MACHINE\SOFTWARE \ Microsoft /\\ DataAccess\F ullInstallVer =
" 2.71.9040.2"
.NET Framework已安装（1.1），它位于Windows NT（Sp 6a）上。
有人知道thisp roblem吗？和一些解决方案？可能是因为
的一些限制（虽然我在电脑上有完全的管理员权限）。
我真的很紧急并且困扰我（我必须在20分钟内做一个演示，
呵呵）。
非常感谢，任何帮助，提示等都会非常感激！
Pieter
Hi,
I''m having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is
indicated as installed too:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer =
"2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because
of some restictions (although I do have full Admin rights on the pc).
I''ts really urgent and bothering me (I have to do a demo in 20 minutes,
hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
推荐答案
也许这会救命。您可能必须安装最新的sql
服务器服务包。
http://support.microsoft.com/default...59&Product=sql
Ken
--------------------
" DraguVaso" < PI ********** @ hotmail.com>写在留言中
新闻：％2 **************** @ tk2msftngp13.phx.gbl ...
Hi,
Maybe this will help. You might have to install the latest sql
server service pack.
http://support.microsoft.com/default...59&Product=sql
Ken
--------------------
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
我在尝试从SQL Server读取数据时，在VB.NET应用程序中出现此错误：
。 Net Data SQL Provider（System.Data.SqlClient）需要Microsoft Data
Access Components（MDAC）2.6或更高版本。
System.Data.SqlClient.ConnectionPool.GetConnection（布尔&
isInTransaction）
在System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection（SqlConnec
tionString选项） ，Boolean& isInTransaction）
在System.Data.SqlClient.SqlConnection.Open（）
无法加载调用数据调用数据失败
但是安装了MDAC 2.7！当我查看注册表时，它也显示为已安装：
HKEY_LOCAL_MACHINE\SOFTWARE \ Microoft\DataAccess\F ullInstallVer =
" 2.71.9040.2"
有人知道这个问题吗？和一些解决方案？可能是因为某些原因（虽然我在电脑上有完全的管理员权限）。
我真的很紧急并且困扰我（我必须这样做） 20分钟的演示，
呵呵）。
非常感谢，任何帮助，提示等都会非常感激！
Pieter
Hi,
I''m having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is
indicated as installed too:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer =
"2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a)
pc.
Does anybody know about thisp roblem? And some solution? Could it be
because
of some restictions (although I do have full Admin rights on the pc).
I''ts really urgent and bothering me (I have to do a demo in 20 minutes,
hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
DraguVaso写道：
DraguVaso wrote:
我在VB.NET应用程序中遇到此错误我尝试从SQL Server读取数据的那一刻：
I''m having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
.Net Data SQL Provider（System.Data.SqlClient）需要Microsoft Data
在System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection（SqlConnec
tionString options，Boolean& isInTransaction） ）
在System.Data.SqlClient.SqlConnection.Open（）
无法加载调用数据调用数据失败
但是安装了MDAC 2.7！当我查看注册表时，它也显示为已安装：
HKEY_LOCAL_MACHINE\SOFTWARE \ Microoft\DataAccess\F ullInstallVer =
" 2.71.9040.2"
有人知道这个问题吗？和一些解决方案？可能是因为某些原因（虽然我在电脑上有完整的管理员权限）。
我真的很紧急而且困扰我（我必须在20岁时做一个演示）分钟，
呵呵）。
非常感谢，任何帮助，提示等都会非常感激！
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is
indicated as installed too:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer =
"2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because
of some restictions (although I do have full Admin rights on the pc).
I''ts really urgent and bothering me (I have to do a demo in 20 minutes,
hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
你好DraguVaso，
似乎并不孤单：
http://groups.google.de/groups?selm=...TNGP10.phx.gbl
http://groups.google。 de / groups？selm = ... 40TKMSFTNGXA14
MDAC实用程序：组件检查器可能有帮助
干杯
Arne Janning
Hi DraguVaso,
seems you''re not alone:
http://groups.google.de/groups?selm=...TNGP10.phx.gbl
http://groups.google.de/groups?selm=...40TKMSFTNGXA14
The MDAC Utility: Component Checker might help
http://www.microsoft.com/downloads/d...displaylang=en
Cheers
Arne Janning
重新安装mdac会有帮助吗？
-
Miha Markic [MVP C＃] - RightHand .NET咨询&开发
miha at rthand com
www.rthand.com
" DraguVaso" < PI ********** @ hotmail.com>写在留言中
新闻：％2 **************** @ tk2msftngp13.phx.gbl ...
Hi,
Does it help if you reinstall mdac?
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
我在尝试从SQL Server读取数据时，在VB.NET应用程序中出现此错误：
。 Net Data SQL Provider（System.Data.SqlClient）需要Microsoft Data
Access Components（MDAC）2.6或更高版本。在
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection（SqlConnec tionString选项，布尔& isInTransaction）中的System.Data.SqlClient.ConnectionPool.GetConnection（布尔&
isInTransaction） ）
在System.Data.SqlClient.SqlConnection.Open（）
无法加载调用数据调用数据失败
但是安装了MDAC 2.7！当我查看注册表时，它也显示为已安装：
HKEY_LOCAL_MACHINE\SOFTWARE \ Microoft\DataAccess\F ullInstallVer =
" 2.71.9040.2"
pc上。
有人知道这个问题吗？和一些解决方案？可能是
，因为有一些限制（虽然我在电脑上有完整的管理员权限）。
我真的很紧急并且困扰我（我必须在20年做一个演示）分钟，
呵呵）。
非常感谢，任何帮助，提示等都会非常感激！
Pieter
Hi,
I''m having this error in a VB.NET-application at the moment that I attempt
to read data from an SQL Server:
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. at
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
Failed to Load Call Data Call Data Failure
However the MDAC 2.7 is installed! And when I look into the registry it is
indicated as installed too:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\F ullInstallVer =
"2.71.9040.2"
The .NET Framework is installed (1.1), and it is on a Windows NT (Sp 6a) pc.
Does anybody know about thisp roblem? And some solution? Could it be because of some restictions (although I do have full Admin rights on the pc).
I''ts really urgent and bothering me (I have to do a demo in 20 minutes,
hehe).
Thanks a lot in advance, any help, hints etc will be really appreciated!
Pieter
这篇关于“需要MDAC”但它安装了......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
