blocks|key|992685|text|你安装了驱动程序吗？如果进入“开始”>“设置”>“控制面板”>“管理工具”，然后单击数据源，然后选择“驱动程序”选项卡，您的驱动程序信息应该在那里注册。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|992686|否则，简单地设置要测试的DSN连接可能会更容易。|992687|当然，您可以定义多个连接字符串，并设置在不同机器上工作的“模式”。|992688|还有ConnectionStrings.com。|992689|-编辑--|992690|为了进一步发展这一点，我在另一个站点上找到了这条线。|992691|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/|1|http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb^0|1F|4|0|0|0|2|L|0|0|0|5|0|M|3|1|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|13|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|L|3|M|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1B|8|@]|D|@$9|1C|A|1D|1|1E]]|E|$]]|$1|P|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W]]|X|$5|S|T|U|E|$V|Y]]]]

Have you got the driver installed? If you go into Start > Settings > Control Panel > Administrative Tools and click the Data Sources, then select the Drivers tab your driver info should be registered there.

Failing that it may be easier to simply set up a DSN connection to test with.

You can define multiple connection strings of course and set-up a 'mode' for working on different machines.

Also there's <a href="http://www.connectionstrings.com" rel="nofollow">ConnectionStrings.com</a>.

-- EDIT --

Just to further this, I found <a href="http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb" rel="nofollow">this thread</a> on another site.

blocks|key|1271533|text|几点建议|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1271534|默认情况下不安装ACE驱动程序。它也是64位驱动程序，所以在应用程序池中禁用32位可能是值得的。我知道当启用32位时，64位驱动程序无法工作(例如连接IIS和Tomcat的ISAPI过滤器)。|1271535|老飞机司机是32位。默认情况下它包括在内。如果您可以将数据库的副本保存为.mdb文件，那么使用JET驱动程序可能是一个解决办法。|1271536|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

A couple of suggestions

The ACE driver isn't installed by default. It's also a 64 bit driver, so it might be worth disabling 32bit in your app pool. I've known 64 bit drivers not work when 32 bit is enabled.(eg the ISAPI filter which connects IIS to Tomcat).

The older JET driver is 32bit. It is included by default. If you could save a copy of your database as a .mdb file then using the JET driver might be a workaround

blocks|key|992765|text|您应该使用计算机中可用的提供程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|992766|Goto控制面板|ordered-list-item|992767|Goto管理员工具|992768|Goto数据源(ODBC)|992769|单击“驱动程序”选项卡。|992770|您看到所谓的“Server本机客户端”吗？|992771|​|992772|📷|atomic|offset|length|992773|992774|请看附在屏幕上的画面。这里，我的提供程序将是SQLNCLI11.0|992775|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/c33e83b7cd933d0a4b2f22ece2afc8f8.png|imageAlt^0|0|0|0|0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|16|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|17|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|19|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1C|8|@]|9|@$R|1D|S|1E|1|1F]]|A|$]]|$1|T|3|N|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]]]

You should use the provider available in your machine. 

<ol>
<li>Goto Control Panel</li>
<li>Goto Administrator Tools</li>
<li>Goto Data Sources (ODBC)</li>
<li>Click the "Drivers" tab.</li>
<li>Do you see something called "SQL Server Native Client"?</li>
</ol>

<img src="https://i.stack.imgur.com/rSt9x.png" alt="enter image description here">

See the attached screen shot. Here my provider will be SQLNCLI11.0

blocks|key|992796|text|在IIS+/应用程序池/+YourPool+/高级设置中检查站点的应用程序池：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|992797|高级/启用32位应用程序:+True|unordered-list-item|992798|有一些轶事证据表明你也这么做了：|992799|管理管道模式:经典|992800|entityMap^0|1|Q|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$]]|$1|I|3|J|5|6|7|S|8|@]|D|@]|E|$]]|$1|K|3|L|5|H|7|T|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|N|$]]

Check the site's Application Pool in IIS / Application Pools / YourPool / Advanced Settings :

<ul>
<li>Advanced / Enable 32-Bit Applications: True</li>
</ul>

There's some anecdotal evidence to suggest you do this too:

<ul>
<li>Managed Pipeline Mode : Classic</li>
</ul>

blocks|key|1271614|text|我也遇到了同样的问题，通过在我的机器上安装Oracle11g客户端解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1271615|我没有为它安装任何多余的驱动程序。我使用64位的windows7。重要的是，当我导航到路径启动>设置>控制面板>管理工具>+DataSources(ODBC)+>驱动程序时。我在里面只找到了SQL+server。|1271616|​|1271617|📷|atomic|offset|length|1271618|1271619|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/2f1fadb259d14b2d948efe152cd0c22c.jpg|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

I got the same issue and It got solved by installing Oracle 11g client in my machine..

I have not installed any excclusive drivers for it. I am using windows7 with 64 bit. Interestignly, when I navigate into the path Start > Settings > Control Panel > Administrative Tools > DataSources(ODBC) > Drivers. I found only SQL server in it

<img src="https://i.stack.imgur.com/pglQo.jpg" alt="Please Finc the attachment below for the same">

blocks|key|1271625|text|安装此https://www.microsoft.com/en-us/download/details.aspx?id=13255|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1271626|安装32位版本，不管您是否是64位，并在应用程序池中启用32位应用程序。|1271627|entityMap|0|LINK|mutability|MUTABLE|url|https://www.microsoft.com/en-us/download/details.aspx?id=13255^0|3|1Q|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

install this <a href="https://www.microsoft.com/en-us/download/details.aspx?id=13255" rel="nofollow">https://www.microsoft.com/en-us/download/details.aspx?id=13255</a>

install the 32 bit version no matter whether you are 64 bit and enable the 32 bit apps in the application pool

blocks|key|992867|text|以下步骤解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|992868|(1)+Moved+the+website+to+a+Dedicated+application+pool.

(2)+Changed+the+Managed+Pipeline+Mode+from+integrated+to+Classic.

(3)+Set+Enable+32-Bit+Applications+from+false+to+true.|code-block|syntax|javascript|992869|ASP页面现在运行良好！|992870|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Following steps has fixed my issue.

<pre><code>(1) Moved the website to a Dedicated application pool.

(2) Changed the Managed Pipeline Mode from integrated to Classic.

(3) Set Enable 32-Bit Applications from false to true.
</code></pre>

ASP pages are working fine now!

blocks|key|992884|text|当使用Oracle9.2.0.1在IIS6上使用Asp经典程序在Server+2003上维护非常老的应用程序时，出现了此异常。修复方法是将oracle更新到9.2.0.6。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|992885|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Got this exception when maintaining very old application on Server 2003 using Asp classic on IIS6 with 
Oracle 9.2.0.1. 
The fix is by updating oracle to 9.2.0.6.

blocks|key|270034|text|在“窗口管理工具”下，运行ODBC数据源(32位)。|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|data|270035|在“驱动程序”选项卡下，检查是否有Microsoft驱动程序(*.xls、*.xlsx等)--文件名为ACEODBC.DLL|270036|如果缺少此功能，则需要安装Microsoft数据库引擎2016再发行版。|270037|您可以在这里找到安装程序，https://www.microsoft.com/en-us/download/details.aspx?id=54920|unstyled|offset|length|270038|你的联系应该是：|270039|Set+objConn1+=+Server.CreateObject("ADODB.Connection")+
objConn1.Provider+=+"Microsoft.ACE.OLEDB.12.0"+++
objConn1.ConnectionString+=+"Data+Source="+&+pPath+&+";Extended+Properties=""Excel+12.0+Xml;HDR=YES;IMEX=1"""+|code-block|syntax|javascript|270040|entityMap|0|LINK|mutability|MUTABLE|url|https://www.microsoft.com/en-us/download/details.aspx?id=54920^0|0|0|0|D|1Q|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|17|8|@]|9|@]|A|$P|Q]]|$1|R|3|-4|5|H|7|18|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

<ol>
<li>Under Window Administrative Tools, run ODBC Data Sources (32-bit).
</li>
<li>Under the Drivers tab, check you have the Microsoft Excel Driver (*.xls, *.xlsx etc...) - the file name is ACEODBC.DLL
</li>
<li>If this is missing, you will need to install the Microsoft Access Database Engine 2016 Redistributable.
</li>
</ol>
You'll find the installer here <a href="https://www.microsoft.com/en-us/download/details.aspx?id=54920" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=54920</a>
<ol start="4">
<li>Your connection should be:</li>
</ol>
<pre><code>Set objConn1 = Server.CreateObject(&quot;ADODB.Connection&quot;) 
objConn1.Provider = &quot;Microsoft.ACE.OLEDB.12.0&quot; 
objConn1.ConnectionString = &quot;Data Source=&quot; &amp; pPath &amp; &quot;;Extended Properties=&quot;&quot;Excel 12.0 Xml;HDR=YES;IMEX=1&quot;&quot;&quot; 
</code></pre>

So I am going back to a project I created in College, so I can transfer it to PHP. I orginally coded it in ASP Classic.

I am on Windows 8 and running Access 2013.

I am currently getting the following error

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/PROJECT!Better/verifyuser.asp, line 11

and this is my connection string code.

<pre class="lang-vb prettyprint-override"><code>Dim vPath, pPath, Conn

vPath = ".\db\Comic.accdb"
pPath = Server.MapPath( vPath )

objConn = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" &amp; pPath &amp; ";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open objConn
</code></pre>

any help that you can provide would be awesome!

edit: I already have the enable 32-bit applications in IIS Activated

Getting Error 800a0e7a "Provider cannot be found. It may not be properly installed."

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

所以我要回到我在大学里创建的一个项目，这样我就可以把它转移到PHP了。我在ASP经典版中对它进行了编码。我在Windows 8上运行Access 2013。我目前正在收到以下错误无法找到ADODB.Connection错误“800a0e7a”提供程序。它可能没有正确安装。/PROJECT!Better/verifyus...

问“获取错误800a0e7a”无法找到提供程序。它可能没有正确安装。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问“获取错误800a0e7a”无法找到提供程序。它可能没有正确安装。EN