Problem Linking to Oracle 9i

Last Post 04 Aug 2004 08:42 AM by xfonhe. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
xfonhe
New Member
New Member

--
04 Aug 2004 08:42 AM
OPENQUERY uses linked server authentication to retrieve data sets. That's probably where your issue lies: your account used in the SELECT differs from the credentials specified in the linked server configuration (utilized by OPENQUERY)

You can perform DML via OPENQUERY. NOTE: you cannot pass variables (@) via OPENQUERY.
You are not authorized to post a reply.

Acceptable Use Policy