yuibox

Here is how you link you ODBC server. Just open SQL Management Studio-> New Query and type this:

EXEC sp_addlinkedserver

@server = ‘MyServer’, — the name of your linkserver

@srvproduct = ”,

@provider = ‘MSDASQL’, — This is the default for ODBC server, for more info please reffer to MS Site

@datasrc = ‘lotus’ –DSN name

GO
Read the rest of this entry »