A Problem of shapefile

Topics: User Forum
Mar 23, 2007 at 3:20 AM
When I Import from shapefiles, I got an error.

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'UPDATE'.
System.Data.SqlClient.SqlException:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at Microsoft.SqlServer.Server.SmiEventSink_Default.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at MsSqlSpatial.GeometryTable.ExecuteCreate(SqlCommand command, String schemaName, String tableName, String columnName, String createColumns)
at StoredProcedures.ImportFromDatasource(IProvider datasource, String schemaName, String tableName, String columnName, Int32 srid, String type, String connectionString, ImportFromDatasourceProcess process, Int32& importedRows, TimeSpan& elapsedTime)
at StoredProcedures.ImportFromShapefileMain(String shapefile, String schemaname, String tablename, String column_name, Int32 srid, String type, String connectionString, Int32& importedRows, TimeSpan& elapsedTime)
at StoredProcedures.ImportFromShapefile(SqlString shapefile, SqlString schemaname, SqlString tablename, SqlString column_name, SqlInt32 srid, SqlString type)

How can I resovle this problem? Thanks!