views:

13

answers:

0

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.