Subject | Re: [firebird-support] Unavailable database |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-02-12T19:24:32Z |
> FB1.5.6.5026/w32 Win7 x64/sp1No. This means, you haven't terminated the SQL with a ';', thus isql is
>
> When I began my transition from Win2k to Win7 x64, I couldn't get any of my apps which ran an fb db to run: it was always "unavailable database" or from a Delphi message box, "check that the database is present." Drove me mad. Then I started changing Win7 user permissions, and finally everything worked again.
>
> Recently I've been having windows problems with dbl-clk not opening pdf and rtf files. So I ran Windows Folder and File fix applet and it didn't find anything. Shortly after I shut down.
>
> This AM all of my fb apps returned "unavailable database" or the equivalent from a delphi app. I mainly use IBO_SQL to do my testing: that's what gives the "unavailable database -904 335544375 error.
>
> I uninstalled and reinstalled twice. Same thing.
>
> So I started looking at my db permissions and they had been reduced. So I gave them full permissions, but I still can't get anything to open.
>
> Running this, however, appears to work:
>
> isql 'C:\Program Files (x86)\Firebird_1_5\examples\employee.fdb -user SYSDBA -password masterkey
> CON>
>
> That is, if I can presume that the 'CON>' return means that fb connected to the db.
awaiting additional data in a new line.
> I'm logged in as an administrative user.Use a TCP/IP connect string, even if you are on the same machine. E.g.:
>
> employee.fdb lists full control for SYSTEM and Administrators(MyComputer\Administrators)
> Only 'Read& Execute and Read' for (Users\MyComputer\Users)
localhost:c:\...
This usually cures such problems.
HTH.
--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/