Geodatabase - MSSQL upload issue

3049
10
11-13-2013 05:12 AM
HugoAhlenius
Occasional Contributor
Hi,

We recently upgraded desktop to ArcGIS 10.2, and now I am getting errors when trying to load data to our MSSQL 2005 geodatabase. This is a direct connection, we have retired ArcSDE that was previously running on that server.

The error I am getting is:

ERROR 000210: Canot create output
Underlying DBMS error [HY104:[Microsoft][SQL Server Native Client 10.0]Invalid precision value]
DBMS table not found
Failed to execute (FeatureClassToFeatureClass)

Any tips?
0 Kudos
10 Replies
George_Thompson
Esri Frequent Contributor

Hi Paul,

Are you referring to using ArcSDE service connections to connect to your geodatabase (either version 10.0 or 9.3.1) on SQL Server 2005? You can do it that way, the direct connections are the ones that have issues to SQL Server 2005 with a 10.0 or 9.3.1 geodatabase. But setting up an ArcSDE service connection at 10.2.x is all done manually now.

Using ArcSDE service connections @ 10.2

Creating an ArcSDE service @ 10.2

--- George T.
0 Kudos