PROBLEM

No connections available in the SQL Connect dialog box

Last Published: April 25, 2020

Description

None of the Data Source Names (DSNs) set up for ODBC connections on the machine are listed in the Connection drop down list on the SQL Connect dialog box.

Cause

There are two circumstances which may cause this problem;

· There are DSNs on the machine but none available to the user currently logged in.

· The ODBC32.dll file is bad.

Solution or Workaround



  • Create DSNs for all users.

    1. Log in as a user who has access to the DSNs.
    2. Create DSNs for the current user.
    3. Create all DSNs as System DSNs so they will be available to all who log into the machine.

  • Reinstall 32 bit ODBC drivers. Download the latest version of Microsoft Database Access (MDAC) ODBC drivers from the link below.

Article ID:000003586

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic