[Libreoffice-bugs] [Bug 122779] FILEOPEN (BASE) Connection to Oracle DB via ODBC ends in [ODBC][ORACLE] Optional Feature not implemented

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122779

--- Comment #16 from Thierry Menigoz <thierry.menigoz at ptp-industry.com> ---
>From my experience, the 32-bit driver works again with the 32-bit LibO since
release of 6.3.
The point is that, when extracting a big amount of data (i.e. more that 10000
lines or so), LibO 6.3 or 6.4 in 32-bit installed on my Win10 64-bit OS crashes
when saving the files including these extractions making them virtually
unusable.
As it is very difficult (impossible?) to get both 32-bit and 64-bit Oracle
drivers working on the same machine (and our ERP system is designed to work
exclusively with the 32-bit Oracle Driver), I then cannot got for a full 64-bit
solution.

My current work around is to use a parallel install of LibO 6.1 in 32-bit that
allows me to save the file after extraction (a bit slow to save the files but,
well, it works) and then re-open the file with LibO 6.4 64-bit that allows me
to do the calculations and Pivot Tables as the 64-bit does not crash when
saving these big files (and is also quicker than the 32-bit edition).

For the crashes in saving big Calc files with 32-bit version, I have never been
able to identify the reason. The file closes without any message, WinDebug
installed and used as detailed in the WiKi, gives no backtrace and when tracing
the use of memory and CPU's, nothing looks wrong. Usually, the progress bar
goes quickly to around 90% of progress and then very slowly before everything
collapsed before the last percents of the bar were reached. I did fresh
reinstall, delete my profile, tried to adjust memory parameters, tried to close
all other applications to free up all capacities but all were, until now,
unsuccessful.
In my tests, I also tried with a file only with extracted data and no other
calculation or spreadsheet but he results the same. I just noticed that the
status bar message shown seems always the same : "calculating cells height ..."
I never found a way to disable this "cells height adjustement" and therefore
have not been able to confirm if this is the reason for the crash.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200422/2292216c/attachment.htm>