>>>>>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"] .
>>>
>>
>>Can you post some code (your VFP code) so I will just try this here if I find huge file?
>>
>>>Yes,we have tried passing a zip file but no luck on that either , error is still ["Memory allocation failure" ]
>
>

>*------------------------------------------------------------
>Function SaveImage( l_ImagePath )
>*------------------------------------------------------------
>	
>	---l_ImagePath  = 'textFile.txt' use a file > 170 MB
>		
>	lcName = JUSTFNAME(l_ImagePath)  
>	lcType = JUSTEXT(l_ImagePath)	 
>
>	lcImage= FILETOSTR( l_ImagePath )
>
>	lcSqlCmd = [exec dbo.sproc_SaveImage ']    	+ lcName                          + [','] + ;
>				                        lcType + [', ?lcImage, ]
>
>
>	RetVal = SQLEXEC(this.ConNo, lcSqlCmd ,'tempFL') 
>	IF RetVal < 0
>				
>		private laError
>		=AERROR(laError)		
>			
>		this.RetMsg = laError(2)	--"Memory Allocation Failure"	
>	endif
>
>ENDFUNC
>

To use varbinary(max) did you try STRCONV(filetostr(l_ImagePath),13) && or 15 (not sure which one you need to try here).