>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?
If it's not broken, fix it until it is.
My Blog