Subject | ISQL behaviour different in windows and linux |
---|---|
Author | McKenna, Simon (RGH) |
Post date | 2004-12-14T01:50:12Z |
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 :)
peace - si
sshnug.com
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 :)
peace - si
sshnug.com