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? |
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: |