>I made a VFP6 DBC, created a remote view (using a connection string, no DSN) and opened the view. If I do a "close databases" at the command window, everything goes away. However, if I "close databases" after 20 minutes (presumably the Oracle connection has timed out), I get an ODBC-GUI error window that states "function cannot be performed". My workaround is to just issue the command again, and then everything closes properly - note that if I have 6 views, I get 6 errors.
>
>What would be the proper way to close this stuff?
>
>Thanks.
When you created the connection in the DBC, was the ConnectTimeOut property 0? Issue a DBGetProp('ConnectionName', 'Connection', 'ConnectTimeOut') to see what it is set to. If not 0 [which is wait indefinitely], issue DBSetProp('ConnectionName', 'Connection', 'ConnectTimeOut', 0).
Also make sure the connection used by the views has the ShareConnection property set to true. Use CursorGetProp() and CursorSetProp() to fix any problems there.
Second, I would issue a CLOSE TABLES ALL instead of CLOSE DATABASES.
Mark McCasland
Midlothian, TX USA