Subject Re: [firebird-support] Re: isql v2.1.2 doesn't open database with alias
Author Mark Rotteveel
mirjua62 wrote:
> --- In firebird-support@yahoogroups.com, Mark Rotteveel <Avalanche1979@...> wrote:
>> Either you didn't add the alias to aliases.conf, or you edited the file
>> without administrator privileges.
>>
>> If you edit any file in Program Files without running the editor with
>> 'run as administrator', instead of modifying the file in Program Files a
>> local copy is saved in
>> C:\Users\<username>\AppData\Local\VirtualStore\Program Files
>>
>> Since Firebird runs as a Service under a different user, it continues to
>> read the unchanged version of aliases.conf.
>>
>> Solution:
>> 1) Delete the local copy in the VirtualStore in your profile
>> 2) Start your editor by right clicking and selecting 'Run as administrator'
>> 3) Open aliases.conf and make the changes
>>
>> Mark
>>
>> mirjua62 wrote:
>>> I've been using FB 1.5 trough 2.1 since 2004.
>>> I always opened the DB with iSql using the alias (I have a .bat for doing it!).
>>> But now I installed FB 2.1.2 in my new Vista System and when I try to open the database (in order to specify the privileges)it gives to me the following error:
>>>
>>> C:\MirJua\Des\AdmNeg\Fnt\fdb>isql -u sysdba -pas masterkey -page 60 AdmNeg
>>> Statement failed, SQLCODE = -902
>>> I/O error for file "C:\MIRJUA\DES\ADMNEG\FNT\FDB\ADMNEG"
>>> -Error while trying to open file
>>> -The system cannot find the file specified.
>>> Use CONNECT or CREATE DATABASE to specify a database
>>>
>>> In the command I'm using the alias, so I can't understand what's the problem!
>>>
>>> What's wrong?
>> --
>> Mark Rotteveel
>>
>
> Wuao!... that's an answer!!!
> It could be, but, where is the Virtual Store?
> Why could this happend?
> Why this worked fine in Win98, XP & Win2k3?
> I doesn't know how to find my Virtual Store....

See the second paragraph in my email:
C:\Users\<username>\AppData\Local\VirtualStore\Program Files

VirtualStore is a security feature introduced in Windows Vista.


--
Mark Rotteveel