I am trying to connect to views in a SQL Server DB in Arcatalog / Arcmap. I am using the "Database Connections\Add Database Connection" method in catalog. I can connect fine but cannot see / preview data in catalog. It's not an SDE database, but another company DB.
I have a suspicion it’s a driver issue (http://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm) but I get lost about what to use and how to get these files / install them (32 bit or 64 bit etc.)
SQL specs: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor)
Arc specs: ArcgGIS 10.5.0.6491