Hi, I am facing some problem using MYSQL..When I am listing the records I am getting the following error.. Microsoft Cursor Engine error '80004005' The data provider or other service returned an E_FAIL status. /keyknowledgev1.2/content/admin/productlist.asp, line 87 Line 87 Highlighted below The following is my code.. If Request.QueryString("NAV") = "" Then intPage = 1 Else intPage = Request.QueryString("NAV") End If Set RecSetProduct = Server.CreateObject("ADODB.RecordSet") CheckSql="select * from PRODUCTS order by TITLE" RecSetProduct.CursorLocation = 3 'adUseClient RecSetProduct.CursorType = 3 'adOpenStatic RecSetProduct.Open CheckSql, KeyConn RecSetProduct.PageSize = 10 RecSetProduct.CacheSize = RecSetProduct.PageSize intPageCount = RecSetProduct.PageCount intRecordCount = RecSetProduct.RecordCount If CInt(intPage) > CInt(intPageCount) Then intPage = intPageCount If CInt(intPage) <= 0 Then intPage = 1 If intRecordCount > 0 Then RecSetProduct.AbsolutePage = intPage intStart = RecSetProduct.AbsolutePosition If CInt(intPage) = CInt(intPageCount) Then intFinish = intRecordCount Else intFinish = intStart + (RecSetProduct.PageSize - 1) End if End If Thanks in Advance With Regards Siva Technical Manager 55 Greek Street London W1V 5LR Tel: +44 (0)20 7025 7200 Fax: +44 (0)20 7025 7201 Mob: 0777 361 807 http://www.terranovamedia.com [EMAIL PROTECTED] This electronic message (email) is intended only for the use of the individual or entity named above, and may contain information that is privileged, confidential and protected from disclosure under applicable law. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of terra nova media ltd. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or the taking of any action relative to its contents, is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone at 020 7025 7200 or by email. Please destroy all hard copies of this communication and delete it from all electronic files. Thank you. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php