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