Re: OraOLEDB.Oracle, ref cursors and VB

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:499mf.28458$dO2.19541_at_newssvr29.news.prodigy.net...
> I'm working with 8i on XP.
>
> I downloaded some sample code from otn that shows how to pass multiple ref
> cursors from a sp using VB. The sample uses OraOLEDB.Oracle provider.
When
> I try to connect using that provider I get the message "Provider cannot be
> found. It may not be installed properly."
>
> Googling, I found many discussions of this problem but couldn't find a
> solution.
>
> I am able to connect to the db using MSDAORA provider.
>
> Is OraOLEDB.Oracle supposed to be part of the 8i client?
>
> If I can't get OraOLEDB.Oracle to work, will MSDAORA permit passing ref
> cursors as demonstrated in the Oracle provided example?
>
> Any suggestions appreciated.
> Randy Harris
>

I found the OraOLEDB driver on Metalink and downloaded it. I haven't been able to install it because I can't get the Oracle Installer to run. The setup.exe won't start. I tried the original 8.1.7 CD, same problem. The installer won't run.

Anyone have an idea how to get installer to run? Received on Fri Dec 09 2005 - 16:16:18 CST