At 03:56 PM 10/02/2005 -0600, you wrote:

>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

Missing semicolon after the CONNECT statement?

Also make sure you include a CR/LF at the end of the script.

./hb