I have an app that uses several handles to different SQL databases, this app has been working fine in VFP8 a long time.

I connect to the first database and get a handle with a value of 1.

In VFP9 after I connect to a second database, it may give me the handle value of 1 again. (I store the handles to separate global vars, the vars do not get touched). Now the both handles (which have the same value) are pointing to the second database. (I checked using sqlgetprop to get the connection string).

Alternately it may give me a handle with value 2 for the second handle, which looks valid, but when I use it, it's invalid.

Nothing fails if I use VFP8, or IF I RUN THE DEBUGGER in VFP9! I had to switch my client back to VFP8. They are using WIN 2000 and XP with same results. Server is SQL2000.

I searched but I could not tell if this has been reported. Thanks!