At 12:20 PM 14/12/2004 +1030, you wrote:

>Hi,
>
>When passing command line parameters, why does
>the Windows version of ISQL accept db aliases
>and the Linux version does not?
>
>Or...what am I doing wrong in the Linux call?
>
>Background:
>
>Developing using Eclipse in both Windows and Linux,
>using Ant as a cross-platform build tool.
>
>Example:
>
><target name="Drop-Database" depends="Check-Database-Exists"
>if="Database.Exists">
> <exec executable="${sql.bin}">
> <arg line='${db.file} -u "${sql.user}" -p "${sql.pass}" -i
> "${sql.scripts}/Drop.Database.sql"'/>
> </exec>
></target>
>
>Under Windows, db.file property can be an alias,
>under Linux ISQL assumes it's the database name
>and assumes the current directory is where the
>database lives.
>
>I believe the alias set in Linux is correct as I
>can connect to the database through ibWebAdmin and
>my own app using an alias, just not ISQL.
>
>Caveat: I'm still feeling my way around Linux and
>Ant, so it's probably my mistake, be gentle :)

What version of the Linux server are you using? aliases didn't enter the
game until v.1.5....

If you're using v.1.5 *and* the 1.5 client, of course, then the alias
should look like this:

mydb = /mydata/mydb.fdb

Your input script needs to do something like the following:

CONNECT 'myserver:mydb' USER 'SYSDBA' PASSWORD 'violets';
DROP DATABASE;
( add a carriage return here before saving the file ).

If running isql from a shell yourself you need either be in the /bin
directory and start the command with dot-slash:

./isql .....

or supply the full path:
/opt/firebird/bin/isql.....

Use the second syntax in a shell script.
Remember everything on Linux is case-sensitive...

./heLen