URGENT!!!! Problem with ODBC Driver
Posted in 2000
Hi 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........... Hope somebody helps !!! Thanks in advance -- Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil Sent via Deja.com http://www.deja.com/ Before you buy.