For users new to Enterprise geodatabases its possible that an attempt to create, save, or edit a new geodatabase fails with an error message that references a missing DBMS table or ODBC Driver.
The Open Database Connectivity (ODBC) is an API for database management systems (DBMS). It's a component needed by an application on the PC (ArcGIS) to effectively connect with the database management on the server that hosts the data (SQL Server, in this case).
It's important that the ODBC Driver version is appropriate to the version of ArcGIS Enterprise installed. To download support files:
- go to myesri.com > My Organizations > Downloads.
- Select "Products" in the left panel if its not selected automatically.
- Find "ArcGIS Enterprise (Windows)", or (Linux) if applicable, select the version installed from the drop down menu, and then select the "View Downloads" button.
* Optional: check for software patches that might affect the version of ArcGIS components installed.
Under the ArcGIS Enterprise (Windows) downloads there are several components available for download. Scroll to the "Database Support Files" section and locate the Microsoft ODBC Driver version that was provided in the error message. Possible versions are: 11, 13.1, or 17.
Verify the Windows system type (32-bit or 64 bit). This information can be found by selecting the Start button on the PC > Settings > System > About > Device specifications.
Select Download and then double-click from the downloads folder to install. The PC might require a restart.
Please be aware that during install a message might appear indicating that the latest version of the ODBC driver is already installed. It's important that the version required may not necessarily be the latest version of the driver.
An alternate location to download the ODBC Driver for SQL Server is the Microsoft.com downloads site.