'[freetds] sp_who in SQL Server 2000 leaves results pending.'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    [freetds] sp_who in SQL Server 2000 leaves results pending.
From:       "Tom Wakefield" <tom_wakefield () nacm ! com>
Date:       2003-01-30 18:30:03
[Download RAW message or body]

SQL Server version: MS SQL Server 2000

FreeTDS version: 0.60

Module:  tsql from Sun Solaris 2.8 sparc workstation

Tds version:  Sybase 12.5 (5.0), MS SQL Server 6.5 (4.2), MS SQL Server
7.0 (7.0) and MS SQL Server 2000 (8.0)

I can execute sp_who on Sybase 12.5, MS SQL Server 7.0 and MS SQL Server
6.5.  These executions return the result sets back to the interface, but
on 2000 I just sit at the 1> prompt and I am unable to perform any other
action w/exception of exiting due to results pending.

The execution of other store procedures appear to be fine on MS SQL
Server 2000.

[Attachment #3 (text/html)]

<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">

<style>
<!--
 /* 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:#606420;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink="#606420">

<div class=Section1>

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>SQL Server version: MS SQL Server 2000</span></font></p>

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>FreeTDS version: 0.60</span></font></p>

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Module:&nbsp; tsql from Sun Solaris 2.8 sparc
workstation</span></font></p>

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>Tds version:&nbsp; Sybase 12.5 (5.0), MS
SQL Server 6.5 (4.2), MS SQL Server 7.0 (7.0) and MS SQL Server 2000 (8.0)</span></font></p>

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

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>I can execute sp_who on Sybase 12.5, MS
SQL Server 7.0 and MS SQL Server 6.5.&nbsp; These executions return the result
sets back to the interface, but on 2000 I just sit at the 1&gt; prompt and I am
unable to perform any other action w/exception of exiting due to results
pending.</span></font></p>

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

<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'>The execution of other store procedures
appear to be fine on MS SQL Server 2000.</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

</div>

</body>

</html>

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

[prev in list] [next in list] [prev in thread] [next in thread] 