Thanks. Maybe you could add me those privileges again through the console? In case you need help, of course.

Quote from: afrocuban on  8 14 July, 2026, 08:32:39 PMHello. I have no access to admin console anymore.

Strange, because I can still see and access the admin console.

Hello. I have no access to admin console anymore.

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.

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).

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?

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.

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.
 

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.

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.