无法找到提供商。它可能没有正确安装。 [英] Provider cannot be found. It may not be properly installed.

问题描述

我有一个新的Windows 7盒子，并且在连接数据库时遇到麻烦。我已经阅读了这个错误，听起来我需要下载并安装一些东西，但只是不明白什么或在哪里。我的代码很简单：


<％Option Explicit％>

<％

Dim Driver，fso

Driver =" PROVIDER = Microsoft.Jet.OLEDB.4.0; DATA SOURCE = c：\Inetpub \wwwroot \database \OMHT.mdb;" ''Local

设置objCommand = Server.CreateObject（" ADODB.Command"）

objCommand.ActiveConnection = Driver

％>


这是我一直在使用的相同代码所以它应该可以工作。


如果有人可以用最简单的术语向我提供解释为我需要安装或配置，我会非常感激。


干杯 -


george

I got a new Windows 7 box and am having troubles getting ASP to connect to the database. I have read about this error and it sounds like I need to download and install something but just do not understand what or where. My code is simple:

<% Option Explicit %>
<%
Dim Driver, fso
Driver = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\Inetpub\wwwroot\database\OMHT.mdb;" '' Local
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = Driver
%>

It is the same code I have been using forever so it should work.

If someone can offer me in the simplest terms an explanation as to what I need to install or configure then I would greatly appreciate it.

Cheers -

george

推荐答案

我的直觉说这是你的MDAC。尝试下载并安装最新的MDAC。

http://www.microsoft.com/downloads/e...displaylang=en

My instincts say it is your MDAC. Try downloading and installing the latest MDAC.

http://www.microsoft.com/downloads/e...displaylang=en

谢谢你的回复。我安装了它但没有任何改变。


这是我放在一起的代码：

Thanks for the response. I installed it but without any change.

Here is the code I have put together:

展开 | 选择 | Wrap | 行号

Jet驱动程序与我发送给您的同一链接的跳数不是太多。也许尝试下载它们。


如果这不起作用，你能使用文件DSN吗？目前您正在使用DSN-less。

The Jet drivers were not too many hops from that same link I sent you. Perhaps try downloading those.

If that doesn''t work, are you able to use a File DSN? At present you are using DSN-less.

这篇关于无法找到提供商。它可能没有正确安装。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！