Hi Adam

How do I check if there is something connected to the database which may be
gaining exclusive access? I know that I haven't initiated access to the DB
using any other applications.

How do I implement the TCP loopback connection for the database ?
Unfortunately, I am using the BDE components TQuery, TDatabase, etc.

I believe it may be something internal to the opening of the database within
the code. I'll go and check that out now...

Cheers,
Gaurav

On 2/24/06, Adam <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "Gaurav Sood"
> <sood.gaurav@...> wrote:
> >
> > Alexandre,
> >
> > The database and the application are on the same computer (Windows
> 2000). I
> > was using a ini file with string
> > Database=localhost:C:\MyApplication\Database\myDatabase.gdb
> >
> > the application cannot "open" the database, however, isql can.
> >
> > I know about the path problems if the database and server are on
> different
> > PCs, however, the FBserver is installed on this PC as well.
> >
> > Could the problem lie with the executable ? in opening the
> database ? If so,
> > how come when I am using the exe on my development XP PC, there are
> no
> > problems opening the DB?
> >
> > Thanks,
> > Gaurav
>
> My guess is that you have something connected to the database using a
> local path. if anything connects to a database with the local path,
> then that process gains exclusive access to the database.
>
> Make sure all applications accessing the database have a TCP loopback
> connection (this includes iSQL, IBExpert, etc)
>
> Also, totally unrelated issue, do not give a Firebird database a .gdb
> extension (.fdb is fine). This causes a problem with Windows XP
> system restore.
>
> Adam
>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


--



Analyst
B. Engineering, B. IT
A.N.U (2004)

M: +61 401 409 620
H: +61 3 9376 8580


"In life, always do right. This will gratify some people and astonish the
rest."

� Mark Twain


[Non-text portions of this message have been removed]