1
I need to create a Linked Server connection to my client’s SQL Server 2008 database. This Linked Server will be with an Oracle database.
My SQL Server 2008 database is in a server of my client. The Oracle database is in another remote server. Maybe to access this server, I am obliged to make a connection to the VPN of the machine where this Oracle database is.
Can anyone tell me how I make this Linked server connection to an Oracle database? I found this code below example, which requires IP, bank name, login and password:
EXEC sp_addlinkedserver
@server = 'DBMV',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle',
@datasrc = '(DESCRIPTION=ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.0.65)(PORT = 1521))(CONNECT_DATA=(SID=dbmv)))'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'DBMV',
@useself = 'FALSE',
@rmtuser = 'leomar',
@rmtpassword = 'leomar123'
GO
But I wanted to know if this example works, if there is another way and if within this connection I need to consider the VPN (IP, login and password).