Microsoft KB Archive/153847

{|
 * width="100%"|

BUG: ODBC Driver Misses ANSItoOEM with Server Cursors

 * }

Q153847

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
The Microsoft SQL Server ODBC Driver does not perform ANSItoOEM conversion successfully when using SQL Server server cursors.

WORKAROUND
Use a forward-only cursor with a rowset size of 1, which will have the driver not use server cursors.

MORE INFORMATION
SQL Server 6.0 introduced server cursors, which are used by the 2.5 versions of the Microsoft SQL Server ODBC Drivers to support ODBC static, keyset, and dynamic cursors. When an ODBC application connected to a SQL Server 6.0 running an OEM code page (such as code page 850) does a SQLSetStmtOption to set the SQL_CURSOR_TYPE to one which will use server cursors, the ANSItoOEM conversions will not be done for those result sets.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft SQL Server ODBC Driver version 2.50.0121. The problem does not occur in version 2.65.0201 of the driver.

Additional query words: SQLBindCol SQLSetPos

Keywords : kbBug

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600