Skip to Content.
Sympa Menu

freetds - [freetds] Any SQL statements throw exception "General error: 20019 Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7)"

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Михаил Гаврилов <mikhail.v.gavrilov AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Any SQL statements throw exception "General error: 20019 Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7)"
  • Date: Wed, 27 Apr 2011 19:54:05 +0600

Any SQL statements throw exception "General error: 20019 Attempt to
initiate a new Adaptive Server operation with results pending [20019]
(severity 7)" after execution procedure dbo.test2

CREATE TABLE dbo.test01 (
ttt int NOT NULL
)
GO


CREATE PROCEDURE dbo.test2
AS
set xact_abort on
BEGIN TRY
begin tran
insert into test01 (ttt) values (NULL) /* Here we make SQL error */
commit
END TRY
BEGIN CATCH
-- rollback
return -1 /* Here may be raiserror */
END CATCH
GO

Why?



--
Best Regards,
Mike Gavrilov.



  • [freetds] Any SQL statements throw exception "General error: 20019 Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7)", Михаил Гаврилов, 04/27/2011

Archive powered by MHonArc 2.6.24.

Top of Page