• Skip to main content
  • Skip to primary sidebar

Ryan McCormick

Dedicated Dad, Software Engineer and Lover of Coffee

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

June 5, 2014 by Ryan McCormick 15 Comments

I am writing this one as part two of my post:
How to Connect to Access Database with VBScript

As part of building the above example, I kept experiencing this error. I found out that 64 bit Windows 7 and Windows Vista don’t have the ability to run VBA in 64 bit. You have to force it to use the 32 bit driver.

Have you ever encountered:
solution-to-800A0E7A

Error: Provider cannot be found. It may not be properly installed.
Code: 800A0E7A
Source: ADODB.Connection

There are a couple of workarounds you can employ to make your script work:

Via Command Line

  1. Hold your windows key and press “R” to open the command prompt
  2. type: “%windir%\SysWoW64\wscript.exe <vbscript path and filename>”
  3. Press OK

Via Shortcut

  1. Create a new shortcut
  2. For the path type: “%windir%\SysWoW64\wscript.exe <vbscript path and filename> “
  3. Press OK

Conclusion

Either way, you need to type: “%windir%\SysWoW64\wscript.exe” before your filename to force windows to open your script with the 32 bit driver.

Please comment with any questions, improvements or suggestions. Happy Coding!

Related

Filed Under: Microsoft Access, VBScript, Windows Tips Tagged With: 800A0E7A, Provider cannot be found. It may not be properly installed

Reader Interactions

Comments

  1. Chetan Tammala says

    April 15, 2015 at 7:33 am

    Hi Ryan,

    I had observed the same issue today and I could find the root cause from your blog. Thanks a lot for documenting this.

    Thanks,
    Chetan

    Reply
    • Tony says

      April 20, 2015 at 7:33 am

      Thanks Chetan and Ryan. I am able to register the DLL; and I can run a vbscript on the 64-bit PC using the cscript command. My problem is getting an embedded subroutine inside a form written with vbscript to connect back to Oracle and retrieve data. I realize to get any of this to work, you need to make the PC think it is 32-bit mode, Thus, the cscript.exe. But how can this be done with embedded vbscript in a form. That’s the real problem here.

      Reply
      • Ryan McCormick says

        April 20, 2015 at 11:35 am

        That makes sense, I get what you are trying to do. Are you running the form in Internet Explorer? If not I suggest trying that first. If you are already running it in Internet Explorer, I suggest researching the Oracle runtime and making sure Internet Explorer is loading the correct one (or loading it period). Another suggestion is to look into creating a .hta file out of it. Here is some info on the .hta https://technet.microsoft.com/en-us/library/ee692768.aspx

        Please post back when you figure it out. This sounds like a tricky one.

        Reply
        • Tony says

          April 20, 2015 at 2:57 pm

          Ryan,
          Thanks for the link to the HTA tutorial.

          Reply
  2. Tony Santaniello says

    April 16, 2015 at 3:30 pm

    I have vbscript as part of a form for a client piece of software running on Win7 64bit. Worked fine on 32bit. Most of the data interactions are done with the SQL Server database, but I also need to connect to my Oracle database to get information. When I try to connect using the connection string “Provider=OraOLEDB.Oracle;Data Source=Biodex;User ID=xxxxx;Password=xxxx;” I get the error message you show above. I get the test script to work fine using the cscript, but how can I get the connection to work if it is embedded with other code? Thanks in advance for your help. Tony.

    Reply
    • Ryan McCormick says

      April 16, 2015 at 6:17 pm

      Sounds like it could be something with the way the Oracle runtime is installed. I found this: https://community.oracle.com/thread/2367179 might be worth a look. Please post back if that helps.

      Reply
  3. Iain Brown says

    June 24, 2015 at 8:05 am

    Hi,

    I can’t get this to work at all, it’s so frustrating! I’m using Office 365 Pro Plus 32bit on Windows 7 64bit and am trying to run vbscript to connect to a test database I’ve setup. I’ve followed the instructions to the letter but am still getting the same error message that you describe.

    Dim connStr, objConn, getNames
    connStr = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:DashboardTest.accdb;”
    Set objConn = CreateObject(“ADODB.Connection”)
    objConn.open connStr

    it’s falling over at line 4, I have re-registered the ado dll’s, installed access database engines… still can’t get the damn thing to work.

    Any ideas, please!?!

    Reply
  4. Iain Brown says

    June 24, 2015 at 8:49 am

    I’ve solved it… not sure why though. I installed the 64bit version of the Access 2010 Engine and then the ADODB provider appeared in my list of providers and I was able to use it… I thought I needed the 32bit provider though and yes I was using the 32bit version of wscript.exe

    Reply
    • Ryan McCormick says

      June 24, 2015 at 9:06 am

      Happy to hear that you figured it out. Please add a comment if you run into more issues.

      Reply
  5. Pablo Nieto says

    February 29, 2016 at 6:58 am

    Thanks a lot for your post. It solved my problem. I was critical for my company.

    Reply
  6. sumit says

    December 27, 2016 at 6:54 am

    please provide screenprint of this solution method

    Reply
  7. Rabab says

    February 23, 2017 at 12:19 am

    thanks, this solved my problem too

    Reply
  8. Giang T Doan says

    March 14, 2018 at 11:44 am

    Thank you!! This solved the issue that I was having.

    Reply
  9. Michael Beck says

    January 29, 2019 at 3:43 pm

    You’re a genius. Thanks.

    Reply

Trackbacks

  1. How to Connect to Access Database with VBScript says:
    June 5, 2014 at 3:14 pm

    […] NOTE: If you skip this step you will encounter an error: Provider cannot be found. It may not be properly installed […]

    Reply

Leave a Reply Cancel reply

Primary Sidebar

Recent Posts

  • Force Quit Kill all Chrome Windows MacOS
  • SOLVED: Angular 6 CLI Karma Stuck in Single Run | Karma Stops Running
  • How to Manually Install Java 8 on Ubuntu 18.04 LTS
  • Remove VirtualBox from Ubuntu 16.04 Xenial
  • Clear all Node Modules Folders Recursively Mac/Linux

Recent Comments

  • KKV on Webstorm adding spaces between imports and braces | JavaScript and TypeScript
  • jusopi on Clear all Node Modules Folders Recursively Mac/Linux
  • Qaisar Irfan on Clear all Node Modules Folders Recursively Mac/Linux
  • mustafa on Remove VirtualBox from Ubuntu 16.04 Xenial
  • Pourya on How to Manually Install Java 8 on Ubuntu 18.04 LTS

Archives

  • May 2019
  • May 2018
  • April 2018
  • March 2018
  • January 2018
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • March 2017
  • December 2015
  • November 2015
  • July 2015
  • April 2015
  • February 2015
  • September 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • October 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • December 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • May 2012
  • March 2012
  • February 2012
  • December 2011
  • November 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • August 2009
  • July 2009
  • May 2009

Categories

  • Angular
  • Angular 2
  • AngularJS (1x branch)
  • Computer Q&A
  • ES2015
  • Internet Marketing
  • Javascript
  • Job Interviews
  • Job Search
  • Karma
  • Laravel
  • Linux
  • Linux/Unix Tips
  • MacOS
  • Microsoft Access
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft Word
  • News
  • Node
  • Open Source
  • PHP
  • Protractor
  • Resume Writing
  • Spring Boot
  • SQL
  • Ubuntu
  • VBA
  • VBScript
  • VirtualBox
  • Web Development
  • Windows Tips
  • Wordpress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in

 

Loading Comments...