Support forums

Live Support, Chat and HTML Editor

Welcome to Support forums Sign in | Join | Help

Support forums » Products » Cute Editor for .NET » Re: How to store attachments in SQL Database

How to store attachments in SQL Database

Last post 07-10-2007, 9:10 AM by Kai2. 18 replies.

Page 2 of 2 (19 items) < Previous 1 2
	Sort Posts: Previous Next

07-03-2007, 3:18 AM 31224 in reply to 31051

Kai2
Joined on 02-27-2007
Posts 42

Re: How to store attachments in SQL Database

Reply Quote

Hi Adam,

just tried again: As soon as I take away access rights of "Everyone" for "C:\Windows\Temp" I get the above mentioned error ("Access to the path "C:\Windows\Temp" is denied"). I've added this line in my web.config appSettings
<add key="CuteEditorTempPath" value="~/CuteEditorTemp" />

.net Framework 2.0 / ASP.net / VB / CuteEditor 6.0 / SQL 2000 / IE 6 & FF 2

07-03-2007, 10:27 AM 31239 in reply to 31051

Adam
Joined on 09-23-2003
Aurora, ON
Posts 14,151

Re: How to store attachments in SQL Database

Reply Quote

Kai2:
Hi Adam,

thanks for your help. Unfortunately it's still the same error, Access denied to C:\Windows\Temp. Seems CE did not recognize my new settings in web.config. (I've added <add key="CuteEditorTempPath" value="~/CuteEditorTemp" /> to the AppSettings-Section).

Additionally sometimes I get an "Unknown Error - maybe the file is too large!". I tried to upload a 5 MB exe-File. I have a 10 MB limit and exe is allowed (otherwise I got the unallowed file error message). This error also appeared before so it has nothing to do with the access denied error.

Within the project I've migrated from 5.2 to 6.0, maybe there is still some old config somewhere?

Thanks
Kai

Kai,

You can set up Web.config to allow uploading of large files by ASP .NET applications.

By default, Machine.config is configured to accept HTTP Requests upto 4096 KB (4 MB) and it is reflected in all your ASP.NET applications. You can change the Machine.config file directly, or you can change only the Web.config file of the application(s) you want to.

Open your Web.config file, and just below the <system.web> tag, add the following tag:

<httpRuntime
executionTimeout="120"
maxRequestLength="4096"
useFullyQualifiedRedirectUrl="false"
minFreeThreads="8"
minLocalRequestFreeThreads="4"
appRequestQueueLimit="100"
enableVersionHeader="true"
/>

Now, just take a look at the maxRequestLength="4096" attribute of the <httpRuntime> tag. As you may have realized, all you need to do is change the value to some other value of your choice (8192 for 8 Mb, 16384 for 16 Mb, 65536 for 64 Mb, and so on...).

asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx

07-04-2007, 2:03 AM 31261 in reply to 31239

Kai2
Joined on 02-27-2007
Posts 42

Re: How to store attachments in SQL Database

Reply Quote

Hi Adam,

thanks for the snippet, that fixed it. I've successfully uploaded a 8 MB attachment. Thanks!

So now the only problem is the access for "Everyone" to C:\Windows\Temp. Do you also have any idea for that?

Many thanks
Kai

.net Framework 2.0 / ASP.net / VB / CuteEditor 6.0 / SQL 2000 / IE 6 & FF 2

07-10-2007, 9:10 AM 31438 in reply to 31261

Kai2
Joined on 02-27-2007
Posts 42

Re: How to store attachments in SQL Database

Reply Quote

Hi all,

last week we put the application to our test server and there it's the same result. Any ideas?

Thanks
Kai

.net Framework 2.0 / ASP.net / VB / CuteEditor 6.0 / SQL 2000 / IE 6 & FF 2

Page 2 of 2 (19 items) < Previous 1 2