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

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

David,
Thanks for the detailed responses on the two emails. Yes definitely a
mis-understanding on my part.

I tried "jdbc:firebirdsql://localhost:3050/compiere" but still get the
error "CF: Problem getting connection: could not get a db connection".
I've tried capitalized Compiere, uppercase and lowercase for the
database name, and user, but no success.

Is there anyway to get a more detailed response to see where I'm going
wrong?

After writing the above I decided to try and find out how to use ISQL to
connect to the database.
I executed the following in ISQL:
- CONNECT "C:\Compiere\data\compiere.fdb" user 'SYSDBA' password
'masterkey'

I connected and was able to show the database details and table details.

I then tried the following in Squirrel:
- jdbc:firebirdsql:"C:\Compiere\data\compiere.fdb"
and got the error message "Unexpected Error occured attempting to open
an SQL connection"
This suggested to me that I am getting closer.

I then tried
"jdbc::firebirdsql:"//localhost/compiere"
and received error "Problem getting connection could not get a db
connection"

So I know I can connect to the database and can see the database
contents. Plus I get the open an SQL connection error when ever I use
the directory path.

Sorry to put such a basic question to the list. I appreciate any
suggestions and pointers to getting me going again.

Thanks




----- Original message -----
From: "David Cook" <Dav...@ve...>
To: sun...@us...
Date: Sat, 29 Apr 2006 07:52:59 -0400
Subject: RE: [Squirrel-sql-users] Attaching to database with URL


Peter -

	Yes, your problem stems from what appears to be a mis-understanding
on your part about how database-SERVERS work.  One does NOT ever specify
an actual driver-letter, file and directory (as you tried to do).
The SERVER knows where the data comes from...the client does NOT!

[snip snip snip]