Hello All!

I'm trying to setup a linked server from SQL2000 to Oracle10g using this
syntax:

EXEC sp_addlinkedserver 'HKEMSLO', 'Oracle', 'MSDAORA', 'LOHK'
EXEC sp_addlinkedsrvlogin 'HKEMSLO', 'FALSE',NULL, 'user', 'password'

and keep getting this error:

Error 7399: OLE DB provider 'MSDAORA' reported an error.
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].

What am I doing wrong??

Thanks,
Curtis


**************************************************************************************************************

The information contained in this e-mail (along with any attachments) is intended only for the use of the individual(s) to whom it is addressed. It is confidential and may contain privileged information. If the reader of this message is not the intended recipient, you are hereby notified that you should not read its contents, and any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received it in error, please immediately (1) delete this transmission and any attachments and (2) notify [Email address protected] to advise us of the error. THIS E-MAIL IS NOT AN OFFER OR ACCEPTANCE: Notwithstanding the Uniform Electronic Transactions Act or any other law of similar import, absent an express statement to the contrary contained in this e-mail, neither this e-mail nor any attachments are an offer or acceptance to enter into a contract, and are not intended to bind the sender, Pilgrim’s Pride Corporation, or any of its subsidiaries, or any other person or entity.

**************************************************************************************************************


MS Sql Server LazyDBA home page