!! Announcement !! Logic Apps In-app connectors for IBM Mainframe and Midranges Generally Available
We are excited to announce the General Availability of the Azure Logic Apps Built-in connectors for IBM Mainframe and Midranges. This release allows customers conducting mainframe and midranges modernization to Azure to have the right tools to allow them to gradually implement Hybrid Architectures and continue providing business value.
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!
