In SQL Server 7, Why does :

recPg.setSQLText("select distinct * from whatsnew ORDER BY " + thisPage.getOrderBy2() )

give the error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/jprelec/_ScriptLibrary/Recordset.ASP, line 636

when:

recPg.setSQLText("select * from whatsnew ORDER BY " + thisPage.getOrderBy2() )

works absolutely fine ????

The ONLY difference is thge first statement has the DISTINCT clause in it

Help anyone please