I try the connection between Firebird and LO-Base through ODBC. When I try to edit any existing table or try to start the wizard for editing a table LO will shutdown immediately. System and ODBC-settings see https://bugs.freedesktop.org/show_bug.cgi?id=67144.
Hi, I use Firebird databases with ODBC driver since many versions of LO and i never had this problem. Actually my version of LO is 4.1.4.1 ans I have no problem. Bernard Ribot
(In reply to comment #1) > Hi, > > I use Firebird databases with ODBC driver since many versions of LO and i > never had this problem. > > Actually my version of LO is 4.1.4.1 ans I have no problem. Hello Bernhard, could you please have a look at the ODBC-settings, reported in https://bugs.freedesktop.org/show_bug.cgi?id=67144 ? Could be that there are parameters in your settings that must be added to work here for me, too. Regards Robert
Hi Robert, I forgot to say that my PC is under Windows 7. However that is my configuration, if it can help you : odbcinst.ini : [ODBC 32 bit Drivers] Firebird/InterBase(r) driver (32 bit)=Installed [Firebird/InterBase(r) driver (32 bit)] Driver=C:\Windows\system32\OdbcFb.dll Setup=C:\Windows\system32\OdbcFb.dll 32Bit=1 odbc.ini : [ODBC 32 bit Data Sources] fb_logiciels=Firebird/InterBase(r) driver (32 bit) fb_bd1test=Firebird/InterBase(r) driver (32 bit) [fb_logiciels] Driver32=C:\Windows\system32\OdbcFb.dll [fb_bd1test] Driver32=C:\Windows\system32\OdbcFb.dll Regards, Bernard
Robert: I haven't tried yet to reproduce but: 1) do you reproduce this on last stable LO version? 2) I think you're on OpenSuse, do you use OpenSuse 13.2 (see this comment https://bugs.freedesktop.org/show_bug.cgi?id=65830#c37)? Finally, I just learnt about different Firebird versions: - classic/super classic - superserver which version do you use?
(In reply to Julien Nabet from comment #4) > Robert: I haven't tried yet to reproduce but: > 1) do you reproduce this on last stable LO version? Have just tested with LO 4.3.5.2 on OpenSUSE 12.3. If I want to create a table with Firebird and ODBC LO crashes immediately. The tables I created were created by the JDBC-connection. I could connect to the database, could see the content of the tables but could not create new tables, edit tables or put any integer-value in a table. > 2) I think you're on OpenSuse, do you use OpenSuse 13.2 (see this comment > https://bugs.freedesktop.org/show_bug.cgi?id=65830#c37)? No, I'm using OpenSUSE 12.3. I will see if I could test this with my little netbook and OpenSUSE 13.2 - haven't installed this version yet. > > Finally, I just learnt about different Firebird versions: > - classic/super classic > - superserver > which version do you use? Have had a look. There is installed the classic and the normal server-version. I have installed it only for testing for the Base-Handbook. So I don't know much about the different versions. The installed version is firebird-2.5.4.26821-85.1. ODBC-version is 2.2.12-219.1.1
Thank you Robert for your feedback. I installed Firebird 2.5 classic, created a database with Flamerobin. Now I'm stucked because there's no odbc Firebird lib on Debian. Indeed, I tried to install OdbcFb-LIB-2.0.3.154.amd64.gz, but gunzip indicates it's not gzip format. There are also sources but seems not very user friendly to install... Anyway, since I don't have more questions, I put it back to UNCONFIRMED.
Adding Lionel to CC @Lionel : could it be that bug 34432 has reared its ugly head again ?
(In reply to Julien Nabet from comment #6) Hi Julien, > Now I'm stucked because there's no odbc Firebird lib on Debian. > Indeed, I tried to install OdbcFb-LIB-2.0.3.154.amd64.gz, but gunzip > indicates it's not gzip format. > There are also sources but seems not very user friendly to install... > On my Linux Mint 17 (Ubuntu 14.04) system, the gz unzips to a folder which contains a tar which untars to the libOdbcFB.so shared object library. On my system, I copied this into /usr/lib/x86_64-linux-gnu/odbc/, which is where all the 64bit drivers are stored. However, there seems to be something wrong with the library as I don't seem to be able to get it to load properly. I might try building it from source to see if the results differ.
@Robert : my initial reading of your submission was that you couldn't edit data in the tables, but I think that what you are actually saying is that you can't edit the table definition ?
BTW, I can connect from LO to the sample employee database provided with Firebird 2.5 using the 64bit driver downloaded from the Firebird website.
CONFIRMING crash with LO Version: 4.3.5.2 Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5 As soon as I select a table, and choose Edit from the context menu, LO aborts.
Steps to reproduce : 1) 64bit version of LibreOffice 2) 64bit version of the Firebird ODBC driver 3) Create an odbcinst.ini entry for the driver - this is dependent on your OS 4) Create an odbc.ini entry for a datasource - Firebird 2.5 supplies an employee.fdb sample database for testing purposes. 5) Setup a ODB file which connects to the employee.fdb file via ODBC (e.g. using the db creation wizard) 6) Open ODB file. 7) Select a table with the mouse from the list of available tables 8) Right mouse button click on the table entry to bring up the context menu, then choose "Edit" 9) LO aborts. What should happen : LO should open the table definition for editing.
I don't have a debug build on Linux to hand to obtain a backtrace, so that will have to wait or be done by someone else.
(In reply to Alex Thurgood from comment #9) > @Robert : my initial reading of your submission was that you couldn't edit > data in the tables, but I think that what you are actually saying is that > you can't edit the table definition ? Only creating a table by the GUI or changing a table by the GUI produces a crash. I could put data into tables (if there isn't an integer-value as primary-key). But notice: I could create a table through Tools → SQL. I could input all data through Tools → SQL. Try this with Firebird - ODBC: CREATE TABLE "Test" ("ID" INT PRIMARY KEY, "Text" VARCHAR(50)); INSERT INTO "Tabelle" ("ID","Text") VALUES (1,'Nobody'); Works well, refreshing the table-view and the table is shown.
Alex: I still fail to gunzip odbc driver, OdbcFb-LIB-2.0.3.154.amd64.gz, from here: http://www.firebirdsql.org/en/odbc-driver/ Would it be possible you attach the so file so I may give it a try?
Created attachment 111475 [details] libOdbcFb.so 2.0.3.154 64bit I have tried to unzip the file. Doesn't work in the packing-module for XFCE, but does work with ARK (KDE).
Thank you Robert for the so file. I copied it in /usr/lib/x86_64-linux-gnu/odbc/ Badfully I've got only "datasource name not found" whereas I've created a firebird file with flamerobin in /tmp (because flamerobin uses the user "firebird") and put this in ~.odbc.ini: [fdo67145] Description = Firebird Driver = Firebird Dbname = localhost:/tmp/testfirebird User = SYSDBA Password = 7c9fa145 Role = CharacterSet = ReadOnly = No NoWait = No I noticed only this console log: warn:legacy.osl:3273:1:connectivity/source/drivers/odbc/OConnection.cxx:75: Failure from SQLDisconnect I'm stuck again :-(
Here's the detailed error message in popup: SQL Status: IM002 [unixODBC][Driver Manager]Data source name not found, and no default driver specified
Hi Julien, have a look here for a working connection (works only for input values or through Tools → SQL): https://bugs.freedesktop.org/show_bug.cgi?id=67144#c0 I haven't the same system as you, but have copied the lobOdbcFb.so to /usr/lib and also to /usr/lib64. The driverpath could also be found in the odbcinst.ini. Don't use the same connection as Flamerobin ...
(In reply to robert from comment #19) ... > The driverpath could also be found in the odbcinst.ini. > Don't use the same connection as Flamerobin ... I don't understand what you mean. Flamerobin allows me to create a database file. If I don't use SYSDBA, what should I use?
(In reply to Julien Nabet from comment #20) > (In reply to robert from comment #19) > ... > > The driverpath could also be found in the odbcinst.ini. > > Don't use the same connection as Flamerobin ... > I don't understand what you mean. Flamerobin allows me to create a database > file. If I don't use SYSDBA, what should I use? Have never used Flamerobin. The only time I created a Firebird-database was the testdatabase for Base-Handbook. So I created the dabase by isql-fb. I thought the connection in your odbc.ini was created by Flamerobin ... The Name of the Driver is in Squarebrackets: [Firebird] This is odbcinst.ini. Only Driver64 is needed ... [Firebird] Description = Firebird ODBC driver Driver64 = /usr/lib64/libOdbcFb.so Your Driver64 might be Driver 64 = /usr/lib/x86_64-linux-gnu/odbc/libOdbcFb.so Here the odbc.ini for the connection. Driver, Dbname and SensitiveIdentifier is needed, nothing else [Firebird-libretest] Description = Firebird database libreoffice test Driver = Firebird Dbname = localhost:libretest.fdb SensitiveIdentifier = Yes Your Dbname seems to be wrong: Dbname = localhost:/tmp/testfirebird isn't it Dbname = localhost:/tmp/testfirebird.fdb ? Regards Robert
I had overlooked this part, thank you Robert! Now I'm able to test :-)
Created attachment 111491 [details] bt with debug symbols On pc Debian x86-64 with master sources updated today, I could reproduce the crash.
Lionel: I noticed this line in bt: #11 0x00002aaad160def4 in dbaui::fillTypeInfo (_rxConnection=uno::Reference to (dbaccess::OSharedConnection *) 0x2e34b80, _rsTypeNames="bMLmr||Unknown;Text;Number;Date/Time;Date;Time;Yes/No;Currency;Memo;Counter;Image;Text (fix);Decimal;Binary (fix);Binary;BigInt;Double;Float;Real;Integer;Small Integer;Tiny Integer;SQL Null;Object;Dis"..., _rTypeInfoMap=std::__debug::multimap with 0 elements, _rTypeInfoIters=std::__debug::vector of length 0, capacity 0) at /home/julien/compile-libreoffice/libreoffice/dbaccess/source/ui/misc/UITools.cxx:435 So if LO tries to load all the types, including Integer, it may be another dup of fdo#45881, what do you think? Also, Firebird proposes their odbc-jdbc source here: http://www.firebirdsql.org/en/odbc-driver/ have you got any contact with a Firebird's dev or would it be interesting someone contact them by referring https://bugs.freedesktop.org/show_bug.cgi?id=45881#c2 ?
Adding self to CC if not already on
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT: - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
(In reply to ribotb from comment #1) > Hi, > > I use Firebird databases with ODBC driver since many versions of LO and i > never had this problem. > > Actually my version of LO is 4.1.4.1 ans I have no problem. > > Still OK with : Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; Locale : fr-FR (fr_FR) on Win7/x86 Firebird Database Server 2.5.3.26780 Bernard
Just for information, there's 2.0.4 version (see http://firebirdsql.org/en/odbc-driver/)
Have tried this one again with version 2.0.4.155 64bit from Firebird ODBC. It's a little bit tricky to get it work with LO, but the buggy behavior is the same. I could create a table through Tools → SQL. I could input all data through Tools → SQL. Try this with Firebird - ODBC: CREATE TABLE "Test" ("ID" INT PRIMARY KEY, "Text" VARCHAR(50)); INSERT INTO "Test" ("ID","Text") VALUES (1,'Nobody'); If I try to create a table through GUI, LO crashes immediately. If I try to input new values, any value for "ID" seems to be wrong. There seems to be inserted NULL instead of an Integer. I could only use Tools → SQL for input new values for "ID". But this is another bug. I have tested with LO 5.2.2.2 and OpenSUSE 42.1 64bit rpm Linux, and also with Version: 5.3.0.0.alpha0+ Build ID: e7324c5705eaa38a2c9aa0636f01a73f033ba4d6 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-10-20_06:12:58 Locale: de-DE (de_DE.UTF-8); Calc: group
Comment on attachment 111491 [details] bt with debug symbols This bt is too old to be useful. Badfully re-reading all this several months later, I don't remember how to reproduce this.
Ubuntu 14.04.5 LO5.3.3.2 2 weeks ago: ThinkPad T410; Starting Writer: comes up en goes down everything tried; system Ubuntu 14.4 reinstall; apt LO5.3.3.2 reinstall; perfect 1 week ago: BioStar; Starting Writer: comes up en goes down everything tried; system Ubuntu 14.4 reinstall; apt LO5.3.3.2 reinstall; perfect now: ThinkPad T410: starting Base; attempt start Table New; ABORT; reinstall Base; starting Base; attempt start Table New; ABORT Some aborts generates an crash-report to ??? Do I have another time reinstall my ThinkPad T410? It costs five hours waiting... My two other PC´s, not so much used, are running smoothless at the same DropBox.
Ubuntu 14.04.5 LibreOffice 5.3.3.2 ThinkPad T410 Starting Base Base opens Load xxx.odb xxx.odb opens Click Tables Base closes immediately without message Tried: rename ~/.config/libreoffice/4/user > user-old restart PC no good results for Base: same error repeats
Please don't set version to the newest version. There is marked: earliest affected version!
> Ik heb het Crash-report gelezen, maar het is niet LO die ABEND maar Ubuntu > 14 die ABORT, op het lezen van een onbestaand mem-address.
Each opening of a Base.odb gives a damaged .odb file. Next approach repairs and by opening it is damaged again. And so on...
(In reply to DickStomp from comment #35) > Each opening of a Base.odb gives a damaged .odb file. > Next approach repairs and by opening it is damaged again. > And so on... Please check that you've not been hit by the jvmfwk / kernel bug in Ubuntu-based distributions which affects kernel version 4.4.0.81.
(In reply to Alex Thurgood from comment #36) > > Please check that you've not been hit by the jvmfwk / kernel bug in > Ubuntu-based distributions which affects kernel version 4.4.0.81. https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772
(In reply to DickStomp from comment #35) > Each opening of a Base.odb gives a damaged .odb file. > Next approach repairs and by opening it is damaged again. > And so on... @Dick What has this got to do with ODBC and Firebird ? Please be more precise in adding your comments - just saying vaguely that any old random ODB crashes when you try to load it is not what this bug report is about - it is about whether using the 64bit Firebird ODBC driver library causes a Firebird 2.5 ODB (although possibly also a Firebird3 database from comment 29) file to crash LibreOffice...
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Would it be possible to attach a simple fdb file so it helps to reproduce this more easily? Indeed, I remember having installed a lot of stuff about Firebird and it was still clumsy.
@Julien: Seems that you can get the sample Employee.fdb file with any of the following : https://pkgs.org/download/firebird3.0-examples https://ubuntu.pkgs.org/18.04/ubuntu-universe-amd64/firebird3.0-examples_3.0.2.32703.ds4-11ubuntu2_all.deb.html
@Julien : unfortunately, if you you are running Debian, it looks like you have to install the server package...
(In reply to Alex Thurgood from comment #42) > @Julien : unfortunately, if you you are running Debian, it looks like you > have to install the server package... Thank you for your feedback. I installed firebird3.0-server and firebird3.0-examples this last one seems to install nothing but finally found an fdb file here: /home/julien/lo/libreoffice/workdir/UnpackedTarball/firebird/gen/examples/employee.fdb Since there's no odbc firebird package in Debian repo, I suppose I must download it from Firebird website then must create an ~/.odbcinst file. lib odbc64 from https://firebirdsql.org/en/odbc-driver/ has some pb: "A lone zero block at 2254" and when I downloaded sources, there's nothing about building (or missed it).
I finally built the sources by: - renaming makefile.linux to makefile in Builds/Gcc.lin/ from sources. - fixed in makefile.environ path of libfbclient.so for FBLIBDIR - fixed in SetupAttributes.h BUILD_DRIVER_VERSION #define BUILD_DRIVER_VERSION(major,minor,buildnum) major"."minor"."buildnum to #define BUILD_DRIVER_VERSION(major,minor,buildnum) major "." minor "." buildnum + retrieved ./Builds/Gcc.lin/Release_x86_64/libOdbcFb.so and place it in a directory then I created an ~/.odbcinst.ini with: [ODBC Drivers] FireBird = installed [Firebird] Driver = /home/julien/lo/bugs/Firebird_odbc_205/libOdbcFb.so + created an ~/.odbc.ini [bug_67145] Description = Firebird Driver=Firebird Dbname=127.0.0.1/3050:/home/julien/lo/libreoffice/workdir/UnpackedTarball/firebird/gen/examples/employee.fdb User=SYSDBA Password=julien Role= CharacterSet= ReadOnly=No NoWait=No I also had to change /etc/firebird/3.0/firebird.conf to replace: RemoteBindAddress = localhost by RemoteBindAddress = 127.0.0.1 + restarted service (ipv6 pb?) Finally, I could create a table with wizard. (created "Tasks" with every default options selected). But everything is readonly whereas I put "No" to ReadOnly. So I can't change the structure of a table or put some data.
(In reply to Julien Nabet from comment #44) > > + created an ~/.odbc.ini > [bug_67145] > Description = Firebird > Driver=Firebird > Dbname=127.0.0.1/3050:/home/julien/lo/libreoffice/workdir/UnpackedTarball/ > firebird/gen/examples/employee.fdb > User=SYSDBA > Password=julien > Role= > CharacterSet= > ReadOnly=No > NoWait=No > > Finally, I could create a table with wizard. (created "Tasks" with every > default options selected). > But everything is readonly whereas I put "No" to ReadOnly. > So I can't change the structure of a table or put some data. You have to add to odbc.ini: SensitiveIdentifier = Yes to input values into the tables. You didn't test it with a "normal" LO-version, or did I understand it wrong way?
Created attachment 157760 [details] gdb backtrace full I have collected a backtrace from commit 1d7b1a15, configured: CCFLAGS=-Wshadow --with-jdk-home=/usr/lib/jvm/default-java --enable-split-debug --enable-gdb-index --enable-ld=gold --enable-option-checking=fatal --enable-dbgutil --enable-debug --without-system-postgresql --without-myspell-dicts --with-extra-buildid --without-doxygen --with-external-tar=/home/terry/lo_hacking/git/src --without-package-format built and running on debian-buster. My .odb has an ODBC connection to a copy of employee.fdb received with Firebird within LibreOffice. The segmentation fault happened as soon as I tried to right-click > Edit the first table. I am removing keyword wantBacktrace and adding haveBacktrace.
On pc Debian x86-64 with master sources updated today, I gave a new try. This time, I added SensitiveIdentifier = Yes on odbc.ini I could add a new column in COUNTRY table. I could also created a table with wizard with by default values.
Dear Robert Großkopf, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Problem is still the same in LO 7.3.3.2 on OpenSUSE 15.3. LO crashes immediately if I try to edit a table (not input data) with Firebird and ODBC connection.
Tried to get a connection to Firebird via ODBC on a current Linux system. Seems the connector provided by Firebird is too old (released in 2017, no update since 7 years). Don't know if we should try to support such a driver. Direct connection works with Firebird 3, other connections will work with JDBC.
Created attachment 197497 [details] libOdbcFb.so built from github On pc Debian x86-64 with master sources updated today, I don't reproduce the crash when editing a table or creating a table with wizard. I put libOdbcFb.so built in /home/julien/lo/bugs/Firebird_odbc_205/ I installed firebird3.0-server and firebird-dev (this last one was to have libfbclient.so). Here's the content of .odbcinst.ini: [ODBC Drivers] FireBird = installed [Firebird] Description = InterBase/Firebird ODBC Driver Driver = /home/julien/lo/bugs/Firebird_odbc_205/libOdbcFb.so Setup = /usr/lib/libOdbcFb.so Threading = 1 FileUsage = 1 CPTimeout = CPReuse = the content of .odbc.ini [bug_67145] Description = Firebird Driver=Firebird Dbname=127.0.0.1/3050:/home/julien/lo/libreoffice/workdir/UnpackedTarball/firebird/gen/examples/employee.fdb SensitiveIdentifier = Yes User=SYSDBA Password=masterkey Role= CharacterSet= ReadOnly=No NoWait=No Could someone else can give it a new try with recent LO and recent FB ODBC driver ? I mean perhaps I missed something.
@Julien: Thanks for the test. Retested it again with the new driver → directly downloaded as version ODBC3 (4,3 MB; created 2024-09-04) from https://github.com/FirebirdSQL/firebird-odbc-driver/releases/tag/v3-0-0-release Much bigger than the old for Firebird 2 (1,1 MB). No problem to get connected, no problem to create a table, open a table and write content into table. Also tried to edit this existing table - no problem. Tested with Version: 24.8.3.1 (X86_64) / LibreOffice Community Build ID: 65412f067af443213e726c93f137ccc85c9a1e06 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded I will close this bug as WORKSFORME.