masmith

datetime2 problems

Discussion created by masmith on Feb 14, 2011
Latest reply on Feb 14, 2011 by masmith
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

Attachments

Outcomes