I am trying to create a Linked Server to Oracle via SQL Server 7.0. The OS on the machine is Windows NT 4.0 and the version of the MDAC is 2.6. I have installed Oracle 8.1.7 client on my machine. I created the linked server using the follwoing scripts:

exec sp_addlinkedserver 'Link', 'Oracle', 'MSDAORA', 'Link'

exec sp_addlinkedsrvlogin 'Link', false, null , 'scott', 'tiger'

The messgage is shown as "Server Added". But when I go to Enterprise Manager and expand the LINK server, it give me the follwoing error:

Error 7399: OLE DB driver 'MSDAORA' reported an error message.

I am able to conenct to the Oracle DB using SQL Plus.

Please let me know if anyone has faced a similar issue.