>>>>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 )
*
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)
endif
ENDFUNC