English

Bug: Date fields created in SQL Server 2008 9.3.x geodatabases by ArcGIS 10 clients using Direct Connect are inaccessible by pre-ArcGIS 10 clients

Description

When an ArcGIS 10 client using a direct connection creates data in an ArcSDE 9.3.x geodatabase running on Microsoft SQL Server 2008, date fields are created using the datetime2 data type instead of datetime.

ArcGIS clients prior to version 10 are unable to see or update datetime2 fields.

Cause

The datetime2 data type is new in SQL Server 2008. It is only supported with ArcGIS 10.

ArcGIS 10 clients using a direct connection to older geodatabases in SQL Server 2008 are erroneously creating date fields using the datetime2 data type.

Workaround

This only occurs when ArcGIS 10 clients use Direct Connect to create data in 9.3.x geodatabases. Connections made using the Application Server create date fields correctly using datetime.

This problem is resolved in ArcGIS 10 SP1.

    Related Information