Since the view is part of your database (and there is a create connection to the odbc datasource) I would guess that you have to either explictly close the connection, or you have to close the database to close the connection.
>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,
--Todd Sherman
-Wake Up! Smell the Coffee!