At 10:43 PM 17/10/2004 +0200, Christophe Eicke wrote:

>Hi!
>
>I have a pretty big problem. Recently we have switched our old InterBase 5
>database to a new server and also upgraded to using firebird
>1.5.1.4481-0.i686. I have just copied the old database to the new server and
>it worked pretty soon.

You have not responded to the replies that were given when you posted this
question last week.

1. Did you just *copy* the database, or did you back it up on the IB 5.x
server using IB 5.x's gbak program, using gbak -b -t ? And then, did you
copy the backup file to the new server and restore it using Fb 1.5's gbak,
gbak -c and the correct switches for a dialect 1 database?

>Since then we have had some problems with a couple of queries where the
>server
>would drop all the connections to the database (it's from about 20 - 30
>clients), it was no big deal. Until now we found out that the server does not
>accept CREATE TABLE statements, using the ISQL client from a windows client
>or directly on the database server. On the database server I get a
>"segmentation fault" and ISQL quits.
>We are running firebird on a slackware 9.0 with kernel 2.4.6.
>Any help would be greatly appreciated!

2. Did you install the correct client libraries and isql versions on the
client machines?

Also
3. Did you install the Classic version or Superserver on the slackware box?

./heLen