Re: Cursors and ODBC

Posted in 1998

Alberto Guerrieri — 11 Feb 1998 08:54:57 GMT — source: Informix-list mailing list archive (1991-1998)

Fuzzy <granta@nospam.student.canberra.edu.au> scritto nell'articolo <34e13ad2.33411423@newshost.interact.net.au>... > Hi people, > > Recently, I've been getting the following errors after issuing some > batches of statements via an ODBC connection: > > Error State: S1000 (0) > Error: Intersolve [ODBC Informix Driver] No More Cursors Available. > > Two questions from this are: Is there some way of finding the maximum > number of open cursors allowed, and is a parameter I can set (in > onconfig for example) that will up this number? > > I've browsed the ONCONFIG file, and looked at the manuals, but don't > see anything regarding configuring this. > > Ciao > Fuzzy > :-) > Hi, this is a known bug with the INTERSOLV ODBC drivers ver. 2. In fact ODBC driver imposes a limit of 255 statement. When attempting 256TH sqlprepare statement it reports 'No more cursors available'. I don't know if this bug is solved with ver.3 of the INTERSOLV ODBC driver. Regards, Alberto Guerrieri Tech. Supp. Center STRHOLD Sistemi EDP E-mail: alberto@strhold.it