CRecordset and SQL Server 2000

[SuperGeek]

Hey everyone!!! I've been getting VERY STUPID DB exception raised by ODBC driver while trying to call CRecordset::Open(....) function. The message says "Restricted data type attribute violation". Note that my data layer is SQL Server 2000. If there is a POOR one who has suffered thru the same, please share your grief with me. Big thanks ahead. Kirill.

[Lost User]

I've had the same error using SQL Server V7.0. It turned out that the order of the DoFieldExchange() member function of the recordset derived from CRecordset have to be in the same order as the table definition.