Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Provider not Found

K-Oct 10 2012 — edited Nov 26 2012
Good afternoon Oracle Forum members,

I'm having trouble on connecting a OraOLEDB.Oracle application to my Oracle Database 11g R2 (11.2.0.1.0), I have a Windows Server 2008 Enterprise machine running it.
Each time I try to connect it says: Oracle provider not found. It may be not properly installed.
I've searched many site and tried many things like:

-Registering DLLs manually using:
REGSVR32 "C:\Program Files\Common Files\System\Ole DB\sqloledb.dll"
REGSVR32 "C:\Program Files\Common Files\System\Ole DB\Oledb32.dll"
REGSVR32 "C:\Program Files\Common Files\System\Ole DB\Msdasql.dll"
REGSVR32 "C:\Program Files\Common Files\System\msadc\Msadce.dll"
REGSVR32 "C:\oracle\product\11.2.0\dbhome_1\BIN\oraoledb11.dll"

-Installing the client with ODAC112012 pack that comes with 32 bit features (but after it the database stops working properly.

-Installed the client with ODTwithODAC112012 (but after it the database stops working properly)

-Formatting and re-installing Win 2008 Server Enterprise, Oracle Database 11g R2 and all applications (did it more than 4 times)

-Changing the provider from OraOLEDB.Oracle to MSDAORA (results in "Unknown Provider" message)

Is there something I did wrong? Is there something else I have to do to make it work properly?



Thank you very much!

Edited by: K- on Oct 10, 2012 3:44 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2012
Added on Oct 10 2012
4 comments
4,409 views