I am trying to run:

SCRIPT
BEGIN

EXECUTE IMMEDIATE 'DROP Database "BrainMan"';

EXECUTE IMMEDIATE 'CREATE Database "BrainMan" PATH ''C:\ElevateSoft\Databases\''';
...

The database is closed at that point, yet I receive error #300 Cannot lock database .. for exclusive access.

How do I resolve this?

TIA
Darrell

Darrell,

<< I am trying to run:

SCRIPT
BEGIN

EXECUTE IMMEDIATE 'DROP Database "BrainMan"';

EXECUTE IMMEDIATE 'CREATE Database "BrainMan" PATH
''C:\ElevateSoft\Databases\''';
..

The database is closed at that point, yet I receive error #300 Cannot lock
database .. for exclusive access. >>

How are you running the script - in the EDB Manager or in an application ?
What database is the active database when you run the script ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Darrell,

<< I am trying to run:

SCRIPT
BEGIN

EXECUTE IMMEDIATE 'DROP Database "BrainMan"';

EXECUTE IMMEDIATE 'CREATE Database "BrainMan" PATH
''C:\ElevateSoft\Databases\''';
..

The database is closed at that point, yet I receive error #300 Cannot lock
database .. for exclusive access. >>

How are you running the script - in the EDB Manager or in an application ?
What database is the active database when you run the script ?

--
Tim Young
Elevate Software
www.elevatesoft.com



In EDB Manager.

I only have one database, so I guess it can be closed and be the active one?

Darrell

Kai


Are you running it in the context of the session or the database?

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Are you running it in the context of the session or the database?

Roy Lambert [Team Elevate]

Roy:

I don't know what you mean by that - how can I tell?

Darrell

Darrell


This is one that I fail on frequently

Look at the status bar at the bottom. Third in from the right will be a database icon and the name of the current database. If its showing one of your database names then you're executing it from the context of the database, if it shows Configuration then its from the context of the session (the session is shown in the next box right) and if its blank you're at the context of the engine.

Roy Lambert [Team Elevate]

Darrell,

<< I only have one database, so I guess it can be closed and be the active
one? >>

See Roy's response - you want the active database in the EDB Manager to say
"Configuration", not the name of your database, when you run that script.
Otherwise, the EDB Manager will implicitly open the active database when you
execute the script, thus causing the lock error.

--
Tim Young
Elevate Software
www.elevatesoft.com