|
 |
asp_databases thread: Internal Server Error-HTTP-500.100
Message #1 by I.Bhanja@z... on Fri, 18 May 2001 12:04:41
|
|
Hi All,
I have written a simple code in asp file which retreives some records in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in the
team r getting the same problem. Do i need to change some setting in IIS
or change in code? please help.
Thanks
Ipsita
Message #2 by "Craig Flannigan" <ckf@k...> on Fri, 18 May 2001 12:59:12 +0100
|
|
Go into Internet Explorer > Internet Tools > Advanced, and switch off "Show
Friendly HTTP Errors."
That will then let you see the exact problem, and what line of ASP is
causing the problem.
Craig.
-----Original Message-----
From: I.Bhanja@z... [mailto:I.Bhanja@z...]
Sent: Friday 18 May 2001 12:05
To: ASP Databases
Subject: [asp_databases] Internal Server Error-HTTP-500.100
Hi All,
I have written a simple code in asp file which retreives some records in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in the
team r getting the same problem. Do i need to change some setting in IIS
or change in code? please help.
Thanks
Ipsita
Message #3 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Fri, 18 May 2001 14:16:17 +0200
|
|
Hi!
Just a guess: Does your folder settings allow scripts to be run? Did you put
your ASP pages in folders that has web sharing (ie within wwwroot or a
virtual path)?
If some of the above is not true I believe you get an error like you
describe, but I might be wrong.
Hth,
Hakan
-----Original Message-----
From: I.Bhanja@z... [mailto:I.Bhanja@z...]
Sent: den 18 maj 2001 12:05
To: ASP Databases
Subject: [asp_databases] Internal Server Error-HTTP-500.100
Hi All,
I have written a simple code in asp file which retreives some records in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in the
team r getting the same problem. Do i need to change some setting in IIS
or change in code? please help.
Thanks
Ipsita
Message #4 by Ipsita Bhanja <I.Bhanja@z...> on Fri, 18 May 2001 17:52:24 +0530
|
|
thanx.
now i m able to see detail error message but still not able to remove
it. i
m pasting the code and the error message here for reference.
**********************************
<%@ Language=3DVBScript %>
<% option explicit %>
<HTML>
<HEAD>
<META NAME=3D"GENERATOR" Content=3D"Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly=3D0
adLockReadOnly=3D1
adCmdTable=3D2
dim objConn, objRs
set objConn=3Dserver.CreateObject("ADODB.Connection")
set objRs=3Dserver.CreateObject("ADODB.Recordset")
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" "Data
Source=3DE:\Movie2000.mdb;" "Persist Security Info=3DFalse"
objRs.Open "Movies",objConn,adOpenForwardOnly,adLockReadOnly,adCmdTable
while not objRs.EOF
Response.Write objRs("Title") & "<BR>"
objRs.MoveNext
wend
objRs.Close
objConn.Close
set objRs=3DNothing
set objConn=3DNothing
%>
</BODY>
</HTML>
**************************
*************************
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
------------------------------------------------------------------------
----
----
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/asp_ips/Database.asp, line 19, column 49
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" "Data
Source=3DE:\Movie2000.mdb;" "Persist Security Info=3DFalse"
------------------------------------------------^
******************************************
any more suggestions and help?
thanks
ipsita
-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: Friday, May 18, 2001 5:29 PM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
Go into Internet Explorer > Internet Tools > Advanced, and switch off
"Show
Friendly HTTP Errors."
That will then let you see the exact problem, and what line of ASP is
causing the problem.
Craig.
-----Original Message-----
From: I.Bhanja@z... [mailto:I.Bhanja@z...]
Sent: Friday 18 May 2001 12:05
To: ASP Databases
Subject: [asp_databases] Internal Server Error-HTTP-500.100
Hi All,
I have written a simple code in asp file which retreives some records
in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in
the
team r getting the same problem. Do i need to change some setting in
IIS
or change in code? please help.
Thanks
Ipsita
Message #5 by "Daniel O'Dorisio" <dodorisio@h...> on Fri, 18 May 2001 08:52:20 -0400
|
|
your connection string should read:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\Movie2000.mdb; Persist
Security Info=False"
only " and " at the beginning and end of the conn string, not for each
option. also... you might want to consider putting this in a variable, it
will give you a performance advantage.
daniel
-----Original Message-----
From: Ipsita Bhanja [mailto:I.Bhanja@z...]
Sent: Friday, May 18, 2001 8:22 AM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
thanx.
now i m able to see detail error message but still not able to remove it. i
m pasting the code and the error message here for reference.
**********************************
<%@ Language=VBScript %>
<% option explicit %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly=0
adLockReadOnly=1
adCmdTable=2
dim objConn, objRs
set objConn=server.CreateObject("ADODB.Connection")
set objRs=server.CreateObject("ADODB.Recordset")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data
Source=E:\Movie2000.mdb;" "Persist Security Info=False"
objRs.Open "Movies",objConn,adOpenForwardOnly,adLockReadOnly,adCmdTable
while not objRs.EOF
Response.Write objRs("Title") & "<BR>"
objRs.MoveNext
wend
objRs.Close
objConn.Close
set objRs=Nothing
set objConn=Nothing
%>
</BODY>
</HTML>
**************************
*************************
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
----------------------------------------------------------------------------
----
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/asp_ips/Database.asp, line 19, column 49
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data
Source=E:\Movie2000.mdb;" "Persist Security Info=False"
------------------------------------------------^
******************************************
any more suggestions and help?
thanks
ipsita
-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: Friday, May 18, 2001 5:29 PM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
Go into Internet Explorer > Internet Tools > Advanced, and switch off "Show
Friendly HTTP Errors."
That will then let you see the exact problem, and what line of ASP is
causing the problem.
Craig.
-----Original Message-----
From: I.Bhanja@z... [mailto:I.Bhanja@z...]
Sent: Friday 18 May 2001 12:05
To: ASP Databases
Subject: [asp_databases] Internal Server Error-HTTP-500.100
Hi All,
I have written a simple code in asp file which retreives some records in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in the
team r getting the same problem. Do i need to change some setting in IIS
or change in code? please help.
Thanks
Ipsita
Message #6 by Ipsita Bhanja <I.Bhanja@z...> on Fri, 18 May 2001 18:33:47 +0530
|
|
Thanx a lot folks for your suggestions.
thanx
ipsita
-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Friday, May 18, 2001 6:22 PM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
your connection string should read:
"Provider=3DMicrosoft.Jet.OLEDB.4.0; Data Source=3DE:\Movie2000.mdb;
Persist
Security Info=3DFalse"
only " and " at the beginning and end of the conn string, not for each
option. also... you might want to consider putting this in a variable,
it
will give you a performance advantage.
daniel
-----Original Message-----
From: Ipsita Bhanja [mailto:I.Bhanja@z...]
Sent: Friday, May 18, 2001 8:22 AM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
thanx.
now i m able to see detail error message but still not able to remove
it. i
m pasting the code and the error message here for reference.
**********************************
<%@ Language=3DVBScript %>
<% option explicit %>
<HTML>
<HEAD>
<META NAME=3D"GENERATOR" Content=3D"Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly=3D0
adLockReadOnly=3D1
adCmdTable=3D2
dim objConn, objRs
set objConn=3Dserver.CreateObject("ADODB.Connection")
set objRs=3Dserver.CreateObject("ADODB.Recordset")
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" "Data
Source=3DE:\Movie2000.mdb;" "Persist Security Info=3DFalse"
objRs.Open "Movies",objConn,adOpenForwardOnly,adLockReadOnly,adCmdTable
while not objRs.EOF
Response.Write objRs("Title") & "<BR>"
objRs.MoveNext
wend
objRs.Close
objConn.Close
set objRs=3DNothing
set objConn=3DNothing
%>
</BODY>
</HTML>
**************************
*************************
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
------------------------------------------------------------------------
----
----
Technical Information (for support personnel)
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/asp_ips/Database.asp, line 19, column 49
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" "Data
Source=3DE:\Movie2000.mdb;" "Persist Security Info=3DFalse"
------------------------------------------------^
******************************************
any more suggestions and help?
thanks
ipsita
-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: Friday, May 18, 2001 5:29 PM
To: ASP Databases
Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
Go into Internet Explorer > Internet Tools > Advanced, and switch off
"Show
Friendly HTTP Errors."
That will then let you see the exact problem, and what line of ASP is
causing the problem.
Craig.
-----Original Message-----
From: I.Bhanja@z... [mailto:I.Bhanja@z...]
Sent: Friday 18 May 2001 12:05
To: ASP Databases
Subject: [asp_databases] Internal Server Error-HTTP-500.100
Hi All,
I have written a simple code in asp file which retreives some records
in
the database Movie2000.mdb saved in my E drive. I am getting the error
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services. I have IIS 5.0. All of the members in
the
team r getting the same problem. Do i need to change some setting in
IIS
or change in code? please help.
Thanks
Ipsita
Message #7 by "Charles Feduke" <webmaster@r...> on Fri, 18 May 2001 09:05:55 -0400
|
|
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data
> Source=E:\Movie2000.mdb;" "Persist Security Info=False"
This should all be one continous string:
objConn.Open
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=E:\Movie2000.mdb;Persist
Security Info=False"
? Chuck
> -----Original Message-----
> From: Ipsita Bhanja [mailto:I.Bhanja@z...]
> Sent: Friday, May 18, 2001 8:22 AM
> To: ASP Databases
> Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
>
>
> thanx.
> now i m able to see detail error message but still not able to
> remove it. i
> m pasting the code and the error message here for reference.
> **********************************
>
> <%@ Language=VBScript %>
> <% option explicit %>
> <HTML>
> <HEAD>
> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
> </HEAD>
> <BODY>
>
> <%
> dim adOpenForwardOnly, adLockReadOnly, adCmdTable
> adOpenForwardOnly=0
> adLockReadOnly=1
> adCmdTable=2
>
> dim objConn, objRs
> set objConn=server.CreateObject("ADODB.Connection")
> set objRs=server.CreateObject("ADODB.Recordset")
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data
> Source=E:\Movie2000.mdb;" "Persist Security Info=False"
> objRs.Open "Movies",objConn,adOpenForwardOnly,adLockReadOnly,adCmdTable
>
> while not objRs.EOF
> Response.Write objRs("Title") & "<BR>"
> objRs.MoveNext
> wend
>
> objRs.Close
> objConn.Close
> set objRs=Nothing
> set objConn=Nothing
> %>
>
> </BODY>
> </HTML>
> **************************
> *************************
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> ------------------------------------------------------------------
> ----------
> ----
>
> Technical Information (for support personnel)
>
> Error Type:
> Microsoft VBScript compilation (0x800A0401)
> Expected end of statement
> /asp_ips/Database.asp, line 19, column 49
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data
> Source=E:\Movie2000.mdb;" "Persist Security Info=False"
> ------------------------------------------------^
> ******************************************
> any more suggestions and help?
> thanks
> ipsita
>
> -----Original Message-----
> From: Craig Flannigan [mailto:ckf@k...]
> Sent: Friday, May 18, 2001 5:29 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Internal Server Error-HTTP-500.100
>
>
> Go into Internet Explorer > Internet Tools > Advanced, and switch
> off "Show
> Friendly HTTP Errors."
>
> That will then let you see the exact problem, and what line of ASP is
> causing the problem.
>
>
> Craig.
>
>
> -----Original Message-----
> From: I.Bhanja@z... [mailto:I.Bhanja@z...]
> Sent: Friday 18 May 2001 12:05
> To: ASP Databases
> Subject: [asp_databases] Internal Server Error-HTTP-500.100
>
>
> Hi All,
> I have written a simple code in asp file which retreives some records in
> the database Movie2000.mdb saved in my E drive. I am getting the error
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services. I have IIS 5.0. All of the members in the
> team r getting the same problem. Do i need to change some setting in IIS
> or change in code? please help.
> Thanks
> Ipsita
>
|
|
|
View Cart
