| Subject | Re: [firebird-support] Re: Cannot create tables in new FB 2.5 DB, fails with error 335544351 on commit |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2011-01-01T01:26:17Z |
Helen Borrie wrote,
It also supports SET TERM.
Peter: there's something very weird going on in your database. FWIW, I also ran your DDL (on 2.5) and it worked flawlessly.
The message "cannot create index RDB$PRIMARY11" suggests there may be something wrong with your system tables.
Have you already tried creating a brand new database and then creating only domain OidKey and table HL_Oids? All this as the same user and from one client (to keep things simple).
Also make sure that only the Firebird server accesses the database file directly.
Good luck,
Paul Vinkenoog
> You'll need to make your app code strip out the terminator before you pass the statement. I don't know whether Flamerobin does this automatically...Even better: if you use semicolons, FlameRobin treats your statements as a script, executing them one by one. I found this out by pure accident, not so long ago :-)
It also supports SET TERM.
Peter: there's something very weird going on in your database. FWIW, I also ran your DDL (on 2.5) and it worked flawlessly.
The message "cannot create index RDB$PRIMARY11" suggests there may be something wrong with your system tables.
Have you already tried creating a brand new database and then creating only domain OidKey and table HL_Oids? All this as the same user and from one client (to keep things simple).
Also make sure that only the Firebird server accesses the database file directly.
Good luck,
Paul Vinkenoog