>>>We only get this error when we pass a text file which is (171 MB) to a parameter of data type (TEXT)

What we did, is to pass the file in chunks rather than all at once. I got the idea from a CodeProject article (http://www.codeproject.com/KB/XML/MTOMWebServices.aspx), but this may not do much for you, as it's about web services and also about .NET.

But basically the idea is to break up the file into smaller chunks, and pass the chunks one at a time, then update the SQL Server table chunk-by-chunk, making use of SQL's .WRITE function:

UPDATE Attachmentdata SET content .WRITE( @content, NULL, 1 ) WHERE [attachmentdatakey] = @attachmentdatakey

Hope that helps some, hopefully you know or can figure out how to get the file into chunks to send it. I don't know off the top of my head how to do that in VFP (but I do have some C# code for doing it).

~~Bonnie