Setting Up a SQL Linked Server

Modified on Sun, 26 Jul at 3:43 AM

Overview

This guide explains how to create a Microsoft SQL Server linked server that connects to the QQube SQL Anywhere 17 database.

The linked server provides access to authorized QQube views under the QQubeFinancials and QQubeUser owners.

Available QQube Views

Prefix	Purpose
vf_	FACT views.
vd_	DIMENSION views, including QuickBooks lists.
vdf_	Transaction DIMENSION views, including geography, document attributes, and line attributes.
vl_	LOOKUP views used to retrieve lists of values. These are used in the Company Setup data models.

Configure the SQL Anywhere Provider

1. Confirm the Provider Is Available

In SQL Server Management Studio, expand Server Objects > Linked Servers > Providers.

Confirm that the SQL Anywhere OLE DB Provider appears in the provider list.

SQL Server provider list showing the SQL Anywhere OLE DB Provider

2. Register the Provider if It Is Missing

Complete this step only when the SQL Anywhere OLE DB Provider does not appear in the provider list.

Open a Command Prompt using Run as administrator.
Navigate to:

C:\Program Files (x86)\CLEARIFY\QQube Tool\SQL Anywhere 17\BIN64

Run regsvr32 for both provider files:

regsvr32 dboledb17.dll
regsvr32 dboledba17.dll

Command Prompt registering the SQL Anywhere OLE DB provider files

3. Enable Allow Inprocess

Right-click SAOLEDB.17.
Select Properties.
Select Allow inprocess.
Click OK.

SQL Server provider properties with Allow inprocess selected

Create the Linked Server

1. Open the New Linked Server Window

In SQL Server Management Studio, expand Server Objects.
Right-click Linked Servers.
Select New Linked Server.

SQL Server Management Studio New Linked Server command

2. Complete the General Page

Setting	Value
Linked server	QQUBE
Provider	SQL Anywhere OLE DB Provider 17
Product name	SQL Anywhere
Data source	QQubeFinancials

Required Data Source Name

The Data source value must be QQubeFinancials. Do not change this name.

SQL Server linked server General settings for the QQube SQL Anywhere database

3. Complete the Security Page

Select Security and enter the required QQube linked-server security settings.

SQL Server linked server Security settings for QQube

Click OK when the configuration is complete.

Verify the Linked Server

Expand the new QQUBE linked server and open the Views folder.

Your account does not have access to the underlying tables or to every database view. Use the authorized views described at the beginning of this guide.

SQL Server linked server tree showing QQube database views

Expected Result

The QQUBE linked server appears in SQL Server Management Studio. Authorized QQubeFinancials and QQubeUser views are available under the linked server's Views folder.