Hi,

This returns ---- " Unable to retrieve specific error information. Driver is probably out of resources "

Run this code in the debugger

close tables all
set multilocks on
cursorsetprop("buffering",5,0)
SQLSetProp(0,"DispLogin" ,3)
SQLSetProp(0,"DispWarnings" ,.f.)

*  han = sqlconnect("mydsn","sa","")  && get a valid connection
SQLExec(han,"use pubs")
SQLExec(han,"select * from authors","authors")
SQLIdleDisconnect(han)

Set step on

*** stop the Ms-Sql Server

=CURSORSETPROP("Tables", "authors")
=CURSORSETPROP("UpdateNameList", "au_id authors.au_id, au_lname;
       authors.au_lname, au_fname authors.au_fname, phone;
       authors.phone, address authors.address,;
       city authors.city, state authors.state,;
       zip authors.zip, contract authors.contract")
=CURSORSETPROP("KeyFieldList", "au_id")
=CURSORSETPROP("UpdatableFieldList", "au_lname, au_fname, phone,;
       address, city, state, zip, contract")
=CURSORSETPROP("SendUpdates", .T.)
Browse && modify 
=TableUpdate(2,.t.,"authors")
aerror(ae_authors)
Display memory like ae_authors

Wouldnt It be better if there is a better discription of the error ??

Also If run without using sqlidledisconnect() returns "[Microsoft][ODBC SQL Server Driver]Communication link failure"

Whereas in Vfp6 there was more detailed discription of the error ...

Would the VFPT consider this please ?

Suhas.