ArcCatalog 10.8.2

[BrianFoley1]

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

[BrianFoley1]

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.

[Robert_LeClair]

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.