<div>
OK, it seems, that I have found the answer. I have used sp_passthru to send &quot;SET TEMPORARY OPTION CONNECTION_AUTHENTICATION=<wbr />'authentic<wbr />ation code'&quot; to ASA server and now I'm able to insert, update or delete data - as long as my connection to ASA lives.
</div>


OK, it seems, that I have found the answer. I have used sp_passthru to send "SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='authentication code'" to ASA server and now I'm able to insert, update or delete data - as long as my connection to ASA lives.

<div>
<div class="content wysiwyg-content">
Hi, we are trying to export some data from system running on ASE server to accounting system, that uses authenticated edition of ASA server. I have created remote server and proxy tables on ASE and I can read data from these tables. When I try to insert some data, I get &quot;ASA Error -98: Authentication violation&quot;. I have obtained authentication code from our accounting system vendor, but I don't know how to tell ASE to use it. Does anybody know, how to pass this code to ASA ?<br />
Jan
</div>
</div>


Hi, we are trying to export some data from system running on ASE server to accounting system, that uses authenticated edition of ASA server. I have created remote server and proxy tables on ASE and I can read data from these tables. When I try to insert some data, I get "ASA Error -98: Authentication violation". I have obtained authentication code from our accounting system vendor, but I don't know how to tell ASE to use it. Does anybody know, how to pass this code to ASA ?
Jan

How to access data on authenticated ASA server from ASE server

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.