What do you mean, "It's still 1"? Most likely it is just a variable that remain 1.

lnConnectionHandle=SQLSTRINGCONNECT(...)
=SQLDISCONNECT(0)
*now connection does not exist, and any sql command with it will fail.

You may check the connection with, say, this:

on error llerr=.t.
sqlexec(.....)
on error
if aerror(aa)>0
* error occurs
?aa[2]
endif
.....

>I'm opening a connection to SQL in VFP 9.
>
>SQLSTRINGCONNECT() is returning 1.
>
>Later, when I attempt to do a SQLEXEC(), I get "Connection Handle Is Invalid".
>
>It's still 1, so I'm not sure what's wrong.
>
>Anyone?