Visual Basic - ODBC - Informix OnLine Qs.?

I currently connect to OnLine Dynamic Server from Visual Basic via Intersolv's Datadirect ODBC. Once the connection is made I keep running into what seems to be fairly simple problem to solve but have not yet come up with the right answer. The issue is that sometimes I am able to update a table and sometimes not. No one besides me accesses the table. The database is an ANSI compliant DB. Pseudo code of what I do in Visual Basic is ---------VB 4.0----------- Open Database Open Recordset Move first Set field name Update Table Commit workspace Close Recordset Close Database -------------------------- Performance also seems to be a problem. Updates are slow. On exiting my application window the OnLine database locks dont get released. They are released after I completely exit VB. I am running VB 4.0, Intersolv ODBC version 2.12 with I-Net. Any advice on data inserts, updates and ODBC interaction would be helpful. Feel free to mail an email to me/post to the newgroup, I will post a summary at a later date. Thanks Sham Vaidya smvaidya@auto.rockwell.com