Date field visible in ArcGIS Pro 2.8.3 but not in ArcGIS Desktop 10.7.1

405
3
11-02-2021 01:12 AM
Labels (3)
bogdanpalade2
New Contributor III

I connect to an MS SQL server database where I only have read rights. Inside the database there is a point feature class that has several date fields.  The sql server management studio shows that the date fields are (date, null). I can see all the date fields in ArcGIS Pro 2.8.3 but not in ArcMap 10.7.1. The documentation both of ArcGIS pro and ArcMap says that they can read the same types of date field which is datetime2(n), datetime, smalldatetime. Why are the fields visible in ArcGIS Pro then? Am I missing something on the way?

0 Kudos
3 Replies
ABishop
MVP Regular Contributor

What version of SQL?

Amanda Bishop, GISP
0 Kudos
bogdanpalade2
New Contributor III

Microsoft SQL Azure (RTM) - 12.0.2000.8

0 Kudos
ABishop
MVP Regular Contributor

Do you have all the RDBMS clients installed for this version of SQL and Desktop?  Also, was the feature class created using ArcGIS Pro or desktop?

Amanda Bishop, GISP
0 Kudos