Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

K-
Well, whatever. I solved it by myself.
968865
Can you provide details how?
Rafhael Dantas
So, what was the solution?
K-
I installed Oracle DAC 32-bits on the same machine, the provider was found successfully.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 24 2012
Added on Oct 10 2012
#oracle-provider-for-ole-db, #windows-and-net
4 comments
4,373 views