VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"
Posted
by Perma
on Stack Overflow
See other posts from Stack Overflow
or by Perma
Published on 2010-03-24T13:38:27Z
Indexed on
2010/03/24
13:53 UTC
Read the original article
Hit count: 705
Hey gang,
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.
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"
My code is:
Set conn = CreateObject("ADODB.Connection")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database.MDB"
conn.Open strConnect
So far I have ran %WINDIR%\System32\odbcad32.exe to try to configure the Driver in 32bit mode, but it hasn't done the trick. Any suggestions would be greatly appreciated
© Stack Overflow or respective owner