The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

BH Hi, I am using SQL Anywhere mirroring, and my users are connecting through ODBC Administrator. If the primary server fails, does ODBC profile have to be changed to connect to the mirroring server? I was under the impression, that if server1 fails, the users will still be able to connect without having to change the "Data Source Name" or the "Server Name" in the ODBC Administrator. Was I under the wrong assumption? Thanks Aron

asked 24 Dec '13, 18:21

arony's gravatar image

accept rate: 0%

No. It is what an alternate server name (-sn) is for.

permanent link

answered 25 Dec '13, 01:09

Dmitri's gravatar image

accept rate: 11%

The connection string that the client should be using to connect to which ever server is the current primary and should be of this (or an equivalent) form:


If using a ODBC Data Source, it is strongly recommended that you do not include the user id or password in the datasource.

(02 Jan '14, 09:34) Ian McHardy
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: 24 Dec '13, 18:21

question was seen: 655 times

last updated: 02 Jan '14, 09:35