Accessing an Informix Database using ODBC

Hi all, I'm using a Openlink ODBC Driver to access an Informix Database from VB (RDO connection). The connection is ok, but when I create a resultset, only the first 100 records are retrieved. I am doing a loop and when I execute the command "movenext" (101' record) I have a message that the "cursor is not open". Can you help me ? Is this a driver problem or exists any configuration on my Informix Server that can limit the number of records ? My RDO connection is very simple, ie is the most usual connection when I access Oracle, SQL Server, etc. I create an data source name (ODBC) and I use it to make a connection. Thanks, Fred. Sent via Deja.com http://www.deja.com/

The default Cursor Behavior is 0 - Close, change this in the ODBC Driver Setup to 1 - Preserve. Erickson In article <91qnqv$8ad$1@nnrp1.deja.com>, fredsonbs@my-deja.com wrote: > Hi all, > > I'm using a Openlink ODBC Driver to access an Informix Database from VB > (RDO connection). > > The connection is ok, but when I create a resultset, only the first 100 > records are retrieved. I am doing a loop and when I execute > the command "movenext" (101' record) I have a message that the "cursor > is not open". > > Can you help me ? Is this a driver problem or exists any configuration > on my Informix Server that can limit the number of records ? > > My RDO connection is very simple, ie is the most usual connection when > I access Oracle, SQL Server, etc. I create an data source name (ODBC) > and I use it to make a connection. > > Thanks, > > Fred. > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/