Application Note for QuNect ODBC for QuickBase

Creating a Linked Server for QuickBase in SQL Server

To create a linked server make sure your DSNs are configured. Then run the following SQL:

EXEC sp_addlinkedserver
@server = N'QUICKBASE',
@srvproduct=N'QuNect',
@provider=N'MSDASQL',
@datasrc=N'QuickBase via QuNect'
GO

In a few rare cases on SQL Server 2000 it seems that creating a linked server using the stored procedure sp_addlinkedserver does not work properly even though there is no indication of an error. The resulting linked server just doesn't work. The workaround in this situation is to use the UI method of creating a linked server.