At 10:07 AM 13/09/2003 -0700, you wrote:

>where should the isql exe be located? Im getting an 'unavailable database'
>when trying to run commands in isql.
>
>heres how I have our dir structure
>
>firebird.conf
>firebird.msg
>fbclient.dll
>ib_util.dll
>gds32.dll
>testdb.gdb
>myapp.exe
>isql.exe
>intl/fbintl.dll
>udf/*.sql,*.dll
>
>Does this all look right?

No.
firebird.conf
aliases.conf <-- makes life easier
firebird.msg
fbclient.dll
bin/ib_util.dll <---
gds32.dll
data/testdb.gdb <--- recommended
myapp.exe
bin/isql.exe <---
intl/fbintl.dll
udf/*.sql,*.dll
ibconsole.exe <--- (needs gds32.dll in its path, not found in %system% so
must be local)
also
bin/gbak.exe <-- will be needed

In firebird.conf:
RootDirectory = d:\TheRootDir

If using aliases conf:

db1 = d:\TheRootDir\data\test.gdb

Then
D:\TheRootDir\bin> ibsql db1

Otherwise,
D:\TheRootDir\bin> ibsql d:\TheRootDir\data\test.gdb

Tip: if it's likely that it will be deployed on ME or XP, use ".fdb" or
something else (not ".gdb") for db file suffix.

heLen