Application Note for QuNect ODBC for QuickBase

Creating a Linked Server for Quickbase in SQL Server

Most importantly you must install QuNect ODBC for QuickBase on the machine that is running the SQL Server service. This is typically not the same machine that you are running SQL Server Management Studio (SSMS) on. To create a linked server make sure your system DSNs are configured. If your SQL Server service is a 64 bit service then you must configure a 64 bit system DSN of QuNect ODBC for QuickBase. If your SQL Server service is a 32 bit service then you must configure a 32 bit system DSN of QuNect ODBC for QuickBase. User DSNs will not allow you to create a linked server. Then run the following SQL. The @datasrc parameter is the name of your system DSN.

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

If while executing queries with four part names, you get an error message like this:

Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "QUICKBASE".
A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema..

You'll need to uncheck the Level zero only property. to accomplish this go to: SQL Management Studio -> Server Objects -> Linked Servers -> Providers right click on MSDASQL and select Properties and uncheck the Level zero only property. click on �OK� and restart the SQL Server service.

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.