NIM059142 for No Product Found

Bug ID Number	NIM059142
Submitted	July 19, 2010
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	10.0
Version Fixed	N/A
Status	Fixed

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.