BUG: CCommand::Open() Fails with SQL Server 7.0 and LARGE_INTEGER

ID: Q242522

The information in this article applies to:

Microsoft Data Access Components version 2.1 SP2
Microsoft OLE DB Provider for SQL Server, version 7.01

SYMPTOMS

While performing a CCommand::Open on a stored procedure with a LARGE_INTEGER as an input parameter, an ATL consumer receives an HRESULT of E_FAIL and the SQL Server crashes.

CAUSE

The ATL consumer converts a LARGE_INTEGER data type to an OLE DB DBTYPE_I8 data type. This data type is not supported as an input parameter to a SQL Server 7.0 stored procedure in the Microsoft OLE DB Provider for SQL Server (3.70.06.90) that ships with Microsoft Data Access Components (MDAC) 2.1 Service Pack 2 (SP2).

RESOLUTION

To work around this problem, use the DB_NUMERIC data type instead of a LARGE_INTEGER.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : kbOLEDB kbSQLServ kbGrpVCDB kbGrpMDAC kbDSupport kbMDAC210SP2bug kbMDAC250fix
Version : WINDOWS:2.1 SP2,7.01
Platform : WINDOWS
Issue type : kbbug