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:



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