https://community.sap.com/t5/technology-q-a/sql-server-linked-server-to-asa-9-0-error-7399/qaa-p/13843226#M4874069 <P>Have you set the required "AllowInProcess" option?</P> <P>Please have a look at other FAQs here related to MS SQL Server and linked servers, such as</P> <UL> <LI><A href="http://sqlanywhere-forum.sap.com/questions/19048">link server from sqlserver 2012 to ASA 9</A></LI> <LI><A href="http://sqlanywhere-forum.sap.com/questions/9955">What options for a MS SQL Server Linked Server provider does the SA OLEDB provider support?</A></LI> </UL> <P>Note, these are not particularly focussed on SQL Anywhere 9, so details may be different.</P> <P>The requirement for "in process" OLE providers when using linked servers is also explained here by Microsoft here:</P> <UL> <LI><A href="https://support.microsoft.com/en-us/help/2450479/you-get-7399-and-7300-error-messages-when-accessing-a-linked-server">You get 7399 and 7300 error messages when accessing a linked server</A></LI> </UL> Fri, 15 Sep 2017 15:21:10 GMT VolkerBarth 2017-09-15T15:21:10Z https://community.sap.com/t5/technology-q-a/sql-server-linked-server-to-asa-9-0-error-7399/qaq-p/13843225 <P>Hi</P> <P>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.</P> <P>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.</P> <P>I have set up an ODBC connection with the login credentials specified and outside of SQL server, this works fine.</P> <P>Any suggestions?</P> Thu, 14 Sep 2017 09:36:41 GMT https://community.sap.com/t5/technology-q-a/sql-server-linked-server-to-asa-9-0-error-7399/qaq-p/13843225 Former Member 2017-09-14T09:36:41Z https://community.sap.com/t5/technology-q-a/sql-server-linked-server-to-asa-9-0-error-7399/qaa-p/13843226#M4874069 <P>Have you set the required "AllowInProcess" option?</P> <P>Please have a look at other FAQs here related to MS SQL Server and linked servers, such as</P> <UL> <LI><A href="http://sqlanywhere-forum.sap.com/questions/19048">link server from sqlserver 2012 to ASA 9</A></LI> <LI><A href="http://sqlanywhere-forum.sap.com/questions/9955">What options for a MS SQL Server Linked Server provider does the SA OLEDB provider support?</A></LI> </UL> <P>Note, these are not particularly focussed on SQL Anywhere 9, so details may be different.</P> <P>The requirement for "in process" OLE providers when using linked servers is also explained here by Microsoft here:</P> <UL> <LI><A href="https://support.microsoft.com/en-us/help/2450479/you-get-7399-and-7300-error-messages-when-accessing-a-linked-server">You get 7399 and 7300 error messages when accessing a linked server</A></LI> </UL> Fri, 15 Sep 2017 15:21:10 GMT https://community.sap.com/t5/technology-q-a/sql-server-linked-server-to-asa-9-0-error-7399/qaa-p/13843226#M4874069 VolkerBarth 2017-09-15T15:21:10Z