Setting Up a QQube to SQL Linked Server | CLEARIFY

Setting up a QQube Linked Server in Microsoft SQL Server

You should see the SQL Anywhere OLE DB Provider in the list of SQL Server Providers:

If you do NOT, then please visit this topic to install the Provider.

NOTE for versions of 5.x it is SAOLEDB.12  For versions 6.x or later it is SAOLEDB.17

If it IS present:

Right click on the SAOLEDB.12 (or SAOLEDB.17) Provider to bring up the following screen and check Allow inprocess: (This step is VERY important)

Click OK when done.

Right click on the Linked Servers folder and click New Linked Server:

For the General portion of the setup:

Next click on the Security option:

Click OK when done.

Your new linked server will have a tree similar to the following.  Go to the Views and expand as you will not have permission for any of the tables (and some views).

Expand the Views: