From: "Claudio Valderrama C." <cvalde@...>
To: <>
Subject: RE: [Firebird-general] Help with ISQL and connecting...
Date: Wed, 2 Dec 2009 07:02:59 -0300
Message-ID: <0A1E8E819DB34808B5A694D9D3859DC1@atenea>
MIME-Version: 1.0
Content-Type: text/plain;
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.6856
Importance: Normal
Thread-Index: AcpzHh05GqfWfJ+NRLWcbD8G6X3wTgABEr8w
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
In-Reply-To: <hf53ne+5bfr@...>

> -----Original Message-----
> From:
> [] On Behalf Of plinehan
> Sent: Mi=E9rcoles, 02 de Diciembre de 2009 4:07
> Maybe it's because I'm very tired (it's 7 in the morning=20
> and I haven't gone to bed yet!),

Same here.

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

First, you should send this to firebird-support instead.

> SQL> connect ./Bridge.fdb -u 'SYSDBA' -p 'paul';
> Command error: connect ./Bridge.fdb -u 'SYSDBA' -p 'paul'

The reason is that you are confusing isql's command line parsing with =
engine's more strict parsing. When you do
isql ./Bridge.fdb -u SYSDBA -p paul
it's isql that understands abbreviations for parameters names: u for =
and p for password. The hyphen denotes typical parameters for programs =
receive arguments. Then isql assembles the connection call for you.

When you do inside isql
connect ./Bridge.fdb -u SYSDBA -p paul;
isql is sending your command almost unchanged to the server itself to be
parsed. The server does not understand abbreviations neither options
preceded by hyphens. You should follow the server's syntax for the =
command and type
connect ./Bridge.fdb user 'SYSDBA' password 'paul';

That's all.

If someone wants to continue this idea, please post to firebird-support, =