[Squirrel-sql-users] Attaching to database with URL

[<sun...@us...>]

I have installed the drivers for Firebird and then look to add an alias
for the required database. However when I try to do a test connection I
get an error message, "CF: Problem getting connection: could not get a
db connection" or get the error message "CF:Unable to create connection.
Check your URL"

The syntax presented for Firebird is:
jdbc:firebirdsql:[//host[:port]/]<database>

I have tried and got the error Problem getting connection:
jdbc:firebirdsql:c\compiere\data\compiere.fdb
jdbc:firebirdsql:c:\\compiere\\data\\compiere.fdb

Check your URL error:
jdbc:firebirdsql://taurus/c:\compiere\data\compiere.fdb
jdbc:firebirdsql://taurus/c:\\compiere\\data\\compiere.fdb
jdbc:firebirdsql://taurus/taurus-c:\\compiere\\data\\compiere.fdb

I obtained the original syntax from Compiere properties file as:
taurus{taurus-c\:\\compiere\\data\\compiere.fdb-SYSDBA}

I'm using:
- Windows XP Professional
- Java 1.5
- Machine name: taurus
- apps port: 1099
- DB port: 3050
- DB User: SYSDBA
- DB Pwd: masterkey

If anyone can point me to the correct syntax or if there is anything
else I am missing, would be appreciated.

Thanks
Peter