Ask a Question related to ASP Database, Design and Development.
-
Jacques Koorts #1
HTTP 500.100 I don't know anymore
Hi
I really don't know anymore how to solve this problem. I bought .NET
thinking i can debug my way out of it but still no cigar.
This very simple piece of code does not work:
Now here some things before looking at the code:
1. In .NET and IE and IIS I've set all possible debugging options
2. I've set a watch at the beginning of this page, so that when .NET
enters this page I can step the program
3. If I have the line: set test = cnn.Execute("INSERT INTO comments
('ghj', 'comment', 67)) in this code then .NET does not even let me step
throught the program. It just immediatly give the error below.
4. If I have the line: cnn.Execute("INSERT INTO comments ('ghj',
'comment', 67)) in this code then .NET does not even let me step throught
the program. It just immediatly give the error below.
5. I know I should not use c:\events.mdb but this was only a test.
6. with the cnn.Execute line ommited, the thing steps through the code
but ofcourse does not work.
7. I know I can use the long way getting the data in the database, but
damit I want to do it this way!
<code>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>myweb</title>
</head>
<body>
<%
Dim cnn
Dim strDBPath
dim test
Set cnn = Server.CreateObject("ADODB.Connection")
strDBPath = "c:\events.mdb"
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
cnn.Open
set test = cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67))
%>
</body>
</html>
I get the error:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
--------------------------------------------------------------------------
Please try the following:
a.. Click the Refresh button, or try again later.
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
If anyone can help me here I'd really be a happier guy.
Jacques Koorts Guest
-
Send Basic HTTP authentication credential in the first HTTP request
Hello, How can I make the web service proxy class send basic authentication information in the HTTP header of the first request? My... -
AI CS won't open anymore!
I've had the same problem has Tom, but it reappears every time I restart my computer. I trash the prefs, start Illustrator, everything is fine. BUT,... -
#19113 [Com]: HTTP status 200 returned on HTTP CONNECT when mod_proxy not in use
ID: 19113 Comment by: arafuse at bcexplorers dot com Reported By: php_new at jdc dot parodius dot com Status: ... -
HTTP::Request failed on HTTP/1.1 and Connection: Keep-Alive
Hi Abigail, I know that the error comes from the Java program, the nullpointer error. But what it confused me is: if I'm using an Internet Explorer... -
XP won't start anymore
After using Windows XP Pro mainly trouble-free for the last 5 months, it now won't start at all. The first time it happened it went from the... -
Chris Barber #2 Re: HTTP 500.100 I don't know anymore
cnn.Execute "INSERT INTO comments ('ghj', 'comment', 67)"
Try with no parentheses since you aren't assigning a return value
And .. there is something seriously wrong with your setup if it won't report the real error for this
line - how and against what are you debugging? Are you doing remote debugging against a remote
server or against you local IIS in 'local' mode? What error trapping are you using? Is it an ASP or
ASPX file?
Chris.
"Jacques Koorts" <jkoorts@myrealbox.com> wrote in message news:10dcb2611aockd7@corp.supernews.com...
Hi
I really don't know anymore how to solve this problem. I bought .NET
thinking i can debug my way out of it but still no cigar.
This very simple piece of code does not work:
Now here some things before looking at the code:
1. In .NET and IE and IIS I've set all possible debugging options
2. I've set a watch at the beginning of this page, so that when .NET
enters this page I can step the program
3. If I have the line: set test = cnn.Execute("INSERT INTO comments
('ghj', 'comment', 67)) in this code then .NET does not even let me step
throught the program. It just immediatly give the error below.
4. If I have the line: cnn.Execute("INSERT INTO comments ('ghj',
'comment', 67)) in this code then .NET does not even let me step throught
the program. It just immediatly give the error below.
5. I know I should not use c:\events.mdb but this was only a test.
6. with the cnn.Execute line ommited, the thing steps through the code
but ofcourse does not work.
7. I know I can use the long way getting the data in the database, but
damit I want to do it this way!
<code>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>myweb</title>
</head>
<body>
<%
Dim cnn
Dim strDBPath
dim test
Set cnn = Server.CreateObject("ADODB.Connection")
strDBPath = "c:\events.mdb"
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
cnn.Open
set test = cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67))
%>
</body>
</html>
I get the error:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
--------------------------------------------------------------------------
Please try the following:
a.. Click the Refresh button, or try again later.
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
If anyone can help me here I'd really be a happier guy.
Chris Barber Guest
-
Chris Barber #3 Re: HTTP 500.100 I don't know anymore
Sorry, I take that back - you are assigning a return variable - it's late here.
However, a INSERT command doesn't return anything so you should probably drop the assignment anyway.
Chris.
"Jacques Koorts" <jkoorts@myrealbox.com> wrote in message news:10dcb2611aockd7@corp.supernews.com...
Hi
I really don't know anymore how to solve this problem. I bought .NET
thinking i can debug my way out of it but still no cigar.
This very simple piece of code does not work:
Now here some things before looking at the code:
1. In .NET and IE and IIS I've set all possible debugging options
2. I've set a watch at the beginning of this page, so that when .NET
enters this page I can step the program
3. If I have the line: set test = cnn.Execute("INSERT INTO comments
('ghj', 'comment', 67)) in this code then .NET does not even let me step
throught the program. It just immediatly give the error below.
4. If I have the line: cnn.Execute("INSERT INTO comments ('ghj',
'comment', 67)) in this code then .NET does not even let me step throught
the program. It just immediatly give the error below.
5. I know I should not use c:\events.mdb but this was only a test.
6. with the cnn.Execute line ommited, the thing steps through the code
but ofcourse does not work.
7. I know I can use the long way getting the data in the database, but
damit I want to do it this way!
<code>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>myweb</title>
</head>
<body>
<%
Dim cnn
Dim strDBPath
dim test
Set cnn = Server.CreateObject("ADODB.Connection")
strDBPath = "c:\events.mdb"
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
cnn.Open
set test = cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67))
%>
</body>
</html>
I get the error:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
--------------------------------------------------------------------------
Please try the following:
a.. Click the Refresh button, or try again later.
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
If anyone can help me here I'd really be a happier guy.
Chris Barber Guest
-
Jacques Koorts #4 Re: HTTP 500.100 I don't know anymore
got the error,
set test = cnn.Execute("INSERT INTO comments (name, comment, id) values
('ghj', 'comment', 67)")
fixed it. go figure.
Jacques Koorts Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
