Re: URGENT!!!! Problem with ODBC Driver

Posted in 2000

Obnoxio The Clown — Thu, 13 Apr 2000 09:55:45 BST — source: Informix-list mailing list archive (1991-1998)

From: Paulo Amorim <pauloamorim@uol.com.br> > >I'm using an ODBC Informix driver to connect to an IDS 7.30 database. >The application is developed in Visual Basic using ASP code. > >When I try to use the cursor, I'm getting an error when I try to fetch >backwards the cursor position. No problems when I fetch forwards. The >error message is the following: > >"Microsoft OLE DB Provider for ODBC Drivers error '80040e24' The rowset >does not support fetching backwards" > >I'm writing above the code which is causing the error: > >s_Select = "Select * from movimentocx order by idmovimento" rs.Open >s_Select, Conn, 3, 3 >If Not rs.Bof or Not rs.Eof then > rs.Movefirst -- No problem > rs.MoveNext -- No problem > rs.MovePrevious -- Error > rs.MoveLast -- Causes an error too > Do while........... In the ODBC driver setup, there is a checkbox called Enable Scrollable Cursors... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com