Interesting enough, this is updating a view. There is a connection handle to the same db that gets opened up before this.

it does a sqlconnect with connection string:
DRIVER=SQL Server;SERVER=forteSQL;UID=sa;PWD=pacer;APP=Lifetrac;WSID=BOBO;DATABASE=Lifetrac;Network=DBMSSOCN;Address=fortesql

this is successful

I just copied the entire application folder (exe, dbc, etc) to computer 2 from computer 3. It is working without errors

>>The error is:Connection handle is invalid. (error 1466)
>>
>>what could be configured differently on that computer that the others that would be causeing this?
>>
>>
>
>Where do you create a connection? Could it be that the connection timed out and became invalid?