Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


I am trying to connect a Microsoft SQL Server to Adaptive Server Anywhere 9.0 as a Linked Server. When I test the connection I have made it reports back OK.

When I try to view the tables of the ASA 9 I get a Microsoft SQL Error 7399, from what I can tell is to do with security.

I have set up an ODBC connection with the login credentials specified and outside of SQL server, this works fine.

Any suggestions?

asked 14 Sep '17, 09:36

Jongee's gravatar image

accept rate: 0%

edited 15 Sep '17, 15:11

Volker%20Barth's gravatar image

Volker Barth

Have you set the required "AllowInProcess" option?

Please have a look at other FAQs here related to MS SQL Server and linked servers, such as

Note, these are not particularly focussed on SQL Anywhere 9, so details may be different.

The requirement for "in process" OLE providers when using linked servers is also explained here by Microsoft here:

permanent link

answered 15 Sep '17, 15:21

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 15 Sep '17, 15:22

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 14 Sep '17, 09:36

question was seen: 2,868 times

last updated: 15 Sep '17, 15:22