Subject RE: [firebird-support] ISQL and Telnet on XP
Author Nigel Weeks
It appears you're doing a direct file access to the DB - I hope it's on the
machine you're trying to do this from!

You should always put the server name in the connection string:
isql -u USER -p PASS "servername:c:/progra...etc.etc.../pos.fdb"

If you mix direct file access, and TCP/IP via servername/path/to/db, you
will wreck databases!

(Unless things have changed in the last two years...)

N.

> -----Original Message-----
> From: chrisgs100 [mailto:ChrisS@...]
> Sent: Thursday, 5 August 2004 9:37 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] ISQL and Telnet on XP
>
>
> Hi all,
>
> I want to use ISQL remotely on an XP workstation running firebird
> 1.5. I can
> run ISQL fine directly on the machine but when I try through a telnet
> session I get the following error
>
> C:\Program Files\Firebird\Firebird_1_5\bin>isql "c:\Program
> Files\Bass
> Software\Apparel 21 POS\pos.fdb" -u USER -p PASSWORD
> Statement failed, SQLCODE = -904
>
> unavailable database
> Use CONNECT or CREATE DATABASE to specify a database
> SQL>
>
> Has anyone else encountered this problem?
>
> Chris S
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Yahoo! Domains - Claim yours for only $14.70
> http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>