In creating a SQL7 link to an Oracle DB; what is the difference in ServerName and MyServer in the below listed link syntax? My machine name is Box, the connection string is local.domain, the database name is myName, what goes where?
example:
EXEC sp_addlinkedserver
@server = 'Servername',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'MyServer'
Thanks,
Rod
example:
EXEC sp_addlinkedserver
@server = 'Servername',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'MyServer'
Thanks,
Rod