datetime2 problems

875
1
02-14-2011 07:12 AM
MarkSmith1
Occasional Contributor
Hello,

I'm attempting to import an XML schema from a File Geodatabase (originally created in 9.3 but upgraded to 10) into a version 10 SDE Geodatabase (SQL Server 2008). The import keeps failing when it encounters DATE fields in a featureclass. The error says "invalid SQL syntax [Microsoft SQL Server Native Client 10.0: Incorrect synatax near 'DATETIME2'.].

Has anyone seen this error before?

Mark
0 Kudos
1 Reply
MarkSmith1
Occasional Contributor
I found the problem. It had nothing to do with the field type - the problematic field was named "End" which must be a reserved word in SQL. The error message was a little misleading 🙂
0 Kudos