Subject | RE: [firebird-support] ISQL behaviour different in windows and li nux |
---|---|
Author | McKenna, Simon (RGH) |
Post date | 2004-12-16T00:51:39Z |
-=> What version of the Linux server are you using?
Latest release (1.5.1 r4481) for Windows and Linux.
-=> If you're using v.1.5 *and* the 1.5 client
Check.
-=> mydb = /mydata/mydb.fdb
Check.
-=> Your input script needs to do something like the following:
-=> CONNECT 'myserver:mydb' USER 'SYSDBA' PASSWORD 'violets';
Ahhh...this is where I was going wrong...
When alias.conf contains:
employee = C:\Program Files\Firebird\examples\EMPLOYEE.FDB (Windows)
employee = /opt/firebird/examples/EMPLOYEE.FDB (Linux)
In Windows these both work:
isql employee -u 'user' -p 'pass' -i 'script'
isql localhost:employee -u 'user' -p 'pass' -i 'script'
In Linux only this works:
isql localhost:employee -u 'user' -p 'pass' -i 'script'
Without the server prefix, in Linux ISQL assumes that
the db name is `employee` and the current directory
is the location.
If I replace the alias with the full path and filename,
my Ant tasks work fine under both Windows and Linux,
so I've decided to go down that path. Just following
this up in case the inconsistency is worth fixing
(not sure as it's very minor).
Appreciate your time Helen.
peace - si
sshnug.com
Latest release (1.5.1 r4481) for Windows and Linux.
-=> If you're using v.1.5 *and* the 1.5 client
Check.
-=> mydb = /mydata/mydb.fdb
Check.
-=> Your input script needs to do something like the following:
-=> CONNECT 'myserver:mydb' USER 'SYSDBA' PASSWORD 'violets';
Ahhh...this is where I was going wrong...
When alias.conf contains:
employee = C:\Program Files\Firebird\examples\EMPLOYEE.FDB (Windows)
employee = /opt/firebird/examples/EMPLOYEE.FDB (Linux)
In Windows these both work:
isql employee -u 'user' -p 'pass' -i 'script'
isql localhost:employee -u 'user' -p 'pass' -i 'script'
In Linux only this works:
isql localhost:employee -u 'user' -p 'pass' -i 'script'
Without the server prefix, in Linux ISQL assumes that
the db name is `employee` and the current directory
is the location.
If I replace the alias with the full path and filename,
my Ant tasks work fine under both Windows and Linux,
so I've decided to go down that path. Just following
this up in case the inconsistency is worth fixing
(not sure as it's very minor).
Appreciate your time Helen.
peace - si
sshnug.com