Access ODBC does not recognize automatic client reroute
Hi, I have an ODBC connection to a DB2/LUW database in MS/Access (2016) and am trying to implement ACR (Automatic Client Reroute). I have added the following (bold) to my db2dsdriver.cfg file: <database name="MYDBASE" host="DBHOST1" port="60000"> <parameter name="hostname" value="DBHOST1"/> <parameter name="port" value="60000"/> <parameter name="AltHostName" value="DBHOST2"/> <parameter name="AltPort" value="60000"/> <acr> <parameter name="enableAcr" value="true"/> <parameter name="maxAcrRetries" value="10"/> <parameter name="acrRetryInterval" value"1"/> <parameter name="enableseamlessACR" value="true"/> <parameter name="enableAlternateServerListFirstConnect" value="true"/> <alternateserverlist> <server name="otherserver" hostname="DBHOST2" port="60000"/> </alternateserverlist> </acr> </database> I have tested this on my machine and it successfully falls over to the alternate server when the primary server is unavailable. However, when I attempt to connect to the database in MS/Access, I get a connectivity error (SQL30081N) Has anyone worked with MS/Access and ACR? Thanks!