public inbox for [email protected]help / color / mirror / Atom feed
ODBC error 4+ messages / 3 participants [nested] [flat]
* ODBC error @ 2023-10-12 10:23 Victor K. <[email protected]> 2023-10-12 13:42 ` Re: ODBC error Dave Cramer <[email protected]> 2023-10-13 15:14 ` Re: ODBC error b55white <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Victor K. @ 2023-10-12 10:23 UTC (permalink / raw) To: pgsql-odbc 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 Victor // (,'')> why? <( )' | | ,,_ _,, ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC error 2023-10-12 10:23 ODBC error Victor K. <[email protected]> @ 2023-10-12 13:42 ` Dave Cramer <[email protected]> 2023-10-12 14:14 ` Re: ODBC error Victor K. <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Dave Cramer @ 2023-10-12 13:42 UTC (permalink / raw) To: Victor K. <[email protected]>; +Cc: pgsql-odbc On Thu, 12 Oct 2023 at 09:33, Victor K. <[email protected]> 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 > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC error 2023-10-12 10:23 ODBC error Victor K. <[email protected]> 2023-10-12 13:42 ` Re: ODBC error Dave Cramer <[email protected]> @ 2023-10-12 14:14 ` Victor K. <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Victor K. @ 2023-10-12 14:14 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: pgsql-odbc On servers side logs could not receive data from client connection timed out // (,'')> why? <( )' | | ,,_ _,, чт, 12 окт. 2023 г. в 16:42, Dave Cramer <[email protected]>: > > > > > On Thu, 12 Oct 2023 at 09:33, Victor K. <[email protected]> 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 > >> ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ODBC error 2023-10-12 10:23 ODBC error Victor K. <[email protected]> @ 2023-10-13 15:14 ` b55white <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: b55white @ 2023-10-13 15:14 UTC (permalink / raw) To: Dave Cramer <[email protected]>; Victor K. <[email protected]>; +Cc: pgsql-odbc > > On Oct 13, 2023 at 3:48 AM, Victor K. <[email protected]> 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. > > > > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-10-13 15:14 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-10-12 10:23 ODBC error Victor K. <[email protected]> 2023-10-12 13:42 ` Dave Cramer <[email protected]> 2023-10-12 14:14 ` Victor K. <[email protected]> 2023-10-13 15:14 ` b55white <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox