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

This code will just add the server to your Link Servers list.In order to ensure it executed succesfully you can try this:

EXEC sp_tables_ex ‘MyServer’
go

EXEC sp_tables_ex @table_server = ‘MyServer’
go

SELECT * FROM OPENQUERY(MyServer, ‘SELECT * FROM TableName’)
go

If it has user and password use this:

EXEC sp_addlinkedsrvlogin
@rmtsrvname = ‘MyServer’,
@useself = false,
@locallogin = NULL,
@rmtuser = ‘yuibox’,
@rmtpassword = rawr
GO

Hope it helps!

Stumble it!