• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 766
  • Last Modified:

XACT_E_NOTSUPPORTED

Hello Experts,

I just installed PostgreSQL ver 8.1. I created an OLEDB connection and transaction. The Transaction BEGIN goes off fine. However when I try to commit it, I get the following error:

'PostgreSQL.1' failed with no error message available, result code: XACT_E_NOTSUPPORTED(0x8004D00F).

I tried all the possible Isolation Levels in the OLEDB.BeginTransaction.

Help will be appreciated.
0
doraiswamy
Asked:
doraiswamy
  • 2
1 Solution
 
earth man2Commented:
have you issued a statement in the START TRANSACTION block that would self generate a commit eg DDL ?
0
 
doraiswamyAuthor Commented:
I am using VB in VS2005, the OleDB namespace, with the associated BeginTransaction, Rollback and Commit.
0
 
doraiswamyAuthor Commented:
I have solved the problem by using the custom OLE DB interface provided by PostgreSQL
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now