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>