Re: Oracle linked server : won't run if driver AllowInProc is off

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bhanu (SQLDBA1999_at_yahoo.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 10:23:19 -0400

Why don't you use oracle driver instead? You can install ORACLE client on
the SQL box and you should be able to get it working with no issues.

HTH

"/dev/null" </dev/null@discussions.microsoft.com> wrote in message
news:9B5EF51E-2CBA-4B2F-8841-0A400396288A@microsoft.com...
> I've tested a link server from msde to oracle on a win2k server test
machine
> and after some effort, it worked properly. I noted down the steps i took
to
> get it to work. I could enable or disable AllowInProc for the Microsoft
OLE
> DB Oracle driver i was using to interface with Oracle. This machine is in
a
> test domain.
>
> Now i wanted to configure the same thing on a server in our real domain.
> That server is a true SQL server and is running multiple instances. The
> thing is, i can't seem to get it to work if i disable the driver's
> AllowInProc. When i disable AllowInProc i get this error mesage when
trying
> to see the tables of the linked server using Enterprise Manager:
>
> Error 7399: OLE DB provider 'MSDAORA' reported an error. Access denied.
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IUnknown::QueryInterface
> returned 0x80070005: Access denier.].
>
> I tried reinstalling the latest MDAC (2.8) and rebooting the server
> afterwards but it didn't change anything. I checked the Microsoft article
> 280106 and tried
>
> If anybody has any ideas on this i'd be happy to read about them since i
am
> kind of running out of ideas right now...

Relevant Pages