Subject ISQL question
Author Raith, Daniel
I'm trying to write a simple script to drop a database and another to
create a database. I already have the database created so I thought I'd
try the simple drop script.

SET SQL DIALECT 3;
SET NAMES NONE;
CONNECT 'c:\temp\test.fdb' user 'sysdba' password 'masterkey'
DROP database;

Now if I simply go to a cmd prompt, why doesn't this work?

C:\Temp>"c:\program files\firebird\firebird_1_5\bin\isql.exe" -i
c:\temp\test.sql
Use CONNECT or CREATE DATABASE to specify a database
Command error: CONNECT 'c:\temp\test.fdb' user 'sysdba' password
'masterkey'
DROP database