Re: ODBC error

From: Dave Cramer <davecramer(at)postgres(dot)rocks>
To: "Victor K(dot)" <ptahin(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC error
Date: 2023-10-12 13:42:33
Message-ID: CADK3HH+HoPCKjamYJeMQYDHhvSqRdEebR79SpRyKx3MHzJ4mEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin(at)gmail(dot)com> wrote:

> Hello team
> We have error when trying to get data from big table (about 7 GB) directly
> to pivot table in MS Excel 2016 Pro Plus x64 over 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

>

In response to

  • ODBC error at 2023-10-12 10:23:01 from Victor K.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kamil ADEM 2023-10-12 14:06:43 RE: 32 bit DLL's
Previous Message Dave Cramer 2023-10-12 13:17:28 32 bit DLL's