Skip to Content.
Sympa Menu

freetds - RE: Output parameters (was: Strange things)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Tankleff, Bruce" <Bruce.Tankleff AT hp.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: Output parameters (was: Strange things)
  • Date: Tue, 19 Nov 2002 07:31:50 -0600

>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

 




Archive powered by MHonArc 2.6.24.

Top of Page