I've got a small app whose only job is to open an ODBC connection (via a view) to a SQL Anywhere database. It reads a bit of information, saves it out to a file, then exits. The problem I seem to be having is that the ODBC connection is staying opening after I close the view. The code is pretty simple:

USE v_newinfo
=REQUERY()

* Write to a file

USE

That's it. Since the ODBC connection stays open, VFP can't close. It seems to start up another "window" when the view is opened (EXE). Then, of course, the next time it runs it fails completely. Anyone have any experience with this driver? Am I just missing some simple way of forcing this ODBC connection closed?

Thanks,