At 12:12 PM 18/04/2005 +0200, you wrote:

>Hi firebird-support,
>im currently trying to get the firebird superserver on a suse 9.2
>x86_64 machine running. i read the releasenotes pdf and have all the
>required packages i think. but when it comes to testing with isql (as
>described), isql only shows its help screen. using the -v option shows the
>following:
>isql -v
>[IM002][unixODBC][Driver Manager]Data source name not found, and no
>default driver specified
>[ISQL]ERROR: Could not SQLConnect
>i didnt find any useful help on the net. so what can i do?

You are invoking the wrong ISQL program.

You want firebird's isql which is in /opt/firebird/bin. So, either go to
/opt/firebird/bin and type
./isql

or type
/opt/firebird/bin/isql.

>the installation itself seems to be correct. i also tested the classic
>server without success. also installing firebird on my fedora core 2
>shows the same problem. any hints?

The next hint I would suggest is to study the isql documentation (most of
it can be found in the IB6 OpGuide.pdf) and/or to look at the online
help. Command-line switches are summarised at the command-line if you pass
an invalid switch:
./isql -?
Unknown switch: ?
isql [<database>] [-e] [-t <terminator>] [-i <inputfile>] [-o <outputfile>]
[-x|-a] [-d <target db>] [-u <user>] [-p <password>]
[-page <pagelength>] [-n] [-m] [-q] [-s <sql_dialect>]
[-r <rolename>] [-c <num cache buffers>] [-z] -nowarnings -noautocommit

Inside the isql shell, you can get a brief list of internal commands thus:
SQL> help;
Frontend commands:
BLOBDUMP <blobid> <file> -- dump BLOB to a file
BLOBVIEW <blobid> -- view BLOB in text editor
EDIT [<filename>] -- edit SQL script file and execute
EDIT -- edit current command buffer and execute
HELP -- display this menu
INput <filename> -- take input from the named SQL file
OUTput [<filename>] -- write output to named file
OUTput -- return output to stdout
SET <option> -- (Use HELP SET for complete list)
SHELL <command> -- execute Operating System command in sub-shell
SHOW <object> [<name>] -- display system information
<object> = CHECK, DATABASE, DOMAIN, EXCEPTION, FILTER, FUNCTION,
GENERATOR,
GRANT, INDEX, PROCEDURE, ROLE, SQL DIALECT, SYSTEM, TABLE,
TRIGGER, VERSION, VIEW
EXIT -- exit and commit changes
QUIT -- exit and roll back changes

All commands may be abbreviated to letters in CAPitals
SQL>

./heLen