Underlying DBMS Error when Creating New Feature Class.

Question

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.

ApplusVelosi · Answer

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.

NeilAyres · Answer

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

JayantaPoddar · Answer

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.