FreeTDS Development Group

["Tankleff, Bruce" <Bruce.Tankleff AT hp.com>]

>There's a MS document somewhere that says dblib under windows will only do

>TDS 4.2, a cursory (no pun intended) look doesn't turn it up, but I

>remember it pretty vividly.

 

From the Microsoft Knowledge Base article #244498:

“A DB-Library application generates an access violation (AV) when opening a server-side cursor by means of the dbcursoropen function on a Transact-SQL statement that returns more than 254 columns…

Due to a limitation in the Tabular Data Stream (TDS) 4.2 specification, a maximum of 254 columns are allowed in a cursor…

If you must open a server-side cursor on 255 or more columns, you must upgrade the application to use an API that can take advantage of the newer TDS 7.0 specification, which does not have this limitation. DB-Library will not be enhanced to support TDS 7.0 features…”

(complete text available at http://support.microsoft.com/default.aspx?scid=KB;en-us;q244498)

 

Bruce A. Tankleff
program manager
scripting, tools, and automation
personal systems group
hp