I have a prg that uploads a 144MB txt file to a SQL [Text] field. (Look Below)
When I execute this PRG only...its fine...but when I call it from another prg

I get error "ODBC SQL Server Driver: Timeout expired" when TABLEUPDATE executes.....Any ideas?

l_ImagePath = 'C:\MyFile.txt'

CREATE CONNECTION conn1 CONNSTRING [driver=sql server;server=MyServer;database=MyDb;uid=userid;pwd=pass]

myconn=SQLCONNECT('conn1')

SQLSETPROP(myconn,'QueryTimeOut',0)

CREATE SQL VIEW myView REMOTE CONNECTION conn1 AS SELECT *;
FROM dbo.TableFL

DBSetProp("myView","View","SendUpdates",.T.) ,etc..........

DBSetProp("myView"+".image","Field","DataType","M")
DBSetProp("myView"+".image","Field","UpdateName","dbo.TableFL.image")
DBSetProp("myView"+".image","Field","KeyField",.F.)
DBSetProp("myView"+".image","Field","Updatable",.T.)

APPEND BLANK
APPEND MEMO image   FROM &l_ImagePath
 
TABLEUPDATE(.T.,.T.)