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