Date:  04/20/2010 03:16:51 PM Msg ID:  004164
From:  Randy Byers Thread:  004164
Subject:  open connections to MS-SQL server
Hello,
 
All of our foxweb scripts use a back-end MS-SQL database for data storage.
 
Typical usage looks like this:
 
----------------- 
m_handle = SQLCONNECT(t_db,t_u,t_pw)
 
m_query = 'select field-list from tablename' 
m_retcode=sqlexec(m_handle,m_query,"cursor10") 
select cursor10
 
** do stuff with data in cursor 
 
=SQLDISCONNECT(m_handle)
----------------- 
 
 
We have a busy environment with many users and hundreds of different scripts (and multiple foxweb servers).  
Our issue is that over time, we see a gradual growth in the number of "open" connections to the MS-SQL server from our foxweb server(s).  The majority of these connections are in a "sleeping" state (according to MS-SQL).
 
The Foxweb option named "Close Tables" is enabled. 
 
The issue is that once the number of "open/sleeping" connections to MS-SQL increases to 200 or more, we start to have stability issues with our Foxweb server(s).
 
I'm wondering if there are other Foxpro commands I can run in an attempt to "clean up" open/stale/sleeping connections which are left over by my scripts.
 
For example, can I safely call "close databases [all]" ?
 
Can I safely call "close tables [all]" ?
 
Do you know if there is anything else I can do to close/kill connections to the MS-SQL server from within Foxpro?
 
Thanks

Randy