Hi

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, 09:36

Jongee's gravatar image

Jongee
187111219
accept rate: 0%

edited 15 Sep, 15:11

Volker%20Barth's gravatar image

Volker Barth
31.5k318461676


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, 15:21

Volker%20Barth's gravatar image

Volker Barth
31.5k318461676
accept rate: 33%

edited 15 Sep, 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

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

Question tags:

×101
×48
×29

question asked: 14 Sep, 09:36

question was seen: 147 times

last updated: 15 Sep, 15:22