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
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
