I'm afraid I have a technical problem here. Basically what happens is that I'm getting some random errors(like Type mismatch... etc) that shouldn't under normal circumstances occur. Then I connect to my server via remote desktop and Recycle the application pool on which my asp pages run. Errors then disappear
View RepliesI'm running Windows 2000 SP4 with the latest IIS and all its patches. I'm working on designing a shopping cart using ASP. The problem I'm running into is that I get random errors when I hit the reload/refresh button. Is this a common issue? The problem seems to stem from my use of the ODBC connection. I'm using a set of commands like this:
'Create command object and recordset
Set cm = Server.CreateObject("ADODB.Command")
Set rs = Server.CreateObject("ADODB.Recordset")
' Specify the system DSN path
cm.ActiveConnection = "SpiritPOS"
cm.CommandText= "SELECT * FROM table_master"
Set rs = cm.Execute
'Clean up
Set rs = Nothing
Does anyone see any apparent problems with this? I seem to get some errors stating there is a problem with ActiveConnection sometimes, too. Do I need to set this object to Nothing as well?
However, what I want to do is include a request.querystring("ID"), so that IF an ID is defined, eg ID=3, , it will display the relevant (not random) information. I've tried this every way I can think and get type mismatches, etc etc. It's probably really simple but I can't see it.
<%
limit=3
redim link(limit)
redim image (limit)
link(1)="xxx"
image(1)="image1.jpg"
link(2)="xxx"
image(2)="image2.jpg"
link(3)="xxx"
image(3)="image3.jpg"
randomize
random=int(rnd*limit)+1
%>
<center>
<a href="<%= link(random) %>">
<img src="<%= image(random) %>" border="0"></a>
I just wanted to know whats the best way to generate 50 or say X amount of number at random without having to repeat any of the previous number...
so far I've the following:
[VBS]<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
function RandomNumber()
dim theRandom
Randomize
'RandomNumber = Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
theRandom= Int((99 - (0) + 1) * Rnd + (0))
if (theRandom<10) then theRandom = "0" & theRandom
RandomNumber = theRandom
end function
%>[/VBS]
and then I've this in the body of HTML doc: Code:
We have the need to have a random token (a 16 char alphanumeric field) to be used as the key for one of our SQL tables. I have created a random token generator, however after only 3 months in production, it appears that we had an instance where a token that already existed in the tables was created. There are 3810 records currently in the database so it isn't like there are billions of records there.
I contacted an old college buddy of mine who is a mathematician, and he claims, assuming that random really does mean random, that the chances of getting a duplicate token are 1 in 79.5 septillion (79,500,000,000,000,000,000,000,000).
So my conclusion is that this was either a complete freak of nature occurance, or my random generator isn't really all that random. Here is the code behind how I am generating this: Code:
I am trying to generate a random number. I am using randomize and then rnd to return a decimal number between 100 and 120. This will give me a longitude. I am doing something similar to generate a latitude.
I created this on a page which refreshs every minute. I put these points into a map and they are showing up in groups of straight lines. Since rnd is time based will refreshing every 60 seconds return similar numbers?
I am trying to configure apache::asp on apache2 and when i try to serve an asp page I get an internal server error. I get this in the error logs
66.249.65.228 - - [10/Jan/2008:12:57:57 -0500] "GET /asp/includes/functions.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:58:38 -0500] "GET /asp/includes/feed.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:06 -0500] "GET /asp/includes/contactField.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:19 -0500] "GET /asp/includes/encryption.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:33 -0500] "GET /asp/includes/LogonEdit.asp HTTP/1.1" 500 603
66.249.65.228 - - [10/Jan/2008:12:59:47 -0500] "GET /asp/includes/header.asp HTTP/1.1" 500 603
We've been expriencing periodic database connection errors with ASP code
talking to an MS Access database. Every once in a while, the code can't
connect to the database.
Usually there are no log entries that might point
to difficulties, but early this morning the Application Log was filled with
the 2 errors below. Once we did an IISRESET, the problem cleared. Does IIS
need to be re-installed, or??
Since upgrading to Windows 2003 Server from Windows 2000
Enterprise Server we have had alot of ASP problems. The
problems are centered around asp pages which are one level
or more below the main folder within a web site. We have
many web sites which have used the database interface
wizard in FrontPage which puts these pages up to three
levels deep inside the folder hierarchy of the main site.
The pages will not work with IIS 6. I have had to re-
engineer many of these sites without the database
interface wizard. My solution at this point is to put all
ASP pages at the root level which seems to work but
negates all version of Frontpage management including
FrontPage 2003 Beta. This is a serious problem!
Especially for us who teach FrontPage and ASP!
first, in NS (version 3, don't ask), get a
Code:
HTTP Error 400
400 Bad Request
Due to malformed syntax, the request could not be understood
what's that?
second, how do you turn the pop-up error alert window in IE for Mac off so that we can see the error in the browser window?
just for the record, the app works in windows fine, seems to have troubles on the Mac side.
I have a classic ASP application that runs fine on IIS on win 2000 or IIS on XP. But recently a client installed it on Win 2003 and now consistently gets an Internet Explorer-side error:' syntax error line. char 1' when he browses to it with IE 6.0.
When client moved the whole app as-is to an XP machine and then browsed to
it, he had no problem. I suspect the error involves client-side javascript. Iam looking into it; in the meantime:Are there a known issues of this kind involving IE 6.0 and windows 2003?
I recently finished a project for someone and they are getting 500 errors. What's driving me nuts is the application works fine from my location. All I can think is it could be a firewall issue but I've messed with my firewall and I can't reproduce the error.
What's ever more annoying is they are getting this error from more than one location. I don't see anything that would cause this. This is an admin application that uses Session and adds/updates an access DB. Works fine here.
Before we upgraded our intranet server to Windows 2000, when I had an ASP error the page used to load up to the point where it was crashing out and then I would get an error message. This allowed me to response.write values to find out where the error was happening.
Since we upgraded, all I get now is a 'page cannot be displayed' with the error message on it. This means that I can't response.write values anymore and makes debugging a lot more difficult.
Is there a setting somewhere that controls how the message is displayed? Is this in IIS or is it a browser issue?
All across my site i am getting 0x80020009 errors every so often.
they point to lines of code like
where FolderNAMEIN is a string such as "Botswana" and the
VarFolderNameLength is 150
if len(FolderNAMEIN) > VarFolderNameLength then
and
RS("Company") where Company is a valid field in the database.
I've get a problem in browsing .aspx pages locally.
I'm using Windows 2000 Advanced Server with IIS enabled
and .NET framework SDK installed, as well as Visual
Studio.NET.
But when I browse .aspx pages locally, I.E. shows "Server
Application Unavailable" message. In the Event log, I find
error event of ASP.NET 1.0.3705.0 with the description :
aspnet_wp.exe could not be launched because the username
and/or password supplied in the processModel section of
the config file are invalid.
I have written a script on an include page which pretty much will write all the required ServerVariables and session variables into a string and email off to me incase a page happens to error out.
I have the code working as I want it to using the folllowing:
If Err.Number = <> 0 Then
'RUN INCLUDE
End If
My issue is, where do I include this on the pages? If I put it at the top will it only run if there is an error at the start of the page or will it be assigned no matter how far down the page the error exists.
Or do I need to put in On Error Resume Next at the top then put the include at the bottom?
example,
I have 3 drop down boxes n a page.
1st box contains all countries,
2nd box contains all locations in that country selected from the 1st box
3rd box contains all items at that particular location selected from the 2nd box
Despite trying the codes given, I am still not getting it right!
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf14 Thread 0x4a4 DBC 0x10bbfcc Jet'.
/sanbookshop/searchtest.asp, line 22
I am trying to write a search script in my spare time at work. We have a knowledge base consisting of 200+ .mht files. My script was working ok when I was testing it on just a few files but I am getting out of memory errors trying to search through the whole KB. Here is the search code:
View Replies View Related3 workstations previously installed and able to access server.
4th workstation am able to map to server access files but when
attempting to log in receive the following error.
EXTERNAL DATABASE OPEN FAILURE
Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does not exist.
The workstation that is unable to connect is running XP SP2, MDAC 2.7..
the difference btwn this and the others is that it is running wireless.
Ruled out wirelss as being the problem because hooked LAN cable and
receive the same error. Code:
i am having troubles including a file
<!--#include file ="../Config/Connection.asp"--->
its brigning up an error message like this
Active Server Pages error 'ASP 0131'
Disallowed Parent Path
/account/ADMINCenter/Confirm.ASP, line 5
The Include file '../Config/Connection.asp' cannot contain '..' to indicate the parent directory.
ive tried placing the full path to the file in the include but i still get errors saying it doesnt not exist, but it does.
I have a form page that people fill out and push submit. When they push
submit, the information is stored in a database in two different tables.
You are then directed to a page that lists everything you have submitted so
you can print it. I am having problems with this second page. Information
from one of the tables is listed, but the information from the other table
isn't listed. They are related by the "casenumber" that is given when
submitted.
I have looked at the tables, and the information is there, and they have the
same casenumber, but the information doesn't get put on the 2nd page. We
just moved our site to IIS 6. Everything was working perfectly in IIS 5,
but is now "broken" in IIS 6. I always get the following error when it hits
the coding that should put in the information from the second table:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record. Code:
I haven't found this explicitly stated in any documentation, but i just
wanted to confirm this with people here. When there's an asp error on a
page, the request has appended to log something of the format
|-|ASP_0xxx|description. It also seems that this is inserted at point of
error, whether or not there has already been append to log data.
so, my questions:
1) is the |-|ASP_... always a consistent format?
2) does the |-|ASP... error message displace any other AppendToLog output?
I know the -query column only takes so many characters and anything busting
the limit simply gets chopped. I was wondering if that includes asp error
messages, or whether they appropriate some of the space
3) Why didn't they use something like &|-| as the seperator? using the &
would definitively close off any dangling query string variables, making it
easier for log file analyzers to separate the wheat from the chaff...
I am trying to create a search script but I am running into an out of memory error. Here is the search subroutine which loops multiple times:
Code: .....
I'm using if for when the user deletes a record from the database. People using the website try and delete more than one record at a t time by placing commas between the IDnumber ie. 1,2,5,9 etc.
This creates an error. So instead of this error appearing, how can I get a small alert box telling hte user he/or she has entered the wrong data type?
The code for the form is :-
I have made a Dll in VB. I am trying to make a word document by using a word template and then inserting data into the word file from my MS Access (Office XP) database. It works fine when I use the reference of this Dll in a form added in VB.
But gives me errors when I compile it and use it, by creating its object in ASP. It gives error 5981 : Could not open macro storage.I tried searching on microsoft website but could not implement the solution.I get a feeling that if a word reference is used in a dll and compiled and then used in ASP it gives no output. I am confused and frustrated as I have got the dll ready but can't use it in ASP pages.
im trying to trap errors in my asp page by putting them into a message box. How can trap an error in asp and put it into a message box?
View Replies View RelatedI want that every error in every asp/javascript/ etc... will trappped to a central asp page (not dotnet), which I declare on my site.suppose I have a dotnet site platformed - is the declaration for that may be the same for not dotnet declarations.
View Replies View RelatedIIS has quit displaying ASP errors it finds. Errors from SQL Server are displayed as are "page not found" errors but VBScript syntax errors are not. For example, the following code should give the error that x has not been declared but the page just stops processing after displaying "here".
<%
response.write("here")
x
%>
I'm coding in classic asp and can't figure how to get IE6 to display some kind of descriptive message about code errors? I have the correct settings under ADVANCED in IE's options selected.
What bugs me is sometimes IE will report the line number and a message, and then other times it's the standard "The page can't be displayed." When you have hundreds of lines of code, how can you fight this?
For some reason these errors have just appeared out of nowhere. Everytime I try to add, delete or update, I'm getting the following errors for both dns and dns-less connections:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query. etc
I have checked the read and write permissions and they seem to be fine, as well as with the locations of the databases that are in inetpub/wwwroot. Anyone know of anything else I can do to solve this?
i get this error when posting info in a form
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/register.asp, line 141
Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Page:
POST 295 bytes to /register.asp
Can anyone provide a simple example of an ASP script that includes timeout exception handling?Specifically, I don't need to extend the timeout, or prevent it. I'm not
responsible for the DB, and I'm told that periodic timeouts will be unavoidable.