473,573 Members | 2,908 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HTTP 500 - Internal server error

Scenario -
IIS 5.0 WIN2K latest SP
Application ASP.
An ASP Page has a text area. When submitted calls SQL server 2K Stored
Procedure to update a record. The field in the data base is of type
Text.
When posting from the browser a text that is less then about 100K, no
errors. When posting more the 100K
HTTP 500 - Internal server error
Tracing the database - the call to SP was not yet executed.

Why is failing with this error? How can I trouble shoot it? Any
limitation in size when posting fields from the client to server?

Thanks,
Moshe
Jul 19 '05 #1
5 10537
> HTTP 500 - Internal server error

Fix your browser, and then you can tell us what message ASP is sending.
Tools / Internet Options / Advanced, "Show friendly HTTP errors" should be
*unchecked*...
Jul 19 '05 #2
The fisrt error I got was

error '80020009'
Exception occurred.

/Content/scm/SCMContentProfi leInformtion.as p, line 100

I am not sure is line 100 is the right one as there is an #include before
that. If it is then it is on
If Trim(Request.Fo rm("Content")) ="" Then Where Content is the field with
the large text.
Once commented out I received:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/Content/scm/SCMContentProfi leInformtion.as p, line 144

Again if the line number is correct, then it is on:
objCMDUnitProfi le("@SCMCPICont ent")=Request.F orm("Content")
The Stored Procedure shows:
@SCMCPIContent text,

Any idea?

Thanks,
Moshe

"Foo Man Chew" <fo*@man.chew > wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
HTTP 500 - Internal server error


Fix your browser, and then you can tell us what message ASP is sending.
Tools / Internet Options / Advanced, "Show friendly HTTP errors" should be
*unchecked*...

Jul 19 '05 #3
I tried the following:
Dim ContentSent
ContentSent = space(200000)
and then
ContentSent = Request.Form("C ontent")
objCMDUnitProfi le("@SCMCPICont ent")= ContentSent

I tried to save a little long text and it was successful.

Then I "posted" even longer text and a new error

Request object error 'ASP 0107 : 80004005'

Stack Overflow

/Content/scm/SCMContentProfi leInformtion.as p, line 145

The data being processed is over the allowed limit.

and this is on the ContentSent = Request.Form("C ontent") line

Now with this error I understand that ASP form limits are around 101K.

What are my choices? Do i have then to go to upload file and take data from
there and store in the database? Other options?

Thanks,

Moshe

"Foo Man Chew" <fo*@man.chew > wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
HTTP 500 - Internal server error


Fix your browser, and then you can tell us what message ASP is sending.
Tools / Internet Options / Advanced, "Show friendly HTTP errors" should be
*unchecked*...

Jul 19 '05 #4
> objCMDUnitProfi le("@SCMCPICont ent") = ContentSent

This is not how you pass values to parameters of the command object.

Set cmd = CreateObject("A DODB.Command")
With cmd
.CommandText = "INSERT table(column) values(?)"
.CommandType = adCmdText
.ActiveConnecti on = objConn
.Parameters.App end .CreateParamete r ("@SCMCPIConten t", adVarChar,
adParamInput, 8000, ContentSent)
.Execute
Set .ActiveConnecti on = Nothing
End With
Set cmd = Nothing
Request object error 'ASP 0107 : 80004005'

Stack Overflow


http://support.microsoft.com/?id=260694
Jul 19 '05 #5
Another suggestion
use adLongVarChar for the Text data type..

"Foo Man Chew" <fo*@man.chew > wrote in message
news:On******** ******@tk2msftn gp13.phx.gbl...
objCMDUnitProfi le("@SCMCPICont ent") = ContentSent
This is not how you pass values to parameters of the command object.


Set cmd = CreateObject("A DODB.Command")
With cmd
.CommandText = "INSERT table(column) values(?)"
.CommandType = adCmdText
SET .ActiveConnecti on = objConn
.Parameters.App end .CreateParamete r ("@SCMCPIConten t", adLongVarChar,
adParamInput, Len(ContentSent ), ContentSent)
.Execute
Set .ActiveConnecti on = Nothing
End With
Set cmd = Nothing


Do not forget to add the constants to global.asa
<!-- METADATA NAME="Microsoft ActiveX Data Objects 2.5 Library"
TYPE="TypeLib"
UUID="{00000205-0000-0010-8000-00AA006D2EA4}" -->
Request object error 'ASP 0107 : 80004005'

Stack Overflow


http://support.microsoft.com/?id=260694


--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
5435
by: Ralph | last post by:
HTTP 500 - Internal server error ASP pages I am running Windows 2K with IIS 5.1 and I started having problems accessing ASP databases shortly after applying the MS patch Windows 2000 Hotfix KB824146. I also started getting DCOM errors in the Server System log just after the reboot. When anyone goes to open an ASP based page they get :...
10
10800
by: | last post by:
I am accessing the same error-containing ASP page on an ISP server using w2k IE6 but with different effect. On the first computer I get several line of HTML outputed by ASP, shown correctly by the browser, followed by a descriptive error message: Microsoft VBScript runtime error '800a000b' Division by zero followed by the number of the...
1
1828
by: weiwei | last post by:
Hi, I am having trouble with http 500 internal error. I have develope several dynamic pages, it works fine on our intranet server, however, when I migrated into our external IIS server, most of asp pages cann't display with error message of http 500 internal error does anyone have idea on what is going on? please any ideas or clues are...
2
3223
by: Anton van der Merwe | last post by:
I'm getting the foolowing error when trying to view an asp page on a windows2003 server. On our previous IIS server (Windows 2000) the error was described in detail. Windows 2003 ------------ The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed.
1
5100
by: errorQuest | last post by:
Hi There, I have a problem with the IIS running. Whenever I try to ru http://localhost/aaa.asp i got this error "HTTP 500-Internal Serve Error". I use very simple code in aaa.asp. I try to look for the Sho Friendly http error messages, but it doesn't give me another othe error beside "HTTP 500-Internal Server Error". Does anyone know what...
1
1943
by: vighneswar | last post by:
Hi All I am working on a project in which i have to upload files to an remote server via HTTPS. For that i have written the following lines of code,but when i execute it I am getting an HTTP:500 Internal Server Error.Please let me know where went wrong in it. 1.The client has given the credentials(username & password) using those i got...
9
3914
by: Trint Smith | last post by:
I have tried everything...aspreg -i and modifying machine.config and running the fileupdate...deleting and reinstalling framework 1.1... It only happens when I do a 'Copy Project' to the webserver...it loads into vs.net and runs locally just fine... Any help is appreciated...I'd like to get rid of this forever...I had this problem on a...
8
9995
by: Rod | last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some reason, opening some ASP.NET applications we wrote is producing the following error message: "The Web server reported the following error when attempting to create or open the Web project located at the following URL: 'http://localhost/WebApplication1'. 'HTTP/1.1 500...
11
12301
by: Lieven | last post by:
Hey, I had a hard disc problem last week on my server. I replaced the disc and copied al the files to the new hard disc, everything works fine again except some php scripts that are using the mail() function. When executing these scripts I get this error: "500 Internal Server Error The server encountered an internal error or...
16
27877
Frinavale
by: Frinavale | last post by:
The following article is directed at people who are experiencing an HTTP/1.1 500 Internal Server Error while using Visual Studio 2003. The error message typically sounds something like: The web server reported the following error when attempting to create or open the Web Project located at the Following...
0
7755
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7679
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7992
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8190
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7756
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5571
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3722
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3722
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1284
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.