> > 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)
> >
> certainly could be - let's see the SQL which raises this exception.
> Are you using the latest client library with your IIS server?
> Alan

Here is the SQL code. No error is returned if I remove the ORDER BY clause.

SELECT
B.REFERENCE_NUMBER AS REFERENCE_NUMBER,
B.ISBN AS ISBN,
B.TITLE AS TITLE,
B.YEAR_PUBLISHED,
B.EDITION,
B.COPY_NO,
B.FREQUENCY,
B.LAST_BORROWED,
B.LAST_RETURNED,
B.DATE_DUE_BACK,
B.AUTHOR_ID,
B.LOCATION_ID,
B.PUBLISHER_ID,
B.DEWEY_NO_ID,
B.IS_SHORT_LOAN
,A.NAME AS AUTHOR
FROM
BOOK B
,AUTHOR A
WHERE
B.IS_DELETED = 'F'

AND B.AUTHOR_ID = A.AUTHOR_ID
AND B.TITLE LIKE '%TEST%'
AND A.NAME LIKE '%TEST%'
ORDER BY
B.TITLE ASC,
A.NAME ASC