I am trying to select from an Oracle 9i table and get error below. I have
tried both linked servers and OPENDATASOURCE both get the same error. The
opendatasource syntax is also listed below.

The user I am using definitely has permissions to the database/table as I
can pull the information with a DTS package using the same credentials.

Any help would be great.

Thanks

Gary

Error
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.oracle' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.oracle'
IUnknown::QueryInterface returned 0x80070005: Access denied.].

Syntax
SELECT *
FROM OPENDATASOURCE(
'OraOLEDB.oracle',
'Data Source=MyOracleDB;User ID=user;Password=password'
).MyOracleDB.schema.table