Skip to Content.
Sympa Menu

freetds - Re: [freetds] Attempt to initiate a new Adaptive Server operation with results pending

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Attempt to initiate a new Adaptive Server operation with results pending
  • Date: Mon, 9 Feb 2015 14:42:23 +0000

2015-02-09 13:54 GMT+00:00 LacaK <lacak AT zoznam.sk>:
> Hi,
> I have program which uses FreeTDS db-lib.dll
> Now I have changed TDS version from 7.1 to 7.3 and I start receiving
> "Attempt to initiate a new Adaptive Server operation with results pending"
> in some places.
>
> For example, when I send this two commands:
> "IF @@TRANCOUNT>0 ROLLBACK"
> followed by:
> "BEGIN TRANSACTION"
>
> I get above mentioned error.
>
> I attach portion of logs for 7.1 and 7.3 version.
>
> As you can see in both cases is returned : more_results = 1 after "IF
> @@TRANCOUNT>0 ROLLBACK"
> (I do not understand why?)
>
> But in case 7.3 is error raised afterward (in 7.1 no error) Is it expected ?
> Can you give me some explanation what is going on ?
>
> Thanks
> -Laco.
> P.S. I resend this email to maillist, because first does not arrive there
> after 3 days
>


Yes, was still on stalled for moderation. Mmm... looks like tds 7.3
send transaction id back and dblib does not handle it at terminator
tokens. Can you send a small test. Don't think should be hard to fix.

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page