Problem with sorting of search results (IIS 6.0)

Hello all,

i've a problem after our OS Update from W2000 Server with IIS? to Server
2003 with IIS 6.0.

I'm querying index server with asp. Before the update everything works fine.
After migration to Server 2003 the serach results are OK, but it's not
possible to sort the results in result.asp.

The following error appears after trying to sort
CreateRecordset error '80004005'

Unspecified error

/result.asp, line 81

This is the link for this sort:
http://server/result.asp?query=testing&maxrecords=0&documenttype=*&sort=size&order=a


line 81 is: set objRS = objQuery.CreateRecordset("nonsequential")

this is the code of sort function:

echo "Es wurden <b>" & objRS.RecordCount & "</b> Dokumente für <b> """ &
Query & """</b> gefunden.<br>"
echo "<hr>"
echo "<table width=900 ><tr bgcolor=#CCCCCC>"
strA = "<a href=""result.asp?query=" & query & "&maxrecords=" & maxrecords
& "&documenttype=" & documenttype & "&sort="
echo "<th width=300 nowrap align=left>" & strA & "name&order=a""> â??</a>
Dateiname " & strA & "name&order=d""> â?? </a></th>"
echo "<th width=100 nowrap align=left>" & strA & "size&order=a""> â??</a>
GröÃ?e " & strA & "size&order=d""> â?? </a></th>"
echo "<th width=155 nowrap align=left>" & strA & "date&order=a""> â??</a>
Letzte Ã?nderung " & strA & "date&order=d""> â?? </a></th>"


With the old IIS there were no problems.

Thanks in advanced

Thomas

tbk123
Mon Jul 31 05:21:02 CDT 2006

Hello once more,

the normal search request (asp site too) works fine.
So i'm excluding problems with permission.

Any idea what's the problem.



"tbk123" wrote:

> Hello all,
>
> i've a problem after our OS Update from W2000 Server with IIS? to Server
> 2003 with IIS 6.0.
>
> I'm querying index server with asp. Before the update everything works fine.
> After migration to Server 2003 the serach results are OK, but it's not
> possible to sort the results in result.asp.
>
> The following error appears after trying to sort
> CreateRecordset error '80004005'
>
> Unspecified error
>
> /result.asp, line 81
>
> This is the link for this sort:
> http://server/result.asp?query=testing&maxrecords=0&documenttype=*&sort=size&order=a
>
>
> line 81 is: set objRS = objQuery.CreateRecordset("nonsequential")
>
> this is the code of sort function:
>
> echo "Es wurden <b>" & objRS.RecordCount & "</b> Dokumente für <b> """ &
> Query & """</b> gefunden.<br>"
> echo "<hr>"
> echo "<table width=900 ><tr bgcolor=#CCCCCC>"
> strA = "<a href=""result.asp?query=" & query & "&maxrecords=" & maxrecords
> & "&documenttype=" & documenttype & "&sort="
> echo "<th width=300 nowrap align=left>" & strA & "name&order=a""> â??</a>
> Dateiname " & strA & "name&order=d""> â?? </a></th>"
> echo "<th width=100 nowrap align=left>" & strA & "size&order=a""> â??</a>
> GröÃ?e " & strA & "size&order=d""> â?? </a></th>"
> echo "<th width=155 nowrap align=left>" & strA & "date&order=a""> â??</a>
> Letzte Ã?nderung " & strA & "date&order=d""> â?? </a></th>"
>
>
> With the old IIS there were no problems.
>
> Thanks in advanced
>
> Thomas
>