Hi everyone. i’m having a problem with a ODB file.
I’ve set a password trough the tool SQL… using the command “SET PASSWORD”, I remember my password, and altered the “content.xml” file to request the password. Problem is that the “user name” was never set. Is there a defaul username?
Which database do you use? Internal HSQLDB has user name “SA” bei default. For Firebird it is “sysdba”.
I believe it is HSQLBD, but neither “SA” nor “sysdba” worked.
I’m on Linux by way, I don’t know if that matters.
Thank you for the reply.
Have a look at the bottom of the Base window. There should appear “Embedded HSQLDB”. You have already opend zhe *.odb-file. So you could also open (inside the file) folder database/script. The user name and the password will be saved in this file, if it is a internal HSQLDB. And, as you could see there also, the password protection you will get is very simple…
This is getting weird, thanks to you I just opened the script, I can see the user “SA” and the password. I still can not access the file, I just literally copied n pasted them and “Access Denied”.
IMHO, this never worked with embedded HSQL. If you want your database safer, faster and with more features, you should convert your embedded HSQL (version 1.8 of 2006) into an external HSQLDB (version 2.4.3 or higher). An external database can have users and groups among other things. You may also use it on a server with simultanious multi-user access.
Version 2.4.3 was the last version which could convert HSQL 1.8 on the fly, 2.7.2 is the latest version.
Here you find a macro which will extract and/or convert your database easily: [Python] Macro to extract and reconnect embedded HSQLDB
I’m using a computer on my work, so i can’t change any softwares. I guess I’ll have to redo the file, I have a backup from before setting the password. it’s only one day of work between them. But thank you all for the support.
@RobertG
You do not have to install any software.
Copy your Base document into a dedicated directory.
Create a subdirectory “driver”.
Download HSQL. It’s a zip archive.
Extract the file /hsqldb-2.4.1/hsqldb/lib/hsqldb.jar from the archive to the “driver” subdirectory.
Install my macro.
Now open the Base document in the database directory and run my macro.
If you are not even allowed to install macros, you can still do the trick manually within a few minutes.
Well, hsqldb.jar file is still a Java library, but you only need that single library instead of the hsqldb.jar that is shipped with LIbreOffice.