-1

I'm getting this error

Provider cannot be found. It may not be properly installed. Code: 800a0e7a Source: ADODB.Connection" when I try to run my VBScript

It's trying to connect to an Oracle database, here is the connection string: 

Provider=OraOLEDB.Oracle;
Data Source=Data;
User Id=Username;
Password=password;

I have Oracle Client 32 installed, my machine is a 64 bit system. I've tried re-register Oracle OLEDB provider dll with: C:\Windows\SysWOW64\regsvr32 \bin\OraOLEDB12.dll

I've tried opening it with a 32 bit driver and still keep getting that error. Any ideas?

cacti5
  • 2,006
  • 2
  • 25
  • 33
tngo
  • 43
  • 1
  • 4

1 Answers1

0

By default your script will run in 64-bit mode. As your Oracle client is 32-bit you must run your script also 32-bit mode.

Try c:\Windows\SysWOW64\cscript.exe {your_script.vbs} to run it. Otherwise you would have to install the 64-bit version of Oracle Client.

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110