I don't have any idea what could be causing this problem.
Perhaps it would help if you looked into the SQL tracemonitor for what is
going on.

You may not be disconnected from the existing database. Try making sure you
are disconnected.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "rodbracher" <rod@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 10, 2002 9:45 AM
Subject: [IBO] Please reply !


> Hi
> Sorry to post this twice - but no reply a couple of weeks ago.
>
> Using tIB_Script I execute :
>
> SET SQL DIALECT 3;
> SET AUTODDL ON;
>
> I then have a tIB_Script to create a DB :
>
> CREATE DATABASE 'C:\DelphDat\sqldatafile\TEST1.GDB'
> USER 'SYSDBA' PASSWORD 'masterkey'
> DEFAULT CHARACTER SET NONE;
> CREATE TABLE TESTTABLE (
> F1 SMALLINT NOT NULL,
> F2 SMALLINT NOT NULL,
> F3 INTEGER );
>
> If I run then script again, just changing line[0] to
> CREATE DATABASE 'C:\DelphDat\sqldatafile\TEST2.GDB'
>
> I get the error - 'Invalid Database handle - no active transaction'
>
> My scripts IB_transaction property is <default>, since I cannot
> assign a transaction / connection ( as I am creating a database ).
>
> If I run the above mentioned process in IBConsole, I works fine.
>
> Please advise
>
> Thanks - Rod