Re: NewEra3.1 Connection to AccessDB

> We started working with Informix NewEra only a few weeks ago, trying to > get a connection to a Microsoft Access database via ODBC. > > At the moment we are able to connect to the database and READ the > records (which we inserted through MS Access directly). If we try to > insert new records via our NewEra application these records can only be > applied and retrieved temporarily. If we quit and restart the > application the records are no longer there (they are not written to the > database, as we can see if we inspect our tables using MS Access). > > We would like to know if anybody has already experienced the same > behaviour and could give us some advice. > > Rene van Luijt > University of Koblenz > docu@uni-koblenz.de > Rene, It sounds to be as though you are not COMMITing your Sql statements. You will need to call (if my memory serves me) VARIABLE anSqlStmnt = ixSQLStmnt etc etc etc..... ... ... CALL anSqlStmnt.commit() .... ... This will need to be called either after each SQL statment, or at the end of a group of statements. Note the this will close any open cursors. If you need more help contact me directly at: jamie@cim.co.uk Jamie