DB-Library (Level 2)

Installing SQL Server

previous page next page

Installing SQL Server

DB-Library (Level 2)

SQL Server 6.x	SQL Server 2000
When connected to a version 6.x SQL Server, a call to dbcursorfetchex resulting in a cursor position after the end of the cursor result set returned: FAIL, with either a keyset or an insensitive cursor. SUCCEED, with all row status indicators set to 0, with either a dynamic or forward cursor.	A call to dbcursorfetchex resulting in a cursor position after the end of the cursor result set returns SUCCEED. All row status indicators are set to 0. This behavior applies to all types of cursors. Expect different results as compared to earlier versions of SQL Server. Expect different results, compared to SQL Server 6.x, when a call to dbcursorfetchex results in a cursor position after the end of the cursor result set. To achieve SQL Server 6.x behavior, use compatibility level 65.

SQL Server 6.x

SQL Server 2000

When connected to a version 6.x SQL Server, a call to dbcursorfetchex resulting in a cursor position after the end of the cursor result set returned:

FAIL, with either a keyset or an insensitive cursor.
SUCCEED, with all row status indicators set to 0, with either a dynamic or forward cursor.

A call to dbcursorfetchex resulting in a cursor position after the end of the cursor result set returns SUCCEED. All row status indicators are set to 0. This behavior applies to all types of cursors.

Expect different results as compared to earlier versions of SQL Server. Expect different results, compared to SQL Server 6.x, when a call to dbcursorfetchex results in a cursor position after the end of the cursor result set. To achieve SQL Server 6.x behavior, use compatibility level 65.

previous page start next page