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.
LVL 8
doraiswamyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.