I&#039m getting an error (with not very helpful error message) on a new virtual host machine.<BR><BR>The script uses paging of results from an access database (from 4guysfromrolla.com) and works on our inhouse test server and another virtual server that we host sites on fine and dandy.<BR><BR>The error on the new machine is:-<BR><BR>error &#039 80040e21&#039<BR>/webfoot/firstchemist/health_tip.asp, line 167<BR><BR>And the code snippet is below....<BR><BR>Dim conn<BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>conn.Op en sDSN<BR><BR>&#039Explicitly Create a recordset object<BR>Dim rs<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR><BR>&#03 9Set the cursor location property<BR>rs.CursorLocation = adUseClient<BR><BR>&#039Set the cache size = to the # of records/page<BR>rs.CacheSize = NumPerPage<BR><BR>&#039Open our recordset<BR>Dim strSQL<BR>IF SOrder="Salpha" THEN<BR>strSQL = "SELECT * FROM NewsContents WHERE Category = &#039" & Cat & "&#039 ORDER BY Heading"<BR>END IF<BR><BR>IF SOrder="Sdate" THEN<BR>strSQL = "SELECT * FROM NewsContents WHERE Category = &#039" & Cat & "&#039 ORDER BY E_Date DESC, Heading"<BR>END IF<BR><BR>rs.Open strSQL, Conn &#039this line causes the error<BR><BR>I&#039ve done a search on 15Seconds and found a few messages with the same error on an "Update" process and two messages about an rs.open like this but with no solution.<BR><BR>All three servers have NT4, IIS4 up to the latest SP and I&#039ve verified that the ODBC driver is the same (version 3.51.102900) as our test server.<BR><BR>How do I check what version of CDO is on the servers? (I have console access to our test server only but could ask the virtual host admins to check)<BR><BR>Any and all replies welcome - I&#039m pulling my (not much left) hair out....<BR><BR>Cheers and TIGA (thanks in grateful advance)<BR>Russell<BR>mailto:rus@webfoot.co.nz<BR >-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*--*-*-<BR>From the Mail Program of:-<BR> R u s s e l l H o l l a n d<BR>WebFoot Publications Ltd & The Greenlight Web Company<BR>http://www.webfoot.co.nz & http://www.greenlight.co.nz<BR> Also http://www.soda.co.nz & http://www.wdnz.org.nz<BR> Ph 06 867 7660 Fax 06 867 7143 Shoe 025 422 599