Here are the instructions for setting up a Linked Server from Microsoft SQL Server to our QQube SQLAnywhere Database.
You will have access to the following views prefixed by QQubeFinancials. and QQubeUser.
You should see the SQL Anywhere OLE DB Provider in the list of SQL Server Providers:
If you do NOT, then please do the following:
Right click on the 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:
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) as explained in the top of this guide.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/356/setting-up-a-linked-server
Your session has expired. You are being logged out.