>>In foxpro, we get error ["ODBC SQL Server Driver] Memory allocation failure" when making a connection to SQL Server 2005.
>>
>>We only get this error when we pass a text file which is (171 MB) to a parameter of data type (TEXT)
>>
>>If the text file is smaller then we dont have a problem.
>>
>>Our SQL Server 2005 is on WIN Server 2003.
>
>Do you have the same error if you use varbinary(max) type instead of the text?
>
>Also, may be you can save the files zipped?


With varbinary(max) we get error ["Operand type clash: text is incompatible with varbinary"] .

Yes,we have tried passing a zip file but no luck on that either , error is still ["Memory allocation failure" ]