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.
3  1947 
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" <jk*****@myrealbox.com> wrote in message news:10*************@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.
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" <jk*****@myrealbox.com> wrote in message news:10*************@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.
got the error,
set test = cnn.Execute("INSERT INTO comments (name, comment, id) values
('ghj', 'comment', 67)")
fixed it. go figure.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: WebRod |
last post by:
Hi,
i have a script (script1) which needs to call another script (script2).
It should not wait for the answer, so script2 should run in the background.
I really need to call the php script...
|
by: mike420 |
last post by:
In the context of LATEX, some Pythonista asked what the big
successes of Lisp were. I think there were at least three *big*
successes.
a. orbitz.com web site uses Lisp for algorithms, etc.
b....
|
by: Ron |
last post by:
Hello,
I keep getting a runtime error with the following ado
routine that I run from a VB6 app - note: I tried it with
ref to mdac2.6 and mdac2.7 and mdac2.8. This worked once,
but it doesn't...
|
by: Jace Benson |
last post by:
Ok I have read alot of things on zend.com, php.net and other sites went
to the wikibooks to try to understand how to use a class. I have this
project I want to do that I am sure would work great...
|
by: SIMON GARE |
last post by:
Hi
I have a service provider that's sends sms messages from clients mobile
phones to my asp page, problem is I don't know how to show the data and they
are not being helpful.
The process is...
|
by: universalbitmapper |
last post by:
Hi,
I have php 5 and Apache 2 on windows.
Gif images don't show anymore in a simple form, I just get the "alt"
text.
I see php_gd2.dll under \php\ext, but phpinfo() shows "gd", not "g2".
...
|
by: majik92 |
last post by:
Hello,
I'm in the process of rewriting a program I wrote in LUA to VB.NET.
So, I am still learning the language (VB). I just have a question...
I have a windows form called "mainPage". I want...
|
by: totalstranger |
last post by:
My Bluehost site is setup with a dedicated IP address, Rapid SSL
certificate, PHP 5 and FastCGI is set on.
When switching between HTTP and HTTPS I was under the impression the
Session Data was...
|
by: Junior |
last post by:
Vista SP1 IIS7
I'm trying to configure web.config following MSDN docs but keep getting
errors I don't know how to resolve..
<configuration>
<!--error-->
<appSettings...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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,...
|
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...
| |
