No subject


Fri May 2 19:13:14 EDT 2003


"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=3DKB;en-us;q244498)

=20

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



=20


------_=_NextPart_001_01C28FD0.042B9732
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Futura Md";
	panose-1:2 11 6 2 2 2 4 2 3 3;}
@font-face
	{font-family:"Futura Hv";
	panose-1:2 11 7 2 2 2 4 2 2 4;}
@font-face
	{font-family:"Lucida Console";
	panose-1:2 11 6 9 4 5 4 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:"Courier New";
	color:windowtext;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>&gt;There's a MS =
document
somewhere that says dblib under windows will only do </span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>&gt;TDS 4.2, a =
cursory (no
pun intended) look doesn't turn it up, but I </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>&gt;remember it pretty =
vividly.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>From the Microsoft Knowledge Base article =
#244498:</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Lucida Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida Console"'>&#8220;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&#8230;</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Lucida Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida Console"'>Due to a =
limitation in
the Tabular Data Stream (TDS) 4.2 specification, a maximum of 254 =
columns are
allowed in a cursor&#8230;</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Lucida Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida Console"'>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&#8230;&#8221;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>(complete text available at <a
href=3D"http://support.microsoft.com/default.aspx?scid=3DKB;en-us;q244498=
">http://support.microsoft.com/default.aspx?scid=3DKB;en-us;q244498</a>)<=
/span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'>&nbsp;</span></font></p>

<div>

<p class=3DMsoNormal><font size=3D2 face=3D"Futura Md"><span =
style=3D'font-size:10.0pt;
font-family:"Futura Md"'>Bruce A. Tankleff<br>
program manager<br>
scripting, tools, and automation<br>
personal systems group<br>
</span></font><em><b><i><font size=3D5 color=3Dteal face=3D"Futura =
Hv"><span
style=3D'font-size:18.0pt;font-family:"Futura =
Hv";color:teal;font-weight:bold'>hp</span></font></i></b></em><font
size=3D2 face=3D"Futura Md"><span =
style=3D'font-size:10.0pt;font-family:"Futura Md"'><br>
<br>
</span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C28FD0.042B9732--



More information about the FreeTDS mailing list