This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 470299 (SQL Server 8.0)
Microsoft distributes SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
When you use the SQLBulkOperations function or the SQLSetPos ODBC function to insert explicit values in a SQL Server IDENTITY column, the ODBC function may not run successfully, and you may receive the following error message:
DIAG  [Microsoft][ODBC SQL Server Driver][SQL Server]Explicit value must be specified for identity column in table 'new_employees' when IDENTITY_INSERT is set to ON. (545)
This problem occurs even when you set the IDENTITY_INSERT option to ON for the table that contains the IDENTITY column.
Even if the IDENTITY_INSERT option is set to ON, SQL Server incorrectly sends the status of the IDENTITY column as not updateable. Because the ODBC driver relies on the updateability status of the IDENTITY column, the ODBC driver assumes that the IDENTITY column is not updateable. Therefore, the ODBC driver skips the column when you use the SQLBulkOperations or the SQLSetPos ODBC function to insert explicit values in a SQL Server IDENTITY column.
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Microsoft SQL Server 2000 Developer Edition, Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2000 Enterprise Edition, Microsoft SQL Server 2000 Personal Edition, Microsoft SQL Server 2000, Workgroup Edition, Microsoft SQL Server 2000 Desktop Engine (Windows), Microsoft SQL Server 2000 Enterprise Edition 64-bit