Add Geometrytype Column to F_AttributeDefinition Table Created By FDO Prior To 3.2 (NEW)

FDO Provider for SQL Server

FDO Provider for SQL Server

Inserting a Feature With Incorrect Date Format Fails With FeatId=0

 

Add Geometrytype Column to F_AttributeDefinition Table Created By FDO Prior To 3.2 (NEW)

FDO 3.2 has added a column called ‘geometrytype’ to table F_AttributeDefinition. To use FDO 3.2 to access data stores created by previous versions of FDO, you must connect to the data store containing this table and run a sql script. You must have the dbcreator privilege to run this script. Do the following in a command window:

1. cmd> cd <MapInstallDir>/Fdo/bin/com
2. {SQL Server 2005} cmd> sqlcmd -UMyUserName -P MyPassword -S SQLServerHostName -d MyDatastore -i AlterSchemaSQLServer.sql
3. {SQL Server 2000} cmd> isql -UMyUserName -P MyPassword -S SQLServerHostName -d MyDatastore -i AlterSchemaSQLServer.sql