Re: ODBC error - Mailing list pgsql-odbc

From Victor K.
Subject Re: ODBC error
Date
Msg-id CAGkTcbcT94D_Nuf22UiyyLGjDDZp8XSwE=607zB1Oo+anFzzqg@mail.gmail.com
Whole thread Raw
In response to Re: ODBC error  (Dave Cramer <davecramer@postgres.rocks>)
Responses Re: ODBC error
List pgsql-odbc

On servers side logs 
could not receive data from client connection timed out
 //
  (,'')> why?
<(   )'
   | |
,,_ _,,


чт, 12 окт. 2023 г. в 16:42, Dave Cramer <davecramer@postgres.rocks>:




On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin@gmail.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

pgsql-odbc by date:

Previous
From: Kamil ADEM
Date:
Subject: RE: 32 bit DLL's
Next
From: Jon Raiford
Date:
Subject: Re: 32 bit DLL's