That is all you need. I would open the debugger and set a breakpoint on when the value of this handle changes.
>Hi All,
>
>I have successfully connected to the SQL server and the handle value returned was 1. I used this handle value throughout my project. I set most of the tables updatable using (SQL pass through). In one form I have successfully updated the table and within the same form I called the second form. In the second form, I saved the data and I got not error message. After, I closed all the forms and try to browse my VFP cursor I got this message "Connection handle is invalid". When I viewed the data using the SQL enterprised manager the first table was updated, but the second data was empty. I thought you only need one connection handle throughout the project.
>
>Does anyone knows why "Connection handle is invalid"? Any help or suggestion is appreciated. Thanks
Mark McCasland
Midlothian, TX USA