Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I'm running two sibling SQL Anywhere 16 database servers, each one having a remote server connection to its 'sibling', in order to gain access to live data being entered in the sister company. When looking at all the remote connections on either server, there is no way to identify the source of the remote connection on this server coming from the other server.

Is there a way to create those remote connections using a parameter which will allow me to know its source?

Also, I am using an ODBC connection between the two servers, only because I'm most familiar with them. I could theoretically change that...

asked 26 Nov '20, 23:46

Joel%20Wittels's gravatar image

Joel Wittels
accept rate: 0%

You can use add the CON connection parameter to the USING clause within the CREATE SERVER or ALTER SERVER statements, for details see this similar FAQ.

E.g. something like the following on the first server (and vice versa for the other one):

USING 'DRIVER=SQL Anywhere Native;DSN=RemoteDS;CON=Sibling1';

As the cited FAQ explains, you can also use variables within the USING clause.

permanent link

answered 27 Nov '20, 02:50

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 27 Nov '20, 02:54

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 26 Nov '20, 23:46

question was seen: 1,034 times

last updated: 27 Nov '20, 02:54