Apache OpenOffice (AOO) Bugzilla – Issue 82577
ODBC is not working anymore 2.3.M5 +m232
Last modified: 2007-10-28 21:25:02 UTC
it looks the same as in issue 82076 and issue 81661: Try to use an established ODBC-connection from the ODB-Navigator-Window will crash OOO (this on 2.3RC3 (m5) aswell as on M232 - ooo stalls at 99% CPU Using the same connection from within the writer (exchange database) seems to work fine Using propriatary driver from OOO seems to work (that ODBC is essential and they can not be used for other reasons is another story) Martin
What do you mean with "establish an ODBC connection from the ODB Navigator Window"? What database type do you connect to? What database version / driver version do you use? What is the "proprietary driver from OOo"?
hello Frank This is all windows: - have a system-dsn with linking to a shared directory with dbIV-file via ODBC - open ooo - database - try new and to connect to that database via OOO-Odbc: crash Why do you ask for the version? Thats not important in here as far I can see propratary are the buildin dbms-drivers regarding DBaseIV I am not sure whether it had worked for 8-bit-decoding, but I trust ODBC more (you remember that problem) did I explained it well enough? Martin
OOo does not ship ODBC drivers for dBase, so if you're in fact using ODBC, then the driver versions might (or might not) make a difference. I'm always asking that when an issue is that underspecified :)
cannot reproduce with "Microsoft dBase driver (*.dbf)" 4.00.6305.00, on Windows XP service pack 2, in OpenOffice.org 2.3. Hmm.
Did you send a crash report, and received a report ID?
Hello Frank step back: It seems to be related to driver-versions it was: MDAC 2.8.0 + Jet4-SP8 As far as I know, the system-driver for DBAse-access is coming with the JET-Engine, which is in here from the W2K-SP4-Rollout 1 - that substitutes/overrules the Jet-Engine SP8 - Driverversions: 4.00.6200 The last version for access to the dbf-files through OBDC an was managed by the OBDC-Drivers from MDAC 2.8.0. That did not work I updated to the MDAC 2.8.0 SP1 dated 5/2005 (ProductBuild=2.81.1117.6) and now the ODBC-driver is of version 3.525.1117 - now is works. Frist tries gave weak performance - very slow - , but it worked, I have the right code-page wroking and I can manage to create query to multiple (dbase)-files. so, thanks from here. Maybe you need to circulate the infos for the need of this update rgds Martin
thanks for reporting back those details. Can we close this issue then?
yes and no as the compilation of ooo for windows2000 supports/requires a non-standard setup only you need to mark that down somewhere. However, it is up to you to close that issue, but doing so someone else might to re-check my findings Martin
closing