Re: ODBC error - Mailing list pgsql-odbc

From b55white
Subject Re: ODBC error
Date
Msg-id 81726013-177b-4251-913c-fe04583b056f@edison
Whole thread Raw
In response to Re: ODBC error  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-odbc
On Oct 13, 2023 at 3:48 AM, Victor K. <ptahin@gmail.com> wrote:
ODBC driver x64
Postrge on linux ver 15
ODBC psqlodbc_16_00_0000-x64
Error
OLE DB or ODBC error. An error occurred while processing table 'Query'. The current operation was cancelled because another operation in the transaction failed.
and 
The commit or rollback request cannot be completed because there is no active transaction in this session.
On small tables everything is okay

I would suggest looking at the server logs. 
Dave Cramer
www.postgres.rocks
On servers side logs 
could not receive data from client connection timed out
 //
  (,'')> why?
<(   )'
   | |
,,_ _,,

Client side logs would probably be useful.
Turm on through the DSN settings. 
Unless you specify a directory, they'll be in the users home dir.
Remember to shut them off when finished as they gobble space quickly. 

Brad. 

pgsql-odbc by date:

Previous
From: Pierre Couderc
Date:
Subject: Re: 32 bit DLL's
Next
From: Blade Freed
Date:
Subject: Question - ODBC driver version vs. PostgreSQL version