Re: VB4 + ODBC questions please help

"Reijer Koopsen" <Reijer.Koopsen@TIP.NL> wrote: :I'm using VB4 with the informix(intersolv 2.5) ODBC driver and have the :following problems. First you might want to test a real ODBC driver like the one from OpenLink (www.openlinksw.com) or possibly from SCO (www.vision.sco.com). :1. After a lot of inserts and updates I get the error message :'No more cursors available' and i have to restart the application to get :rid of this ??? This may be releated to the database engine as well. There is a limit to how many cursors you can have at one time. I don't know the number, but it is probably also different depending on the version of Informix. I have had this type of problem in Informix 4GL, and solved it by using stored procedures. :2. In VB4 i use the remote data objects, I can not access LONG TEXT fields, :Oracle and MS SQL server can use the getchunk option. Informix does not :seem to accept that. I don't know about this. We haven't used blobs yet. :Anyone had simular prolems???? Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org