Sql Open Exception Persists Until I Restart IIS

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?

View Replies


ADVERTISEMENT

Restart Iis

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?

View Replies View Related

Restart Your IIS Programmitcally

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?

View Replies View Related

Restart Apache

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.

View Replies View Related

Cannot Restart SMTP Service

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'!!!

View Replies View Related

Iis Restart And Session _onEnd

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.

View Replies View Related

IIS Restart + Session Time Out

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....

View Replies View Related

Asp Pages Shown On Localhost - After Restart Only

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.

View Replies View Related

How To Capture The Server Restart Event?

I am trying to capture the server restart event, so when ever it restarts, it connects to a web page to update its current ip address.

View Replies View Related

Exception Handling

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?

View Replies View Related

Authorization Exception

I am trying to read an XML file as below,

DS.ReadXml("http://localhost/PM/" & Me.ViewXML & ".XML", XmlReadMode.InferSchema)

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.

View Replies View Related

Exception Handling

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.

View Replies View Related

Invalid_viewstate Exception

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:

View Replies View Related

CreateObject Exception

we use an ASP page to upload files but sometimes it doesnot work as it suppose to do and we found error log in Application Error as:

Event Type: Error
Event Source: Active Server Pages
Event Category: None
Event ID: 5
Date: 11/27/2006
Time: 9:17:08 AM
Description:
Error: File /ASP/UploadFile.asp CreateObject Exception. The CreateObject of
'(null)' caused exception C0000005..

This exception happened sporadically. I didnot find a way to reproduce the error.

View Replies View Related

Exception Error

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:

View Replies View Related

Exception Occurred

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:

View Replies View Related

Exception '80020009'

When i try to execute this cycle:

<%while not (oRS("IDFoto")=IDFoto)
IDPrec=oRS("IDFoto")
oRS.MoveNext
wend%>

i get the error:

80020009 Exception Occurred

I want to select the record with the field IDFOTO= the value in the variable
IDFoto I'm sure the cycle doesn't work, if i modify it so:

while (oRS("IDFoto")=IDFoto)

it works (but with no right result of course).

View Replies View Related

401 Unauthorized Exception

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.

View Replies View Related

Exception Handling

can anyone tell how to handle exceptions in ASP. please give me any link or explain me if possible.

View Replies View Related

80020009 Exception Occurred

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:

View Replies View Related

Exception Occured Only On One Record

I'm getting an "exception occured" error pointing to this line :

<%=Replace(Replace(rs1("racelength"),"D","")," ","")
%>

..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

??

View Replies View Related

Script Engine Exception?

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:

View Replies View Related

Puzzled At Exception Error

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:

View Replies View Related

Exception Occurred.(0x80020009)

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.

Here is what I tried: ....

View Replies View Related

Script Engine Exception?

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:

View Replies View Related

Exception When Accessing Dictionary Object

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.

ASP... Code:

View Replies View Related

Exception Occurred /deleteTitle.asp, Line 38

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:

View Replies View Related

Exception Occurred /deleteTitle.asp, Line 38

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.

View Replies View Related

Exception Occurred Strange Error

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:

View Replies View Related

Error: Script Engine Exception.

Has anyone run into this situation and could possibly help me out? I am running on w2k vf mssql

Description:
Error: Script Engine Exception. A ScriptEngine threw expectio
'C0000005' in 'IActiveScript::SetScriptState()' fro
'CActiveScriptEngine::ResetToUninitialized()'.

View Replies View Related

Type Mismatch & Exception Occured

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:

View Replies View Related

Error Type: (0x80020009) Exception Occurred.

I get the following error from the code below:

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.

Any ideas?

View Replies View Related

Error Type : (0x80020009) - An Exception Occured

I have this type of error Error type :

(0x80020009)
An exception occured

/yeni/haber/Default.asp, line 78

and this asp code :

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved