"Provider cannot be found." - Windows 7 64 bit, Oracle OLEDB

HICKORYTECH
HICKORYTECH used Ask the Experts™
on
We are attempting to run an old client\server application written in VB 6 and using the 10G Oracle OLEDB provider on a 64 bit Windows 7 machine and are encountering the following error shown in the attached image.

Initially we did have the 64 bit 10G (Vista) client installed; but, even after uninstalling that (including manual steps to remove items from registry and GAC), and installing the 32 bit client, we're still receiving this error. Error message
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
You need to configure x32 bit ODBC for the usage if you are trying to connect
to Oracle DB.So you must create appropriate data-source using the ODBC found in systemWOW folder...



Top Expert 2010

Commented:
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Wrong. We are not talking about ODBC drivers, but OLEDB. However, if you have installed the 32bit client, and the program is running in 32bit mode (which it does for sure), you should be set. Did you check if Oracle Universal Installer really created an OLEDB provider for Oracle (in the registry)?

Author

Commented:
Sorry for the delay folks.  Confirmation of the above is currently on hold.  Thanks for your comments!  I'll return back soon to confirm.  

It is indeed an OLE issue; though I suppose confirmation of ODBC may well have given some indication as to the successful installation of the 32 bit client as a whole.  I was also somewhat putting the feelers out if anyone might know of an issue with the technically not officially supported 10.2.0.4 Oracle Client on Windows 7.

Olemo, thanks for the confirmation that it would indeed be trying to use the 32 bit version for sure.  Brief reading suggested that was the case; but wasn't positive of that just yet.  Way to pick up on that subtle uncertainty!
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
In particular with W7 x64, the only proper Oracle Client is the 11g one. ODBC has more than only one issue on 10R2 client, but it (usually) works.
The 11g client is working with versions down to 9i (not sure of 9.0), but not 8.1.7 and below. So it does not really matter (regarding interoperability) whether you need to use 11g or 10g clients.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial