At 12:23 AM 6/12/2005 +0000, you wrote:

>I'm trying to execute the following statement but I keep on getting an
>error:
>
>CREATE TABLE CHARTDATA (
>CATNO VARCHAR(32)
>)
>
>and the error is:
>
>This operation is not defined for system tables.unsuccessful metadata
>update.
>CHARTDATA.
>
>This happens just after creating the database so there are no other
>tables. This occurs when using an embedded db (1.5.2.4731). Doing the
>same thing on the server works fine.
>
>Any idea what's going wrong?

First guess is that whatever you used to create the database is still
connected to the database. In embedded, that means that application
(whatever it is) has the exclusive database lock. If you come along from
some other application and try to connect the database from another server,
you can't.

If that's the correct guess then you've got another problem. The
application that you are trying to do this from is coming in via a client
library somewhere else in the system path, most likely
in %sysdir%\system32, and the full server, and that client and full server
are not 1.5.2.4731 but something older - InterBase? Firebird 1.0.x? - hence
the muddled messages.

Anyway, more info would help. For example, if you're testing some code
through an IDE (like Delphi, for example) then you're going to bump into
the problem of the exclusive lock all along the line if you are trying to
*develop* with the ES as the client and server. Basically, the IDE gets
the lock and so your running app can't get it. Develop your app with the
full server and deploy it with embedded.

./heLen