Community

Underlying DBMS Error when Creating New Feature Class.

3486
3
10-04-2016 12:22 AM
ApplusVelosi
by
New Contributor
‎10-04-2016 12:22 AM

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)
0 Kudos
3 Replies
JayantaPoddar
by MVP Esteemed Contributor
MVP Esteemed Contributor
‎10-04-2016 02:42 AM

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
NeilAyres
by MVP Alum
MVP Alum
‎10-04-2016 06:02 AM

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

0 Kudos
ApplusVelosi
by
New Contributor
‎10-04-2016 10:58 PM

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.