How do I create an ODBC connection using sp_addlinkedserver in SQL using a DSN-LESS connection string?
I assume I am doing something wrong with syntax, here is how I set up the connection:
EXEC master.dbo.sp_addlinkedserver @server = N'SERVER_NAME', @srvproduct=N'Oracle', @provider=N'MSDASQL', @provstr=N'DataSource=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER_NAME)(PORT=INSTANCE_PORT)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))' GO
Any ideas?
Thanks in advance.