Subject Re: aliases.conf ignored?
Author
 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