VBScript &访问 MDB - 800A0E7A -“找不到提供者.它可能没有正确安装" [英] VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"

问题描述

我在连接到访问 MDB 数据库的 VBScript 时遇到问题.我的平台是 Vista64，但大部分资源都是针对 ASP/IIS7 的.

I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7.

很简单，我无法连接.我收到以下错误:800A0E7A - 找不到提供程序.它可能没有正确安装"

Quite simply, I can't get it to connect. I'm getting the following error: 800A0E7A - "Provider cannot be found. It may not be properly installed"

我的代码是:

Set conn = CreateObject("ADODB.Connection")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:database.MDB"
conn.Open strConnect

到目前为止，我已经运行 %WINDIR%System32odbcad32.exe 来尝试在 32 位模式下配置驱动程序，但它没有成功.任何建议将不胜感激

So far I have ran %WINDIR%System32odbcad32.exe to try to configure the Driver in 32bit mode, but it hasn't done the trick. Any suggestions would be greatly appreciated

作为补充，我试图通过双击运行这个 .vbs 脚本并让它做它的事情.此代码未嵌入到另一个语言/脚本中.

Just as an addition, I'm trying to get this .vbs script to run by double clicking and letting it do it's thing. This code isn't embedded into another lang/script.

推荐答案

使用 SysWOW64 版本运行脚本
C:WindowsSysWOW64wscript.exe 或 cscript
而不是来自 C:WindowsSystem32 的默认 64 位版本

run script with SysWOW64 version
C:WindowsSysWOW64wscript.exe or cscript
instead of the default 64bit version from C:WindowsSystem32

这篇关于VBScript &访问 MDB - 800A0E7A -“找不到提供者.它可能没有正确安装"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！