When using SQL Anywhere mirroring, and connecting through ODBC...

[Former Member]

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

[former_SQLA_member1694880]

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

[ian_mchardy]

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:

UID=...;PWD=...;ServerName=PrimaryAlternateServerName;Host=partner1_host:port,partner2_host:port

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