Getting data from SQL7 server

Last Post 16 May 2002 07:41 AM by Si_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Si_SQL
New Member
New Member

--
16 May 2002 07:41 AM
Hello,

Other than creating a remote server on each box, what steps do I need to take to be able to execute a stored proc on a 6.5 box to retrieve data from the 7.0 server. (I know upgrade the 6.5 box would be sensible but that's not an option just yet)

7.0 onwards allows you to prefix an object with server.dbname.owner whereas 6.5 only allows dbname.owner. How do you specify the server?

Many thanks for any hints, tips, ideas, complete coded solutions :-) etc.

Si
You are not authorized to post a reply.

Acceptable Use Policy