>I'm writing a record to sql server via vfp remotve view. I do a table update and next i want to get the primary key that sql server assigns. I'm getting the error message that it looses teh connection handle. it seems to timeout. What do I need to do?


Hi Jeff!

The VFP connection object's default timeout value is 15 seconds. This could be the culprit. Try setting the connction timout to a longer period, EX: SQLSETPROP(the.Handle, "ConnectTimeOut", nSeconds)
If nSeconds is 0, the connection never times out. Max Seconds is 600

Tom