CODEWITHSUNDEEP
vbscript
Pat
Pat

Reputation: 51

Microsoft.Jet.OLEDB.4.0 - Provider cannot be found. It may not be properly installed

I recently started a new job and I am getting the error below when I run a script written by my predecessor. I do not get this error when I run the script on my predecessor's old laptop which is running 32 bit windows 7. I get it when I try to run the script on my desktop which is running 64 bit windows 7. I thought it might be an issue with compatibility between the 32 and 64 bit versions.

Error:
Provider cannot be found. It may not be properly installed.

Code:

objConnection.Open  "Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=" & FilePath & ";" & _
            "Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"

I found some other posts with the same error, but their fixes did not help me. This is the only one that had an accepted answer:
Microsoft.Jet.OLEDB.4.0 - Provider can not be found or it may not be installed
I installed and changed the provider, but I got the same error.

Thanks for the help!

Upvotes: 0

Views: 2608

Answers (1)

Noodles
Noodles

Reputation: 2011

If it's a 32 bit issue then try 32 bit vbscript. c:\windows\syswow64\wscript "c:\yourscript.vbs".

Upvotes: 2

Related Questions