1) default connection have handle 0 (zero), for IDE are zero's attributes stored in registry. You can use SQLGETPROP(0,"attibute") and SQLSSETPROP(0,"attibute", newvalue) for puts and gets atrributes.

3) Connection is active at processing SQL commands.If you use asynchronous connection, the connection is busy when VFP do'nt return (sqlexec(), sqlmoreresult()) -2,-1(bugs) or 1 (ok). Zero detects running SQL command.

4) no, but you must define and set variable before calling parametrized view. Och, of course... If you use parametrized view, you call first SQLEXEC():

********************** SPT 
param=10
lcSQL="select field from table where field>?param"
=SQLEXEC(handle, lcSQL,"xxc")
?recc("xxc")
param=20
=SQLEXEC(handle,"","xxc")
?recc("xxc")

********************** RV
param=10
use rview
?recc("rview")
param=20
reuqery("rview")
?recc("rview")

5) IdleTimeout is the way, but I don't know what is this behavior compatible with pooling connection in ODBC layer.

MartinJ

>I've just started a new job and will be be working alot with an old version
>of MS SQL (6.5). The system is very slow and has a number of capacity issues. Any changes I make will have to be approved by the corporate IT department, so I expect some battles. My SQL experience is limited to MS SQL 2000 so I definately feel that I'm stepping back in time having to start working with verison 6.5.
>
>I know that each connection to the server takes resources. The main software that we use disconnects the user's from the SQL back-end after 10 minutes of non-use. This is done to conserve resources. You have to click on a "Reconnect" button before you can use the application again.
>
>My questions are these:
>1) What is the default "connection" behavior of a remote view created in VFP? I.E., does it keep a persistant connection to the server whenever the view is open (i.e., USEd) ?
>3) Or, is the connection only active when data is being pulled into a cursor?
>4) Does a parameterized view work the same or is there any difference between a non-parameterized view?
>5) If the connection is constant using a view, is there a way to cause it to disconnect after 10 minutes of use and offer a reconnect button if the connection has died, like the application we are using?
>
>Thanks,
>Robert Wright