When you get the error, suspend the program, and try using SQLEXEC() and your connection handle to submit any SQL to SQL Server to see what you get back. Something like:
SELECT COUNT(*) FROM Some_Table
If you get an error [a negative return value], see what AERROR() returns. I am wondering if your intermitent SQLCONNECT() problem is haunting you in other ways as well.
>Hello again Mark,
>
>This is getting to be a habit.
>
>The CaClass (from the CABuilder) I am using has properties set:
>DataSource: =glo_numMyHandle
>DataSourceType: ODBC
>
>The DEClass has the above CA object in it. The DEClass has properties set:
>
DataSource: =glo_numMyHandle
>DataSourceType: ODBC
>
>When I run the form, I still get 'unbinding' and the error is 'Connection Handle Invalid'. So, now I am still stuck.. lol
>
>R
Mark McCasland
Midlothian, TX USA