Hi Paul!

I've no clue about your question (well, except asking you about the setting of the DatabaseAccess parameter in firebird.conf and wondering whether relative paths are allowed at all when connecting, I've never tried connecting from within isql), but I think it would be wiser of you to post this question to firebird-support rather than to firebird-general.

Set

-----Original Message-----
From: Firebird-general@yahoogroups.com [mailto:Firebird-general@yahoogroups.com] On Behalf Of plinehan
Sent: 2. desember 2009 08:07
To: Firebird-general@yahoogroups.com
Subject: [Firebird-general] Help with ISQL and connecting...



Hi guys,

Maybe it's because I'm very tired (it's 7 in the morning
and I haven't gone to bed yet!), but I'm stumped on a
small issue - when I see (hopefully) an answer, I'll have
one of those Homer ("Doh" <slaps forehead>) moments...


I'm running isql from the local directory where the database
is

I've tried the lot - with every variation of double and single
quotes that I can think of - see end of post, and I've
Googled ad nauseam.

I would be extremely and eternally grateful if somebody
could point me to the correct syntax for what I
want to do.

I *_know_* I can do it directly from the command
prompt - but I would like to know how to do it
from within isql itself - e.g. suppose I want to
change to a different database in the same session.


TIA and rgs.


Paul...



paul@paul-desktop:~/software/FB/superserver/sql$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect ./Bridge.fdb -u SYSDBA -p paul;
Command error: connect ./Bridge.fdb -u SYSDBA -p paul
SQL> connect /home/paul/software/FB/superserver/sql/Bridge.fdb -u SYSDBA -p paul;
Command error: connect /home/paul/software/FB/superserver/sql/Bridge.fdb -u SYSDBA -p paul
SQL> connect localhost:/home/paul/software/FB/superserver/sql/Bridge.fdb -u SYSDBA -p paul;
Command error: connect localhost:/home/paul/software/FB/superserver/sql/Bridge.fdb -u SYSDBA -p paul
SQL> connect ./Bridge.fdb -u 'SYSDBA' -p 'paul';
Command error: connect ./Bridge.fdb -u 'SYSDBA' -p 'paul'
SQL> connect ./Bridge.fdb -u "SYSDBA" -p "paul";
Command error: connect ./Bridge.fdb -u "SYSDBA" -p "paul"
SQL> connect "./Bridge.fdb" -u "SYSDBA" -p "paul";
Command error: connect "./Bridge.fdb" -u "SYSDBA" -p "paul"
SQL> connect "./Bridge.fdb" -u 'SYSDBA' -p 'paul';
Command error: connect "./Bridge.fdb" -u 'SYSDBA' -p 'paul'
SQL> connect './Bridge.fdb' -u 'SYSDBA' -p 'paul';
Command error: connect './Bridge.fdb' -u 'SYSDBA' -p 'paul'
SQL>