Re: [Firebird-devel] ISC_USER and ISC_PASSWORD environment variables with embedded FB

[Ivan P. <Iva...@se...>]

>From this test, it seems to me that ISQL ignores environment variables when working with the embedded FB?

I do not have time to test it right now, but - it is client library who look at environment variables,
not ISQL. Application (any application, not necessarily ISQL) passes connect parameters
into server in database parameter block, if user/password are missing, client library will
fill them using environment variables.

Ivan


----- Original Message ----- 
From: "Dan Wilson" <dw...@ds...>
To: <fir...@li...>
Sent: Tuesday, June 29, 2004 12:50 AM
Subject: [Firebird-devel] ISC_USER and ISC_PASSWORD environment variables with embedded FB


I have encountered a seeming anomaly with Firebird 1.5 embedded version under Windows XP:

1.  Loaded embedded version, copied isql.exe into application directory along with embedded dll (renamed as fbclient.dll
and as gds32.dll, just to cover all the bases) as well as other needed files.
2.  Environment variables ISC_USER and ISC_PASSWORD exist and contain valid username/password that work with FB SS.
3.  I ran ISQL against a database, without specifying username or password on command-line (since they were in the
environment).
4.  ISQL reported sqlcode -902 (username/password not defined).
5.  Ran ISQL again against the same database, specifying -u myuser -p mypassword.  ISQL connected correctly.

>From this test, it seems to me that ISQL ignores environment variables when working with the embedded FB?  If this was
a deliberate decision, may I ask for the reasoning behind it?  If it is a bug, shall I add it to the database?  If it is
pilot error on my part, I'd love hearing what I've done....

TIA,
Dan.