Underlying DBMS Error when Creating New Feature Class.

10-04-2016 12:22 AM
New Contributor


I am using ArcGIS 10.2 I am getting this error when i try to create a feature class for a table to be used in a layer.

Underlying DBMS Error [[Microsoft][SQL Server Native Client 11.0][SQL Server][Incorrect Syntax near '-'.]

I am using SQL Server 2012. Please let me know how to fix this issue.

Tags (1)
0 Kudos
3 Replies
MVP Esteemed Contributor

Make sure the native client is of same or higher version than the SQL Server (including the version of patch).

Also check if the listener is configured correctly.

Think Location
0 Kudos
MVP Frequent Contributor

And, what is the name of the Fc you are trying to create? Is the name valid for sql server?

0 Kudos
New Contributor

The problem was resolved by removing '-' from the DB name. We used to have same DB Name with previous versions of ArcMAP. Not sure why it does not allow hyphen in DB Name.