• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

How to access data on authenticated ASA server from ASE server

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 Franek
Jan Franek
1 Solution
Jan FranekAuthor Commented:
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.
Closed, 500 points refunded.
Experts Exchange Moderator
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now