Troubleshooting

This section discusses the possible issues and the steps you can take to troubleshoot Enterprise Recon ODBC Driver issues.

Error / Symptom	Troubleshooting Steps
General symptoms: Unable to connect to the Master Server instance via ODBC Error messages received when connecting or performing authentication	Make sure that the following requirements are met: Using an ER2 PRO license on an Enterprise Recon (ER2) Master Server version of 2.2 and above or Enterprise Recon Cloud (ER Cloud) Master Server version 2.11.1 and above. TCP connections to port 11117 is not blocked by a firewall. The ODBC service is running on the Master Server. In the Web Console, go to System > Server Information. Go to the System Services section and verify that the ODBC service is running.
Enterprise Recon data source (Enterprise Recon 64 System / Enterprise Recon 32 System) is not listed or available in client application ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (64-bit) and Application (32-bit)	Make sure that the installed ODBC Driver matches the client application platform. See Verifying the ODBC Driver Installation for more information.
ODBC: ERROR [08001] Cannot authenticate: ODBC access requires global detail reporting permission	Make sure that the user account that is used for the ODBC login credentials has the following permissions: Global Permissions - Global Admin, or Resource Permissions - Detailed Reporting for all Targets and Groups. See User Permissions for more information.
ODBC: ERROR [08001] Remote server must be specified [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed	The Master Server host name or IP address must be specified with the srv attribute in the connection string. See Connection Requirements for more information.
ODBC: ERROR [37000] Requires PRO edition license	Enterprise Recon ODBC Reporting is only available in Enterprise Recon PRO and Enterprise Recon Cloud PRO. To find out more about upgrading your Enterprise Recon license, please contact Ground Labs Licensing. See Subscription License for more information.
ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (64-bit) and Application (32-bit)	Enterprise Recon ODBC Reporting is only available in Enterprise Recon PRO and Enterprise Recon Cloud PRO. To find out more about upgrading your Enterprise Recon license, please contact Ground Labs Licensing. See Subscription License for more information.