Subject | ISQL question |
---|---|
Author | Raith, Daniel |
Post date | 2005-02-10T21:56:02Z |
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
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