Subject RE: [firebird-support] Update database to new version?
Author Alan McDonald
> 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?
>
> Error:
> 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?
>
> Thanks,
> Stephen

certainly could be - let's see the SQL which raises this exception.
Are you using the latest client library with your IIS server?
Alan