Hi!

Yesterday we tried to migrate two sites of one corporation.
Whe we sent some alter SQL to the another site, the admin said the he cannot update, because of he got some error message "Catalog is read only".

We paste the error from the log now.

An error occurred with the statement at line 4 and column 19 (The database Configuration is read-only and this operation cannot be performed (ALTER TABLE taska))

Only way to altering that sysadmin sent the DB to us, we copied it to a dir, alter it, and resend to sysadmin.

We want to know which thing can make this state, and how to avoid or reset the "readonly" flag?

Thanks for your great help!

dd

<< An error occurred with the statement at line 4 and column 19 (The
database Configuration is read-only and this operation cannot be performed
(ALTER TABLE taska)) >>

This means that you tried to execute an ALTER TABLE statement from the
context of the Configuration database.  Check your code to make sure that
you always execute DDL statements from the context of the database that you
are trying to alter.  The TEDBQuery.DatabaseName property determines which
database is used when the SQL is executed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi!

"Tim Young [Elevate Software]" wrote:
<< An error occurred with the statement at line 4 and column 19 (The
database Configuration is read-only and this operation cannot be performed
(ALTER TABLE taska))
This means that you tried to execute an ALTER TABLE statement from the
context of the Configuration database.  Check your code to make sure that
you always execute DDL statements from the context of the database that you
are trying to alter.  The TEDBQuery.DatabaseName property determines which
database is used when the SQL is executed. >>

Interesting that sysadmin uses EDB to run this script.
How to got this event in EDBManager?
Where he stand, what object he can select to provide this?

Hmmmm...

Thanks:
  dd

<< Interesting that sysadmin uses EDB to run this script.  How to got this
event in EDBManager?  Where he stand, what object he can select to provide
this? >>

He/she needs to select a valid database node (or lower) from the treeview on
the left.  You can always see what the current database is at the bottom
right-hand side of the main status bar.

--
Tim Young
Elevate Software
www.elevatesoft.com