From: "Claudio Valderrama C." <cvalde@...>
To: <Firebird-general@yahoogroups.com>
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;
charset="iso-8859-1"
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: Firebird-general@yahoogroups.com=20
> [mailto:Firebird-general@yahoogroups.com] On Behalf Of plinehan
> Sent: Mi=E9rcoles, 02 de Diciembre de 2009 4:07
>=20
> 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 =
the
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 =
user
and p for password. The hyphen denotes typical parameters for programs =
that
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 =
CONNECT
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, =
not
here!!!

C.