Hi,
as suggested in another previous post, I downloaden and installed FlameRobin to execute sql statements direct on the database. However when creating a connection Flamerobin demands a user and pasword. The default SYSDBA witg masterkey do not work. On the old forum there is a manual on how to connect using dBeaver, but it states that user can be left blank. Flamerobin however always needs a user to make a connection?
Any suggestions on how to solve this?
Maybe artificial intelligence can help you, maybe you copy the post from the wayback machine, what it says, maybe it can help you find a solution. Specifically, I've been helping myself a lot with artificial intelligence lately and with great success I've already solved quite a few problems with python scripts to solve data transfer from imdb websites for my imdb scripts.
Quote from: sophis on 12 02 July, 2026, 12:39:04 PMFlamerobin however always needs a user to make a connection?
This shouldn't have to do anything with FlameRobin. Database itself asks for username and password. No db manager would allow you to connect to PVD's Firebird without it. So first you probably need to start Firebird server and then to connect to .pvd with:
QuoteUsername: SYSDBA
Default password: masterkey
This is the factory default for Firebird installations.
For the sake of other users, let us know what and how you did it eventually.
I never used FlameRobin before but I just tried it and it even oferred default username as SYSDBA when I tried to connect to PVD database, so I am confused with your post. You probably didn't start FireBurd server then, as I said. If it's not that, then I am out of ideas.
I tried Ivek's suggestion and used AI, but after several hours of trying every trick AI suggested, I could not solve the issue. I learned by now that, indeed it has nothing to do with user and password, but must be in the settings of the driver and having the correct dll's/drivers.
I don't understand what "You probably didn't start FireBird server" means. Do I need to have a firebird server? I just want to use some sql queries on the PVD database.
Quote from: sophis on 10 05 July, 2026, 10:03:54 AMDo I need to have a firebird server?
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/qsg3/firebird-3-quickstartguide.html
Quote from: sophis on 10 05 July, 2026, 10:03:54 AMI just want to use some sql queries on the PVD database.
Some, or all, you have to use FireBird server. When you finish, you can exit it.
If we would know your goal, maybe we could be of a better help. When I say "goal", I mean an answer to a statement: "I want to run some sql commands in order to..." what?
Problem solved (but with dBeaver)
First I dug up an old post from August, 2012 by user "dma" on the original forum.
Here is a kind of installation procedure (Windows oriented) for it to work with the PVD database
file.
- Download latest DBeaver version.
- Depack the DBeaver archive in a directory of your choice.
- Download latest JayBird JDBC connector (atm: "Jaybird-2.2.0JDK_1.6.zip") and FireBird
embedded mode libraries (atm: "Firebird-2.5.1.26351-0_Win32_embed.zip").
- Depack each of those archives into a subdirectory of the DBeaver directory, namely "jaybird/"
and "firebird/".
- Create a "launch.bat" commands file in the DBeaver directory with the following content :
Code: [Select]
@echo off
SET PATH=%PATH%;%~dp0\firebird\;%~dp0\jaybird\
START dbeaver.exe
- Launch this "launch.bat", you should have DBeaver running.
- Add a "New" > "Connection", select FireBird databse type, confirm. It should ask if you want to
download the FireBird JDBC Connector, press no.
- On the connection setting page, press "Edit Driver Settings".
- Change Sample URL to "jdbc:firebirdsql:embedded:{file}".
- On the "Libraries" tab, press "Add File" and go select "jaybird-full-2.2.0.jar" in the "jaybird/"
subdirectory.
- On the "Connection Properties" tab, add a new property "lc_ctype" with "UNICODE_FSS" value.
- Press "OK".
- Now click "Browse ..." to your PVD database on the "Path:" setting. You should then have
something like "jdbc:firebirdsql:embedded:d:\PVD\MOVIES.PVD" displayed in the "JDBC URL:"
field.
- Leave "User name:" and "Password:" fields empty.
- You can "Test Connection ..." which should display "Success / Connected (XX ms)".
- Press "Finish".
- Now click on the "unfold" icon on the left of the connection you just created in the "Database
Navigator" tab (don't enter any credential information).
- You can now access the database.
It didn't work with the latest Dbeaver version, so I downloaded Dbeaver 2.3.3 (x86 32-bit) and used Google to locate a copy of Jaybird-2.2.0JDK_1.6 and Firebird-2.5.1.26351-0_Win32_embed.
Then followed the above instructions and it worked like a charm. Now I can run SQL queries to select or update data on the pvd database.
I also downloaded and installed a 32-bit odbc driver (Firebird_ODBC_2.0.5.156_Win32) and now I can even access the pvd database with ODBC (I use this with QlikView (professional software but has a free personal edition) to create my personalized pvd-app for viewing only, eg. it can show my custom made fields).
Great. I just installed 2.5.1.x and no other quirks and connect with username and pass. Alaso connected with FlameRobin as I said. Just need to run that proper version of FirBird server.