topic Re: ArcCatalog 10.8.2 in ArcGIS Pro Questions

ArcCatalog 10.8.2

BrianFoley1 — Tue, 18 Jan 2022 16:23:48 GMT

I just upgraded from ArcCatalog 10.5.1 to 10.8.2. I am having an issue connecting to a SQL Server database (was having same issue in 10.5.1). The following message is what I'm getting.

I created a Universal Data Link and can successfully connect to the SQL Server database in question, using the same userid/password that I'm using in ArcCatalog.

Any ideas ?

Brian

Re: ArcCatalog 10.8.2

MichaelVolz — Tue, 18 Jan 2022 19:03:10 GMT

Do you have an appropriate Native SQL Server client installed on this machine as you said you were having this same issue in ArcCatalog 10.5.1?

Re: ArcCatalog 10.8.2

BrianFoley1 — Tue, 18 Jan 2022 19:32:20 GMT

I have SQL Server 2012 Native Client installed. The strange thing is I was able to connect up to a month ago. Then I couldn't connect. I verified with our DBA that no changes were made to the database.

Re: ArcCatalog 10.8.2

JayantaPoddar — Tue, 18 Jan 2022 19:43:30 GMT

The minimum version of SQL Server supported by ArcGIS 10.8.2 is Microsoft SQL Server 2016 (64-bit) .

Please upgrade to a supported version of database/client.

Microsoft SQL Server database requirements for ArcGIS 10.8.x and ArcGIS Pro 2.5, 2.6, and 2.7—System Requirements | Documentation

Re: ArcCatalog 10.8.2

MichaelVolz — Tue, 18 Jan 2022 23:49:05 GMT

Jayanta:

Can you install more than 1 SQL Server Native Client on a machine?

Re: ArcCatalog 10.8.2

JayantaPoddar — Wed, 19 Jan 2022 07:00:49 GMT

I believe, we can.

Re: ArcCatalog 10.8.2

MichaelVolz — Wed, 19 Jan 2022 12:52:48 GMT

How do you know which SQL Server Native Client ArcGIS is using if you have multiple Native Client versions installed on your computer?

I ask because I do not see any reference to a SQL Server Native Client in the Path environmental variable like I would see for an Oracle Client where order in the Path environmental variable is important in determining which Oracle Client is being used?

Re: ArcCatalog 10.8.2

Robert_LeClair — Wed, 19 Jan 2022 16:10:24 GMT

Right click on the ArcCatalog and "Run as Administrator" Once ArcCatalog has started, attempt to make a database connection to your SQL Server database. Does it connect?

Re: ArcCatalog 10.8.2

BrianFoley1 — Wed, 19 Jan 2022 16:47:08 GMT

I just tried this on a machine I am running ArcCatalog 10.5.1 on. Same error as in my original post.

Re: ArcCatalog 10.8.2

Robert_LeClair — Wed, 19 Jan 2022 17:53:47 GMT

Hmmm...I wonder if it's a System Requirement issue for SQL Server and ArcGIS. You mentioned you're using SQL Server 2012 but this is not supported at 10.8.x - latest edition supported is SQL Server 2014 SP 3 (64-bit). ArcGIS 10.6 supported SQL Server 2012 SP3 (64-bit). Can you create an ODBD connection in ArcCatalog?

Re: ArcCatalog 10.8.2

BrianFoley1 — Wed, 19 Jan 2022 19:17:31 GMT

I was able to connect to the database doing what you recommended.

Now, in ArcMap, when I edit one of my .mxd's, when I try to set the data source, I use the database connection I created in ArcCatalog, but no feature classes show.

Re: ArcCatalog 10.8.2

Robert_LeClair — Wed, 19 Jan 2022 19:32:44 GMT

So the OLE DB connection is a read-only connection to a database where you can see tables. It is not designed for editing of FC's and such. Only to view tables. That's why you cannot set them as a data source for your layers in the TOC. I was curious to see if the OLE DB connection would work and it appears to. Now we have to figure out why can't connect using DB connections.