/r/firebird
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.
Firebird Database related news / blogs
For support questions please use firebird support mailing list https://groups.google.com/g/firebird-support
/r/firebird
I tried use the command connect data base, create data base, create user, connect user, but without solution, what can I do?
Since two days I have been trying to install FB3 on Linux Mint 22.
- There is almost no documentation available (at least none that I could find), no readme no nothing and that little bit I could find is hopelessly outdated or plain wrong.
- I am still not sure which variety and version (Apt Repo, deb or make) is more suitable resp. working.
- missing libs on the deb file - still did not find the proper version (again no doc!)
- Dealing with the proper chown chmod settings is simply try and error - again zero docs.
- cryptic error msg. on permission problems.
etc.etc. - I could write a book by now about this odyssey
This is a prime example of how a very good product goes down the drain due to lousy documentation.
I work with FB/IB since more than 20 years, mostly on Windows but after this experience I am seriously considering another DB.
If FB wants to increase its user base improving the documentation would be a first step in the right direction.
Greetings!
I have a bit of a Hail-Mary request for help. I don't think there's a solution based on the info I can give, but thank you for taking the time to read.
I am trying to migrate an old database of records. The original software included a FireBird 2.5 installer and FlameRobin allows me to access the database tables and structure and run SQL against the data. So far, so good. I can see 90%+ of the data.
It's the last 10% that I can't get. When I open the relevant table in FlameRobin, I can see the ID, ORDER, DATE, and other information but the "NAME" filed is blank. A "NAME" field is used in tables that track other information, and I can see those clearly. The "NAME" in this one table doesn't show up. When I view the file in a text editor, I can see the values as text.
I've checked other tables to see if the ID references it there instead, but there is nothing close. I've also tried a few other FireBird to CSV programs without luck. Are there any oddities to how a text field might be stored in Firebird? Is it possible that it's encoded in a way that still makes it visible in Notepad++?
I'm using Firebird-2.5.9.27139_0_Win32.exe as my Firebird installer since it was the closest version on the download page.
Anyway, thanks again for any suggestions.
Hi everyone,
I have a question. I need to use Firebird 2.5.9 32-bit, but I am a Linux user and want to know if it is possible to use Firebird 2.5.9 32-bit with Docker. I tried creating an image, but Firebird requires me to input a password manually. What should I do? Should I use Windows instead? What do you recommend?
I'm having this problem when trying to generate a backup from the command line, can you help me fix it?
estou tendo este problema ao tentar gerar um backup na linha de comando, podem me ajudar a corrigir ?
gbak: ERRO:comprimento do buffer do segmento menor que o esperado
gbak: ERRO: gds_$get_segment falhou
gbak: ERRO: Saindo antes da conclusão devido a erros
Command used:
Comando utilizado:
C:\Windows\System32>cd "C:\Fortes\Firebird\Firebird_2_5\bin"
C:\Fortes\Firebird\Firebird_2_5\bin>set ISC_USER=sysdba
C:\Fortes\Firebird\Firebird_2_5\bin>set ISC_PASSWORD=masterkey
C:\Fortes\Firebird\Firebird_2_5\bin>gfix -v -f -i "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb"
Summary of validation errors
Number of Blob page errors : 1
Number of database page errors : 2
C:\Fortes\Firebird\Firebird_2_5\bin>gfix -m -f -i "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb"
Summary of validation errors
Number of Blob page errors : 1
Number of database page errors : 2
C:\Fortes\Firebird\Firebird_2_5\bin>gbak -b -g -l -z -v "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb" "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fbk"
Hi, have this cliente with an application running on LAN which database is Firebird 2.5. No problem at all.
Then we bring up an Wireguard so he can stop using RDP. He liked the way it worked but the speed over the VPN is extremely slow. Everything else is fast over the VPN, if I copy a file it reaches above 100Mbps, and the application is running great at LAN.
The application support doenst help, they say the system wasnt developed to be used that way, but I'm spending time on my own to try to make it work for my client.
Can I do anything?
Hi guys,
We habe one server in our network which is running a software which provides data to us by using a firebird connection.
How can I setup the odbc connection from an other server to my fdb?
server:c$:path/database.fdb or
server:share:/database.fdb both did not work
What do i have to specify as Database in my odbc setup?
Hi,
I have a software which was using Firebird 2.5 for years and we had some python scripts doing analytics with the data stored in .fdb files.
However, about two months ago the software was updated to Firebird 4.0 and we haven't been able to connect using fdb or firebird-driver.
We are even considering using another language which works with Firebird 4.0 at this point.
Could anyone recommend us a language or a package for Python that works with version 4.0?
Thanks!
I'm a big fan of Firebird, and used it in many commercial applications. That's why it surprised me, when I discovered this today. 😬 Why does Firebird allow values greater than what the table schema allows?
For example, defining a column as numeric(5,2) or decimal(5,2) allows values like 1234.12
See this as a running example: https://dbfiddle.uk/czNoKM_v
Using dbfiddle, I can see other RDBMS don't allow that, and give a overflow error - which is what I would have expected from Firebird too, but doesn't.