It works! Now, how can I secure that id/passwd? What is the syntax to compare the local table (prod_master) to the remote table (wmitf) and update the local...

Here is the linked server sql I ran:

USE MASTER

GO

EXEC sp_addlinkedserver

@server = 'indy22a',

@srvproduct = 'Oracle',

@provider = 'MSDAORA',

@datasrc = 'i22p'

I must be missing something. I tried both options, but I got this error:

select * from openrowset ('MSDASQL','Provider=OraOLEDB.ORACLE.1;SERVER=i22p;UID=myid;PWD=mypasswd',wmitf) AS RemOrc

Ad hoc access to OLE DB provider 'MSDASQL' has been...

SQL Server 2000 v 8.00.194

Oracle Client 8.1.6

ODBC SystemDSN = I22p

Oracle Table is wmitf

Name Null? Type ...

I have an order management system with it's own copy of an item product master table. I want to link to the Oracle table using SQL Server 2000 and...