FIle upload trouble

[MDT_CMH]

I am using CFFILE to upload files to my server. Since upgrading to CF7 we are
unable to upload any file bigger than about 2MB. Before the upgrade there were
no issues. When we try to upload a larger file we get an HTTP_505 error. I
have looked all through the CF administration pages and can't find any settings
related to file upload size. Any help would be appreciated.

[A3gis]

Hi,
Havent used CF 7 yet saddly, however, this may be a caching issue - could be
worth checking the CFAdmin caching section (no idea what it's called in 7,
sorry!) and switch of trusted cache. Aside from that, it could be a header
issue with the uploading files.

Have you tried different file types as well as different sizes?

checked encoding settings on the upload form?

Cheers,
Aegis

[James@nps]

I need to upload many diffrent types of files into my mssql database (no I can
not save the file into a directory and just write the path to my db). All works
great for most files untill I try to upload a msword or pdf file with a table
in it. Here is the code and error.

code:
<cffile action="readBinary" file="#file.serverDirectory#\#file.serverFile#"
variable="myFile">

<cfquery name="insertFile" datasource="KFS">
INSERT INTO TestUpload(fileName, Type, fileData, Size)
VALUES(#cffile.serverFile#, #cffile.Type#, '#ToBase64(myFile)#',
#cffile.Size#)
</cfquery>

ERROR: Unclosed quotation mark before the character string

[James@nps]

I figured out this is a size issue, what is the best way to add large documents
to a mssql database? I have the database column set to "TEXT" I have tried
using the blob but it would not work for mssql. Any ideas for uploading larg
files?