Priovider cannot be found.

[annpricks]

Hi All,
I got the below error while running my code

RunTime error 3706.Priovider cannot be found.It may not be properly installed.

My code is look like

/* Piece of Code */

Please Login or Register  to view this content.

How i resolve this problem?

Thanks
Ann

[Kyle123]

Is OraOLEDB.Oracle installed on your computer?

[annpricks]

How do i check?

[Kyle123]

Well unless you've installed it, it won't be. An oracle connection provider is not part of a standard setup

[annpricks]

Is there anyother way to connect oracle database?

[Kyle123]

Well you'll probably want to download a provider, have a look here: http://www.oracle.com/technetwork/da...ex-101290.html

[annpricks]

What About MSDAORA provider?

[Kyle123]

Yeah, that looks promising, give it a whirl

[annpricks]

Same installation error i got.

[Kyle123]

Then I guess you're going to need to install and oracle provider....

[arlu1201]

Annpricks,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.