Thanks for Help.

i still have that problem but had some other problems to solve  so today  i did a step by step diagnose:

1. i hav a c:\data\mydb.fdb  ...filled with data on a complete new setup Virtual machine.

2. from anwhere on the filesystem i can "isql c:\data\mydb.fdb" which means the Path is set correct to the firebirds binary path and the ISC_USER/ISC_PASSWORD vars are set.

3. i did the following (cut-pasted from console)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

C:\data>path
PATH=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\firebird\bin

C:\data>copy con c:\firebird\aliases.conf
mydb = c:\data\mydb.fdb
c:\firebird\aliases.conf überschreiben? (Ja/Nein/Alle): j
^Z
        1 Datei(en) kopiert.

C:\data>isql mydb
Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (open)" operation for file "mydb"
-Error while trying to open file
-Das System kann die angegebene Datei nicht finden.
Use CONNECT or CREATE DATABASE to specify a database
SQL> exit;

C:\firebird>isql -z
ISQL Version: WI-V2.5.8.27089 Firebird 2.5
Use CONNECT or CREATE DATABASE to specify a database
SQL>

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

-The system cannot find the specified file  (translation...)

What the heck is going wrong here?

 

 leawolf@... wrote:


> i cannot connect to a remote (Windows) located firebird 2.5 database anymore
>  this problem is new and worked many years. 

>  if i try: 

>  c:\>isql [ip-address]:db-alias     or
>  c:\>isql [ip-address]/3050:db-alias 
>   
> i get the error: 
> Statement failed, SQLSTATE = 08001
>  I/O error during "CreateFile (open)" operation for file "rdatabase"
>  -Error while trying to open file
>  -Das System kann die angegebene Datei nicht finden.
>  Use CONNECT or CREATE DATABASE to specify a database 
>   
> if i try 
c:\>>isql db-alias 
> on the remote servers console
>  i get the same error 
>   
> next test: copy-past the full-path from the aliases.conf to the console. This file exists (dir)
>  and isql [pasted] works well too. 

>  if have set isc_user/password to sysdba/masterkey and added the
> servers bin dir to the path environment. 
>   
> Why doesn't this work anymore?
>  Please help! 
>   
> ---------------c:\firebird\aliases.conf of the remote firebird server -----------------------

Is c:\firebird actually the root directory of your Firebird server
installation? aliases.conf needs to be in that location, e.g.
c:\{whatever}\Firebird\Firebird_2_5, if that is Firebird's root.

If the location is correct, then perhaps the file has been corrupted
in some way.  As a reality check, delete aliases.conf and use Notepad
to create a new one, making sure that Windows does not add a bad
suffix when you save the file.  In Fb 2.5, you don't need to restart
Firebird after changing aliases.conf.

If it turns out that this solves the problem, check the health of the
C drive.  Random file corruptions can indicate problems.

Helen