Subject | RE: [firebird-support] Update database to new version? |
---|---|
Author | Alan McDonald |
Post date | 2004-07-26T12:53:14Z |
> We were getting the error message 'unavailable database' (from ancertainly could be - let's see the SQL which raises this exception.
> 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
Are you using the latest client library with your IIS server?
Alan