MS SQL 2008 crush after trunsaction commit

From: srr <safinroman(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: MS SQL 2008 crush after trunsaction commit
Date: 2014-09-19 09:03:14
Message-ID: 1411117394969-5819628.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello!

I have next configuration:

Win Serv 2008 r2 x64 standart
MS SQL 2008 x64
psqlodbc_09_03_0300-x64-1

when I run

set XACT_ABORT ON
begin tran
insert into OpenQuery(PG, 'SELECT * From test ' )
values (7)
commit tran

Ms sql crush:

SQL Server is terminating because of fatal exception c0000005. This error
may be caused by an unhandled Win32 or C++ exception, or by an access
violation encountered during exception handling. Check the SQL error log for
any related stack dumps or messages. This exception forces SQL Server to
shutdown. To recover from this error, restart the server (unless SQLAgent is
configured to auto restart).

If i use rollback tran or work without transaction it`s working well.

Thank you!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/MS-SQL-2008-crush-after-trunsaction-commit-tp5819628.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Bala krishna Devasani 2014-09-19 10:37:25 Problem in Re-using the prepared statement
Previous Message Philippe Champignon 2014-09-18 14:26:45 Cannot retrieve sequence number after an insert with OLE DB