At 12:57 PM 11/05/2004 +0000, you wrote:

>Hi,
>I have just created an application for backing up and restoring
>firebird databases using gbak. I am using the firebird 1.5 embedded
>version. When I run it from my machine and I log into Windows
>as "Administrator" I don't have to connect as SYSDBA. But If I log
>into Widnows as any other user I have to connect to the database as
>SYSDBA.
>I created the database logged in to Windows as "Administrator", Does
>firebird then think that that is the owner of the database? Instead
>of SYSDBA as I specified when I created it? I thought when using the
>embedded server that I didn't have to specify a user and password.

The probable explanation is that your Administrator profile has the
environment variables ISC_USER and ISC_PASSWORD active.

If I disable isc_password in my Administrator account (Win2K), I can't do a
gbak without supplying the password.

Check this by going into a cmd window and typing SET at the prompt. This
shows all of the env. variables currently available to the logged-in user's
profile.

/heLen

>
>Thanks
>Hans
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>