FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Murthy,

This error message is returned when you have issued some form of SQL
command or query and have not fully processed the results of that
command before issuing a second command.

The solution to this rather depends on waht you are trying to do.

If you are trying to do something like this (in pseudocode) :

select lots of rows from a table (1)
for (each row returned)
begin
   update a second table based upon the returned row (2)
end

Then you cannot perform operation (2) on the same connection as
operation (1). 
You need to open two connections to the database.
I don't know how this is done in sqlrelay. that would be your job to
find out.

If you're not trying to do something like this, then you have not
properly finished processing all the rows of a query, before submitting
a second query.

Again, I am not familiar with sqlrelay or its API's, so I can't tell you
how to *fully* process the results of a command.

Bill


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of knmurthy
Sent: 19 November 2004 15:27
To: FreeTDS Development Group
Subject: Re: [freetds] problem with sqlrelay


Hi ,freddy77
How can i open new connection?.
In sqlrelay we have specify number of  connection to open.
any script to check the connection opened and incress the connection.?
Murthy

ZIGLIO, Frediano, VF-IT wrote:

>>Hello All,
>>I am using freetds with SqlRelay.
>>when i try to execute any query i am getting error as
>>
>>
>>Client Library error:
>>        severity(78)
>>        layer(0)
>>        origin(0)
>>        number(51)
>>Error:  Attempt to initiate a new SQL Server operation with 
>>results pending.
>>
>>can any one help me on how to fix this.
>>
>>Thanks,
>>Murthy
>>
>>    
>>
>
>Get all data from previous query or open another connection
>
>freddy77
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>  
>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds 
--------------------------------------------------------
 
If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/ 
--------------------------------------------------------