Re: ODBC error

From: b55white <b55white(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)postgres(dot)rocks>, "Victor K(dot)" <ptahin(at)gmail(dot)com>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC error
Date: 2023-10-13 15:14:35
Message-ID: 81726013-177b-4251-913c-fe04583b056f@edison
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc



>
> On Oct 13, 2023 at 3:48 AM, Victor K. <ptahin(at)gmail(dot)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.
>
>
>
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Blade Freed 2023-10-20 20:31:53 Question - ODBC driver version vs. PostgreSQL version
Previous Message Pierre Couderc 2023-10-13 10:14:50 Re: 32 bit DLL's