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 on a client-side server. The Oracle database is located on another remote server. Perhaps to access this server, I must first make a connection to the VPN of the machine where the Oracle database is.
Does anyone know how I can make this linked server connection to an Oracle database? I found this example code below, 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 that connection I need to consider the VPN (IP, login and password).