SQL Server Linked Server to ASA 9.0 Error 7399

[Former Member]

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?

[VolkerBarth]

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

• link server from sqlserver 2012 to ASA 9
• What options for a MS SQL Server Linked Server provider does the SA OLEDB provider support?

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