snide61

Converting GDB to SQL, drawing error

Discussion created by snide61 on Jul 25, 2011
Latest reply on Nov 27, 2011 by seikialice88
I'm working on converting the template gdb to our sql server.  I had no problem tranfering the schema and data via the XML conversion, but I do have a problem with the RoadCenterline layer in the template mxd.

The error I get is in the ArcMap Drawing Errors window:
"Underlying DBMS error [Micorsoft SQL Server Native Client 10.0:'CHAR_LENGTH' is not a recognized built-in function name.]
[-feature name-]

Any thoughts?  I've looked at the schema and all of the attributes for the RoadCenterlines layer and cannot find anything that says 'CHAR_LENGTH' anywhere.  I'm assuming it has to do with the difference between the File GDB and the SQL GDB.  The roads are still drawing and labeling, so I do not even know what is really going wrong with this error.

Thanks,
Scott

Outcomes