using win 2000, asp and mysql. when i perform a bad sql statement in asp like...
dim cn
set cn = server.CreateObject("adodb.connection")
cn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=homerton;UID=root;PWD=;OPTION=35"
dim rs
set rs = server.CreateObject("adodb.recordset")
sql = "selec * from tablename" 'note the typo on select
rs.Open sql,cn
IIS complains with
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'
If i correct the error IIS still fails to work until i restart the w3svc service. On another pc running the same setup this doesn't happen, and correcting the typo enables the asp to work again.
IIS isn't crashing, it would still run a simple asp page with response.write etc on my pc, it's just when it comes to an sql statement again.
Anyone know why this occurs and if there's a solution?
Is it possible restart IIS from ASP? I tryed activex dll, but it wont work, i think its an "user rights" problem When i use this dll form vb6 all works fine. Any other solution?
Sometimes i need to restart the IIS on a current server, but the problems is that if i want to, then i have to contact them by either email or phone, but sometimes it takes few hour to do it. So i wonder if there Is a way to restart your IIS Programmitcally?
is it possible to restart apache from asp? the asp, of course, is running on the apache. it seems impossible to me, but.....of course, that is exactly what i am supposed to do. my asp script edits the config files, and i want the changes to take place immediately after i edit the files.
I have a big problem with the SMTP service in IIS on Windows Server 2003.
I tried to install FTP service on windows Server 2003 but had to cancel it as it did not appear to be working. Since then, i went back into IIS Manager and all services were stopped. I have got the default web site services started OK, but the SMTP service is stopped, and right clicking and selecting start does not start it running again. I just get a dialog box saying that the service isn't running and to start it running again (!!!!! That's what i was trying to do!!!!!!!!)
i also tried to restart it from DOS and got a message saying that the service was already running!!
i have also tried to stop the service from DOS and get a message saing that 'The Service could not be controlled in it's present state'!!!
When IIS is restarted session_onEnd is called. though the debugger is not available at this point in Session_onEnd, is there any way that the code in session_onEnd is running due to iis restart and not from the timeout.
I am using classic ASP. When the session times out theglobal.asa event called session_on end is invoked which is absolutely correct. When I explicitely do IIS reset or iis restart then again session_on end is invoked. How can I distguish in global.asa event session_on end that this is natural session time out or explicit IIS restart....
Recently changes were made to my pc. So I am now using another profile (which is a copy of the old profile), in order to enter a different domain when signing in to windows xp.
Since those changes, when I am trying to view asp pages through localhost, I am getting a 500 error, saying the page can not be displayed.
After shutting down and restarting, it works again (maybe a shutdown is not necessary, but only a reatsrt. I haven't tried).
When it was not working, I have checked the IIS and the directory "WEB SITES" state was "Running".
I do not remember anything regarding IIS, as I installed it a long time ago and once it worked, I did not have to do anything more. I do not want to reinstall, as I do not remember how, and it will take me a lor of time now.
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
Using Windows Authorization I get the exception below: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Net.WebException: The remote server returned an error: (401) Unauthorized.
I am using global.asax to handle my web application exceptions and have configured it to create event log entries for errors that occur and to display an error page advising the user to contact the helpdesk. I have an intermittent uninitialised object error that I am not able to reproduce in test and for which I really need the source line number. I believe this information is contained in the PDB but am not sure if one is created if I set the debug="true" flag in the compilation part of the system.web section of the web.config when the application is recompiled.
I have a system that tries to find holes in my web site. One of the things it has found and has been sent to me is,
an Invalid_Viewstate exception. I will provide the stack trace below. If you read down the stack trace it talks about "Invalid chararcter in a base-64 string" error. After reading much about this have not found any resolution.
I did read where one person said that people hit sites that require information and they sending bad or spam in hopes the site will forward the information on to an email and my site is capturing that because they also are changing the hidden field _VIEWSTATE which in turn causes this exception.
I also read that the data that is being entered is not passing validation and there is a need to trap for it. Code:
I am getting ready to give a whole application to a customer for website integration. I am finishing it up now by doing a final system check. When i ran the following script if gave me the following error:
error '80020009'
Exception occurred. /pabstproductions/WebDesign/VortexRegSys/ASP/YouthUpdate.asp, line 78
I really could use some help figuring this out Code:
I am trying to do a real simple bit of code here but i cant see where i am going wrong. I am trying to pull some titles out of the database and when i have 5 i want it to stop.
Well it is giving me an Exception Occured error. I have checked that the query is valid SQL, and i have also restructured my Do While Loop so to test the data is being pulled from the db and it is fine.
Could some one please have a look at this for me as i don't really understand what is happening. The commented out part at the bottom is the code that i used to test that something could be extracted from the Database. Code:
I am trying to convert a word document to pdf file from java for this, I am using a asp file to convert doc file to pdf. I got it working when I put the url which has file name as the query string in the browser but when I call that asp file through the java application I am getting 401 unauthorized xxx exception.
I am using weblogic 7 as the app server and IIS as the web server and Adobe acrobat 6 which has pdf distiller in it. The problem is when the asp file tries to create the Server.createObject(pdfdistiller.pdfdistiller.1), since it is a third party component, the machine doesnt allow me to create the object, I guess I am not sure, but I got it working when I put the virtual folder security anonymous user as domain admin but if i give any other user name it is giving the exception 401 unauthorized exception.
I'm getting an '80020009 exception occurred' error for some reason, even though I know that there is a corresponding record in the database. This happens on some records but not most. Any ideas? Code:
..when all the other records (84 that i'm displaying) have the same display reference, and they are all fine. The data in the dbase is not different than the other data corresponding to this field
The periodic error below keeps coming up and causing our server to crash. Once it happens, the only way to recover is to issue an IISRESET or reboot. We've updating the scripting engine, and database engine. The ASP code is connecting to an Access database. Is there anything that can be done about this? It happens several times a week. Code:
I have an ASP page that returns all the items in a database where a certain field (called Period) is equal to a given number. This number is pass in the URL from a link on the previous page. The script works fine but some of the periods contain lots of items (up to about 600), and the page takes an age to load, so I decided to use paging.
I found what looked to be a great peice of code on asp101 which I have adapted, but I am having problems. The code works fine for all of the pages except the last one, where upon it generates:
Error Type: (0x80020009) Exception occurred. /sleaMusTrust/DBTemp/ArtefactsP.asp, line 14
This line to me seems to have no problem at all (code listing is below). The particular block of code is generating links to jump to different pages, and I need this to include the same period, so I simply add it to the end of the url. However, if I delete the added period from the URL the page works (and carries on working if I type the URL manually into the browser address box). Code:
In the SQL select statement I need to compare with another field. This, another, field is sitting in the stored procedure. I have to call to the stored procedure to get this field…So I can do the comparison.
The error log entry below has occured a few times this month. Each time, IIS stops serving pages until IISRESET. Does anyone know what the problem might be? Code:
I have a server running Windows Server 2003, on which two of the web sites use the MegaBBS ASP forum software. Both sites suddenly developed the same error, which seems to be connected to the dictionary object.
I have a table inside access DB built like a tree, every record(=node) is a "title" that has a 'name' and 'paret' fields (and some other fields that are not relevant). I'm simpley trying to print out all the tree's records but I keep getting only a path from the root record to the first leaf.
I have a recursive sub called 'deleteTitles' that needs to perform this task. The var 'currentTitle' is the root node.
On every iteration of the sub I print one son of the current node 'T'. I'll be glad to give more information... Code:
I'm trying to delete a tree in my DB using a recursive function. The tree nodes are "T" (titles) The tree root is currentT, on the first call to the function. I get the error above.
Im writing a script that has a lot of "nested" IF statements - it breaks a complicated situation down through a sort of logic system, and when it reaches the end of the tree it performs a certain task - in this case, it writes a row of data into a table.
Its very annoying that the IF statements work exactly as I want/expect them to...but when it gets to the end of the tree of IF's I get the following error: Code:
We have an web application called I-CAL(Interactive Personal Loan Calculator). This application is configured on server with Win 2000, IIS 5.0 and with 1 GB Ram.
The application is facing a very rare problem which is difficult to reproduce and trace. The problem statement is as follows:
The application faces an ASP Error called "Type Mismatch" and the line it points the error to is the statement where we create an Object of the Business Component. For Eg: Set Obj = Server.CreateObject("PrgABC.clsXyz").
This is a very rare error which does'nt occur consistently. We are not able to trace it also. Code:
Error Type: (0x80020009) Exception occurred. /diary.asp, line 53
The specific part that causes the exception is when I try to access rsAppsTemp("AppointmentDate") in the While loop. For some reason it works fine in the If statement above it, but not in the While loop.