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
76449
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):

CREATE SERVER SRV_Sibling2
CLASS 'SAODBC'
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
37.7k347514780
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×256
×55
×44
×30

question asked: 26 Nov '20, 23:46

question was seen: 375 times

last updated: 27 Nov '20, 02:54