sqldisconnect(gnconn) should clear the connection.
HTH
Jeff
>Using VFP6 SP4.
>
>In my application I connect to an Oracle data source. I use the following command to connect to the data source:
>
>gnconn = SQLCONNECT('mydatasource', 'userid', 'password')
>
>When testing my app, I start, stop and restart the APP in my command window serveral times. Our DBA says that my Oracle connections are adding up.
>
>I always CLEAR MEMORY before starting my APP. What else do I have to do to clear any open Oracle connections? Will restarting VFP clear these connections? Does CLEAR MEMORY clear these connections?
>
>Thanks,
>
>Jerryt
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com