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
ShriInstall 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...
> >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
>
>|||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...
>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...
>> >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
>>