Re: Can't connect to Oracle using MSDAORA OLE DB provider

I',m afraid that I can't really give you a much more helpful answer than reinstall the OS then install MDAC 2.6 which is I guess not what you want to hear. However given that all the oracle components work correctly, but MS supplied components ODBC and MSDAora don't I'd suggest you try reposting to a microsoft.public.* newsgroup.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"Syarzhuk" <bamboo7431_at_hotmail.com> wrote in message
news:91e902$plr$1_at_nnrp1.deja.com...


> Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:

> >You said that you had to reinstall everything from scratch. Does that

 mean you also reinstalled the mdac?


>

> Yes. As I said, we can connect using Oracle OLE DB provider, but for some

> reason MSDAORA cannot be initialized

>

> >If not, give that a try because that is where the MSDAORA provider is

 installed.


>

> Understood. MDAC is installed. MSDAORA is installed (C:\Program

 Files\Common


> Files\System\ole db\msdaora.dll)

>

> Originally we had 2.5 installed. Then we decided to try to go back to 2.1

>

> >As far as I have ever heard, it is not possible to back out of an MDAC

 upgrade to go to a previous version


> >since the installer will simply report success even though it doesn't do

 any work because it will not overwrite


> >older files.

>

> That's what I thought. Anyway we gave it a try and now VB shows 2.1 in the

> References dialog so I assume it did overwrite - very surprising to me.

>

> >Is there some reason that you need the older version of the mdac?

> No, other than the <subj>

>

> >The current version is 2.6

> And it didn't work for us

>

> Anyway, I guess I need to clarify my question: what does MSDAORA.DLL need

 to


> "initialize provider"? -- Belarusan Music Source - http://www.belmusic.net

> Byvajce zdarovy, zhyvice bagata  Be healthy, stay wealthy

>

>

> Sent via Deja.com

> http://www.deja.com/