Underlying DBMS Error when Creating New Feature Class.

2276
3
10-04-2016 12:22 AM
Highlighted
New Contributor

Hi,

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)
Reply
0 Kudos
3 Replies
Highlighted
Honored 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.

Reply
0 Kudos
Highlighted
MVP Frequent Contributor

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

Reply
0 Kudos
Highlighted
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.