Personal Video Database

English => Support => Topic started by: Chris64 on November 10, 2013, 08:43:28 pm

Title: Passing user credentials to Firebird server
Post by: Chris64 on November 10, 2013, 08:43:28 pm

Hi Nostra,

as far as I can see, PVD does not make any use of the "ISC_USER/ISC_PASSWORD" environment variables, which
would allow seamless connection from PVD to a FB server.

Is such feature planned?

TIA Chris

Title: Re: Passing user credentials to Firebird server
Post by: nostra on November 11, 2013, 09:16:50 pm

Actually, it seems like Firebird should pick those values by itself. I will check if it is smth easy I can do to make it do so,

Title: Re: Passing user credentials to Firebird server
Post by: Chris64 on November 12, 2013, 12:33:17 am

Quote from: nostra on November 11, 2013, 09:16:50 pm

Actually, it seems like Firebird should pick those values by itself. I will check if it is smth easy I can do to make it do so,

I read about this too that fbclient should get it.
But it looks like it doesn't ... I already tried this to no avail. :-(

Code: [Select]

@echo off
SET PATH=C:\Program Files\PVD;%PATH%
SET ISC_USER=xxxxxxxx
SET ISC_PASSWORD=yyyyyyyy
start viddb.exe
# OR (alternatively)
viddb.exe
will not give me the expected behaviour from a batch.

Even setting the variables system wide would allow the cmd line tools
of Firebird (i.e. gbak) to work from a cmd line (without user/pass), while
PVD presents me a login prompt for the user/pass credentials on each
new start.

So thx for looking into it!

EDIT:
Forgot to mention that even "Process Hacker" shows the variables
in the process' environment of viddb.exe when started from the batch.