Subject | Re: "Director is Busy" error, DB Connection to IB_SERVER error |
---|---|
Author | Adam |
Post date | 2006-02-02T04:07:59Z |
> I am attempting to connect to a Firebird DB file which I haverenamed to
> .gdbThis will cause you problems with Windows ME and XP, it should be
called .fdb.
>, using a TDatabase, TSession and TQuery, however, after setting upthe
> connection as given in the Using TQuery help file. I get the aboveerror, or
> 'Director is Busy'. What would be causing this error ?The BDE, dont use it. There are lots of better components to use. It
is probably the netfiles or a lck file or something, but it is not
worth using. Borland have discontinued it anyway. If you are just
getting started with Firebird, use any other component.
>no
> After removing the TSession, I set the SessionName to 'Default'. I
> longer get the above error when compiling, however, I am unable toestablish
> a connection. I have set the Params to the followingWhat is this line all about?
>
> Database=localhost:C:\casala \Casala2006\database\CASALA.gdb
> SERVER NAME=IB_SERVER:/PATH/DATABASE.GDB
> USER NAME=SYSDBA
> OPEN MODE=READ/WRITE
> SCHEMA CACHE SIZE=8
> LANGDRIVER=
> SQLQRYMODE=SERVER
> SQLPASSTHRU MODE=SHARED NOAUTOCOMMIT
> SCHEMA CACHE TIME=-1
> MAX ROWS=-1
> BATCH COUNT=200
> ENABLE SCHEMA CACHE=TRUE
> SCHEMA CACHE DIR=%TEMP%
> Password=masterkey
>
>
> And get this error:
>
> Unknown Database
> Unable to complete network request to host "IB_SERVER"
> Failed to locate host machine
> The specified name was not found in the General SQL error.
> hosts file or Domain Name Services.
> Alias: Casala
>
> SERVER NAME=IB_SERVER:/PATH/DATABASE.GDBMy guess is that it is generating a connection string on the fly. You
will do very well to uninstall BDE and never use it again. I can ont
stress this enough. Even IBX is a lot better. From memory, I don't
think there ever was a BDE that was stable with Interbase/Firebird.
It is a pain to install and a pain to maintain, you will forever be
having to delete lock files when someone reboots their machine.
Adam