On Monday 18 October 2004 02:11, Helen Borrie wrote:

> 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.

My mistake, I didn't see the replies...

>
> 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?

No, I did not, I just copied the database. What difference does it make? The
problem now is that there are two databases (the one on the old server and
the new one with changes already made into it) with different information
content. Would it help to "gbak -b -t" the new one and "gbak -c" it back
again?

>
> >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?

yes I did

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

Classic version

Thanks a lot!
Christoph

--
GPG Key ID: 33D6AA8C
AIM: zeitgeist2600
ICQ: 271512600
Jabber: zeitgeist@...
SIP: sip://4319836@...