I had a similar problem - the message seems to be a catch-all. Try putting
the pathname in the db string:
e.g., connect '\\machine\c\temp\scg2.ibp';

in my case, the problem was that I wasn't truly local, I was using a remote
desktop to get to the local machine. Oddly enough, ODBC got exactly the same
error until I made the database folder a network share.

good luck

Ann Cecil

----- Original Message -----
From: "grndeveloper" <developer@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, February 11, 2005 8:10 AM
Subject: [firebird-support] Re: unavaliable database


>
>
> --- In firebird-support@yahoogroups.com, Uwe Grauer
> <mailinglists@o...> wrote:
> > developer wrote:
> >
> > > Hello,
> > >
> > > I've just installed Firebird 1.5.2 in a windowns environement
> > > (Windows XP SP2 and Windows 2003). I have the problem in both
> > > installations.
> > >
> > > When I try to connect to the database from a remote pc (with
> > > IBexpert or our own application) everything is fine, but when I try to
> > > do any of the following comands from the local server (isql, gsec,
> gbak)
> > > I get always the same error message : unavailable database.
> > >
> > > Any ideas?
> > >
> > > Thanks.
>
>
> >
> > Wrong syntax used?
>
> The syntax is correct. Let me show you an example:
>
> C:\Archivos de programa\Firebird\bin>isql -user sysdba -password
> <mypassword>
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> connect 'c:\temp\scg2.ibp';
> Statement failed, SQLCODE = -904
> unavailable database
>
> I get the same error whatever database file I try.
>
> > What about connecting with IBExpert from the local machine?
>
> There is something strange with it. If I register a database as remote
> specifying my IP it works allright, but if I register my database as
> local specifying only the path to the database file it doesn't works.
>
>
> > How did you try to run the commandline tools?
>
> >From the ($Firebird_home)\bin as the example shown in your first
question.
>
> > Wrong connection string?
>
> I dont't thing so.
>
> >
> > Uwe
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>