SQL Server Linked Server to ASA 9.0 Error 7399

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?

mssql asa-9 remote-server

asked 14 Sep '17, 09:36

Jongee
217●17●17●22
accept rate: 0%

edited 15 Sep '17, 15:11

Volker Barth
40.2k●361●550●822

flat view

One Answer:

active answers oldest answers newest answers popular answers

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:

You get 7399 and 7300 error messages when accessing a linked server

permanent link

answered 15 Sep '17, 15:21

Volker Barth
40.2k●361●550●822
accept rate: 34%

edited 15 Sep '17, 15:22

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

asa-9 ×108
remote-server ×56
mssql ×41

question asked: 14 Sep '17, 09:36

question was seen: 2,835 times

last updated: 15 Sep '17, 15:22

SAP SQL Anywhere

SQL Server Linked Server to ASA 9.0 Error 7399

Follow this question

Related questions