>I've got a VFP program which is installed at 2 separate community Mental Health Facilities. Recently, I added some ODBC connections to a special DBC set up to just handle the remote views to the SQL Anywhere files. I am getting lockups at 3 of the 5 workstations at one site, and no lockups (out of about 10 workstations that run it) at the other site.
>
>The facts:
>1. Sybase SQL Anywhere Database Engine Version 5.5.04 Build #1980
>2. The DBC was used prior to this last revision (of the VFP program) that I sent them. There were no problems prior to the latest revision.
>3. It appears to lock up every time it closes the connection (SELECT PATIENTS/USE) on any of the screens which use the DBC. I don't have the tables in the data environment because they might not use those tables (if they don't have the SQL Anywhere program, it doesn't attempt to use the files). So, in the Destroy method of the form, I have a
>IF USED('Patients')
> SELECT Patients
> USE
>ENDIF
>
>Any help would be appreciated.
>Joy Ruhe

Making any progress on this? I've got a (really) simple app. that dies when I try to disconnect from SQL Anywhere. I was originally using remote views but I was having problems with my app and the SQL Anywhere ODBC driver locking up when I tried closing the connection (like you're doing above).

So, I just switched to SQL Passthrough. I can open a connection, pull down the information w/o any problems at all. As soon as I try issuing the SQLDISCONNECT the application hangs. More specifically, it works the first time but hangs if I attempt to reestablish / disconnect again.

I've tried searching Sybase's web site for any info, updated drivers, etc. with no luck.

I'm really beginning to wonder about VFP's ODBC implementation. For a language that's supposed to be specifically geared to data access, I haven't been having much luck. This is the second time I've tried using an ODBC connection in VFP to access another system's data, and this is the second time I've run into major problems w/something that should be really easy. The first ODBC driver (not SQL Anywhere) completely killed VFP - it would bomb out immediately. I had to switch to Access. And now this. I think I'll try Access again - or maybe Visual Basic.

Sigh...(sorry, just venting)