add an Oracle linked server as a subscriber

Hi,
I have an Oracle 9i client installed on SQL Server 2000, and I want to add a linked Oracle server to SQL Server so that I can use the linked Oracle server as a subscriber, I got an error says 'OLEDB error, OLEDB error trace: initialize returned 0x80004005
', and I can not view the tables or views in the Oracle linked server, can anybody help me on this?
Hong
80004005 is generic access denied you need to use a login and password on
your linked server which maps to SYSDBA or SYSTEM on the Oracle server.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hong Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:E7D43F27-B100-4CE1-A32C-B084E8EC2C96@.microsoft.com...
> Hi,
> I have an Oracle 9i client installed on SQL Server 2000, and I want to add
a linked Oracle server to SQL Server so that I can use the linked Oracle
server as a subscriber, I got an error says 'OLEDB error, OLEDB error trace:
initialize returned 0x80004005', and I can not view the tables or views in
the Oracle linked server, can anybody help me on this?
> Hong