topic Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap? in Data Management Questions

version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

AndreaB_ — Thu, 18 Apr 2024 15:32:02 GMT

Hi all,

We are mainly using ArcGIS Pro 3.2.2 but we have some users still on ArcMap 10.8.x. Our geodatabase is in SQL Server 2022 with compatibility mode set to 2019 (so ArcMap can connect to it). I was under the assumption, then, that our computers would need Microsoft ODBC driver 17 for SQL Server. Here is the info I got from Esri websites:

ArcMap 10.8.x: Supported SQL Server clients are as follows:

SQL Server 2019
Microsoft ODBC Driver 17 for SQL Server

With Pro 3.2. Supported minimum SQL Server clients are as follows:

SQL Server 2022
Microsoft ODBC Driver 18.1 for SQL Server**

However, I have a user getting error message: "Failure to access the DBMS server [Failure to access the DBMS server] [layer name][STATE_ID = 281898]"

What version of Microsoft ODBC Driver for SQL Server do we need in this environment?

Thank you,

Andrea

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

Asrujit_SenGupta — Thu, 18 Apr 2024 16:18:11 GMT

Where are you getting the error - ArcGIS Desktop or ArcGIS Pro? Are you installing both the ODBC drivers on every client machine?

Which version of Microsoft ODBC driver 17 did you install? Try installing the latest available Version 17.10.6 and check.

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

MarceloMarques — Thu, 18 Apr 2024 17:46:50 GMT

@AndreaB_ - You cannot have both ODBC 18 and 17 installed on the same machine, the workaround is to uninstall ODBC 18 and keep only ODBC 17, then both ArcMap and ArcGIS Pro will be able to connect. I mention this issue in my community.esri.com white paper below.

How to Install the SQL Server Client for ArcGIS?

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

AndreaB_ — Thu, 18 Apr 2024 19:00:01 GMT

The error was coming from ArcGIS Pro. All machines have 1 version of 17 ODBC. But not that latest one you mention. So I can try that too. Thank you.

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

AndreaB_ — Thu, 18 Apr 2024 19:15:59 GMT

Yeah makes sense. There might be more going on with our system than just the ODBC client. But at least we know that part is correct. Thanks!

Re: version of Microsoft ODBC driver for SQL Server 2022 but with SQL set to 2019 compatibility mode to work with ArcMap?

CBarrett — Thu, 19 Dec 2024 16:23:19 GMT

It would be nice if the docs weren't telling us to delete 17 and install 18 unnecessarily when we upgrade to SQL 2022:

@MarceloMarques wrote:
@AndreaB_ - You cannot have both ODBC 18 and 17 installed on the same machine, the workaround is to uninstall ODBC 18 and keep only ODBC 17, then both ArcMap and ArcGIS Pro will be able to connect. I mention this issue in my community.esri.com white paper below.
How to Install the SQL Server Client for ArcGIS?

https://enterprise.arcgis.com/en/system-requirements/10.9.1/windows/database-requirements-sqlserver.htm