Subject | Re: [firebird-support] isql v2.1.2 doesn't open database with alias |
---|---|
Author | Mark Rotteveel |
Post date | 2009-08-25T17:06:45Z |
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:
Mark Rotteveel
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