07.07.2016 07:25, Alexandre Benson Smith wrote:

>
> I am looking at the per-database configuration (FB 3) and have two doubts:
>
> I defined my databases.conf like:
> demo_naolocal=c:\bd\demo_naolocal.fdb
> {
> Providers = Remote,Loopback
> }
>
> after that on the same machine I tryed:
>
> C:\fb3>isql demo_naolocal -user teste -password abc
> Statement failed, SQLSTATE = 08001
> I/O error during "CreateFile (open)" operation for file "demo_naolocal"
> -Error while trying to open file
> -O sistema não pode encontrar o arquivo especificado. (Translates to:
> The system could not find the specified file)
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> quit;
>
> C:\fb3>isql localhost/3053:demo_naolocal -user teste -password abc
> Statement failed, SQLSTATE = 08001
> unavailable database
> Use CONNECT or CREATE DATABASE to specify a database
> SQL>
>
> I expected the first one to fail and the second to succeed.

Your expectation is correct from the client POV. But you miss the fact
that the network server (namely: firebird.exe) also connects to the
database through the y-valve so the same configuration is used again.
And now the engine provider is strictly required.

I.e. if c:\fb3 contains a default config but isql runs from a different
directory (with modified configuration), then it would work.


Dmitry