server to Oracle using SQL Server 2005

I am trying to set a linked server for an Oracle base(9.2) to SQL Server
2005(June CTP).
I am able to set up the linked server but when I execute a query then I get
the following error
The OLE DB provider "MSDAORA.1" for linked server "ORACLDB" reported an
error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB
provider "MSDAORA.1" for linked server "ORACLDB".
I am able to connect to this ORACLE base using SQL PLUS. I am also able to
extract data using SSIS.
Thanks
Shri
Install the Oracle Client tools should help.
You need to have Oracle Client installed
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Shri Rao" <Shri Rao@.discussions.microsoft.com> wrote in message
news:1E6D4028-A7B3-4995-B71B-83FBB8FFB4B5@.microsoft.com...
>I am trying to set a linked server for an Oracle base(9.2) to SQL Server
> 2005(June CTP).
> I am able to set up the linked server but when I execute a query then I
> get
> the following error
> The OLE DB provider "MSDAORA.1" for linked server "ORACLDB" reported an
> error. Access denied.
> Msg 7301, Level 16, State 2, Line 1
> Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB
> provider "MSDAORA.1" for linked server "ORACLDB".
>
> I am able to connect to this ORACLE base using SQL PLUS. I am also able to
> extract data using SSIS.
> Thanks
> Shri
|||I do have the Oracle client installed and I am able to connect using SQL+, I
am also able to extract the data using SSIS.
"Dandy Weyn [Dandyman]" wrote:

> Install the Oracle Client tools should help.
> You need to have Oracle Client installed
> --
> Dandy Weyn
> [MCSE-MCSA-MCDBA-MCDST-MCT]
> http://www.dandyman.net
> Check my SQL Server Resource Pages at http://www.dandyman.net/sql
> "Shri Rao" <Shri Rao@.discussions.microsoft.com> wrote in message
> news:1E6D4028-A7B3-4995-B71B-83FBB8FFB4B5@.microsoft.com...
>
>
|||Don't use the Microsoft OLEDB Provider for Oracle, use the Oracle one
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Shri Rao" <ShriRao@.discussions.microsoft.com> wrote in message
news:8BC6A8EA-C372-442D-B793-B7C84DDCF751@.microsoft.com...[vbcol=seagreen]
>I do have the Oracle client installed and I am able to connect using SQL+,
>I
> am also able to extract the data using SSIS.
> "Dandy Weyn [Dandyman]" wrote: