HSQL Database Manager Password

[Mickey12]

Hi
I am trying to connect to my dbase with HSQL Database Manager.
HSQL Database Manager requires a password in the connect box.
Is this a password for HSQL itself or a password for my dbase?
So my question is how/where do I set the required password that HSQL Database Manager is needing?

Thanks

[Villeroy]

I don't know HSQL database manager. I'm fairly sure that it requires a HSQLDB that is not embedded in a Base container.

[robleyd]

You haven't mentioned what back end database you are using; at a guess it would be the user/password combination required by the database access privileges which you presumably set up?

[Mickey12]

Perhaps this might help.
I have not set any passwords.

[Villeroy]

If this happens to be the database we discussed in April and you are talking about the manager which is shipped with HSQL2, then this might be the wrong forum. Like with any other SQL database, you can set up users and groups of users with access priviledges and passwords. The "master user" SA (system admin) has no password after you converted the database from embedded HSQL because embedded HSQL is just a single-user desktop database in a single file. It should be possible to connect the manager without providing a password for user SA.
The user HSQL guide includes a document accesscontrol-chapt.html

[Mickey12]

Hi Yes it is the database we discussed in April.
I get to here and not sure where to next.

[Villeroy]

Hi Yes it is the database we discussed in April.
I get to here and not sure where to next.

to do what?

Just click in the Command menu, say "SELECT" you get a skeleton of a SELECT statement and some help text below. It is just another console interface similar to Tools>SQL... in the Base window. This one is somewhat better but does not offer syntax highlighting (as far as I can see).

[Mickey12]

Thanks. No idea what to enter there. Sorry

[robleyd]

Time to learn about SQL as implemented by HSQL - try the HSQL documentation.

This is well outside the scope of OpenOffice.