Monday, February 20, 2012

linked server

how can i make a linked server in sql server for Sybase adaptive server anywhere 9.0 ?

http://support.microsoft.com/?id=280102

-- Adding linked server:
exec sp_addlinkedserver @.server = 'Sybase Linked Server Name' ,
@.srvproduct = 'Sybase',
@.provider = 'MSDASQL',
@.datasrc = 'Sybase System DSN'
-- Adding linked server login:
sp_addlinkedsrvlogin @.useself='false ', @.rmtsrvname = 'Sybase Linked Server Name',
@.rmtuser = 'User Name',
@.rmtpassword = 'Strong Password'

No comments:

Post a Comment