General information
Title:
Connection Busy Problem
Environment versions
Network:
Windows 2000 Server
Hi there,
I have a customer form that uses a connection to sql server to get information. So initially I run the customer form, it makes calls to sql server but since it's the initial run the where clauses of the data calls have WHERE 1=2, so they return empty cursors. The connection is shared by the way and I have the connection setup for Asynchroneous = .F.
Now on this form I have a search button that calls another form (search form) to search for a particular customer. When this search form is called, it starts making it's own data calls to sql server. I have a function to check if the connection is busy and many times it comes back as being busy. When it's busy, if I leave it in a loop checking to see if it's still busy it just goes into an endless loop (always busy), even though the queries on the other form are done and there's no select query that takes a long time anyways. If I put a SET STEP ON when it detects the busy connection and then I resume the processing the connection is not busy anymore.
Any ideas?
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only