HTTP 500 - Internal server error

[Moshe]

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

[Foo Man Chew]

Re: HTTP 500 - Internal server error

> 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*...

[Mosh]

Re: HTTP 500 - Internal server error

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" <foo@man.chew > wrote in message
news:%23avN$Aoy DHA.1616@TK2MSF TNGP11.phx.gbl. ..[color=blue][color=green]
> > HTTP 500 - Internal server error[/color]
>
> 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*...
>
>[/color]

[Mosh]

Re: HTTP 500 - Internal server error

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" <foo@man.chew > wrote in message
news:%23avN$Aoy DHA.1616@TK2MSF TNGP11.phx.gbl. ..[color=blue][color=green]
> > HTTP 500 - Internal server error[/color]
>
> 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*...
>
>[/color]

[Foo Man Chew]

Re: HTTP 500 - Internal server error

> 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
[color=blue]
> Request object error 'ASP 0107 : 80004005'
>
> Stack Overflow[/color]

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

[Egbert Nierop \(MVP for IIS\)]

Re: HTTP 500 - Internal server error

Another suggestion
use adLongVarChar for the Text data type..

"Foo Man Chew" <foo@man.chew > wrote in message
news:OnUKGwoyDH A.4064@tk2msftn gp13.phx.gbl...[color=blue][color=green]
> > objCMDUnitProfi le("@SCMCPICont ent") = ContentSent[/color]
>
> This is not how you pass values to parameters of the command object.
>[/color]

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[color=blue]
>[/color]

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}" -->
[color=blue][color=green]
> > Request object error 'ASP 0107 : 80004005'
> >
> > Stack Overflow[/color]
>
> http://support.microsoft.com/?id=260694
>[/color]

--
compatible web farm Session replacement for Asp and Asp.Net

http://www.nieropwebconsult.nl/asp_session_manager.htm