Subject Re: [firebird-support] Update database to new version?
Author Stevio
> > Do you need to do anything to update your database to make it use
> > the newer version of Firebird, when you install 1.5?
> >
> > Thanks,
> > Stephen
> what version are you coming from? IB6 yes.
> that said - take the opportunity to always backup and restore when you
> upgrade the server
> Alan

No just using an earlier version of Firebird (version 0.9.4). I don't think
this is the problem we're having but I'm exploring different possibilities.

We were getting the error message 'unavailable database' (from an ISAPI web
server application).

We have put localhost: in front of the database path and we are now getting
an SQL error. Could the SQL error be due to using IBX components, now that
we are running Firebird 1.5?

The following error has occured:
Dynamic SQL Error
SQL error code = -104
Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause)

Note that we did not get this error before we updated to version 1.5 of
Firebird. Is version 1.5 of Firebird case sensitive with the SQL?