Recently, I've been encountering some problems with one of my VB Scripts.
Very often, the results that is generated from running the script is truncated. (The results are written into a text file on the server and is picked up by another program for printing).
I've looked through the code at least a hundred times but do not seem to know where the problem lies.
After questioning the users more closely, I discovered that they switched the computer off while the script is still running (it tends to take about an hour or so due to intensive searches on very big sized databases).
My question is : will the script still run to completion in this case? I'm at my wits end trying to figure out what went wrong.
yes i did close the connection, infact ultradev did this for me. This works before, I mean in other files and I am using the same format to build new pages.
In my page I run one sp to retrieve client details, loop through that and use another to retrieve details relating to each client. The first sp returns records correctly but i get the message "Operation is not allowed when the object is closed" .
when i try to use the second one. I have checked permissions and connections. I have printed out the variables i am passing as parameters and have tried running the sp from sql and it works fine.
I have to do an ASP page with sort of an SQL command to insert in data stored in a access database.
So, I whipped up a simple web page just for visitors to my web to key in name, email and comments about my page, and then it'll save these to a access database. And i got this error: Code:
I am trying to run a query after the browser window is closed. I need it to delete a value from the database when window is closed.
If it deletes it minutes after its closed that is fine as well. I just need some way to automatically delete information from the table when the user leaves the site.
So I have this database working JUST fine for a week, then I add another table to it and then this is where things starting getting crazy. Here is my db conn code:
I am getting the error 3704 "Operation is not allowed when the object is closed.Operation is not allowed when the object is closed." The problem is when no record is returned from the stored procedure. If there is a record, I do not get this error. Here is the portion of the code giving me problems.
rs.open strSql, strConnect if rs.eof = true or rs.bof = true then bEof = true end if
The line in red is what gives me the error. If I take out that section, I do not receive an error. Any suggestions? I can easily get around this by putting in an on error resume next, but I'm trying to get this to work without errors first.
I'm working on a quick wrapper so that I can connect to a database, run a quick query, get the needed info and pass it on to the next page that needs it. I've been programming for a long time but not with ASP/VBscript and think it's just something stupid that I've overlooked. Code:
I have an asp page (parent) which opens a new window (child) with "window.open()". What i want is, when the child window is closed with "self.close()" then the parent window has to be refreshed. Any of you guys know how to do this?
I'm getting the error "operation is not allowed when the object is closed" on the following line:
<% If Not rsAlloAmts.EOF Or Not rsAlloAmts.BOF Then %>
I haven't dealt we this particular type of situation and not sure how I can bind the necessary values to the page based on what is passed in to the procedure. I'm not sure how to handle this type of logic on the page?
I have a problem with my programm and get the error above. In the file I've commented the relevant lines with **** and normaly the SQL-statement are in one row but there is a better overview when it looks like this.
I've installed iis6.0 on win2003. All static content with ssi etc rendered fine on the browser, but gives a 500 internal server error if i try access any asp page. The log file says:
I'm cobbling together an e-commerce site with thousands of items (spares, accessories etc) and want to distribute it as a catalog on CD. I don't fancy rewriting it to HTML. Is there any way to run the ASP and database on a CD-ROM. I've tried Dynamic-CD but it won't do the job and there is little or no help on their web site.
I am trying to run a simple VB exe from the asp. I am using the following code
Set oWSH= Server.CreateObject("WScript.Shell") oWSH.run "%COMSPEC% /C est est.exe",3, False
The exe is seen in the task manager. But it is not running. When I use this same command in the command window, it works fine. Can some please help me. It is for Intranet development. I am trying to run the exe in the server only.
I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it.
I need to open asp.net solution files whose source location files have moved. I am creating new virtual directories on the fly (using vbscript) as part of a automated build process that are configured to point to my new source directory. The build is following because I get the following error
<b>Unable to open Web project 'Abc'. The file path 'c:dev...' does not correspond to the URL 'http://localhost/Abc'. The two need to map to the same server location. HTTP Error 404: Object Not Found.</b
I am getting around this in the build process by removing the <b>GlobalSection(ProjectConfiguration)</b> section from the *.sln file
Is there a proper way to avoid this error occuring
Is there a way to open FrontPage automatically on a user's computer using a web page?I wan't the user to be able to click a link or a button and have FrontPage open to a specific URL. The FP permissions should take over from there. I'm looking for the same kind of execution that you get when you type
I am very new to asp programing, so this may seem a silly question but here goes. I am creating a page that will generate random lotter numbers. I have created the actual code to generate the numbers and have added the code to the top of the page. the problem is the code runs when the page loads and I want it to run only on the click of a button. I read various starter tutorials and none seem to mention how to asign code to the click of a button.
I know there have been posts about this issue before, but I can't seem to find what I'm looking for. I'm not well versed in ASP, but in PHP there is a function called exec. This launches a process. I can call a PHP script from the command line and have it run in the background i.e.
<?php
exec(php myscript.php &);
?>
is there a way to do the same thing with ASP? I want to run an ASP script in the background
I am trying to run an ASP page in IIS 6.0 and I keep getting one of two errors:
-2147467259 (0x80004005) The remote procedure call failed and did not execute.
I have Win XP. It's been running fine for a long time and then yesterday, for no apparent reason, I get this. I've tried the links to asp.faq that I've seen others post and nothing works.
As a test, I created a simple ASP page with just '<% Response.Write("Hello") %>' in it and still the error occurs so it's not a scripting or database problem. DotNet seems to run fine and I can run HTML pages, I also have Apache and can run PHP scripts with no problem ... everything except classic ASP.
Any ideas? This is driving me crazy and I need IIS running because I am falling behind in my work. As I mentioned, I've been running ASP scripts on this machine for years and have never seen this problem.
I had the error "Visual studio.net has detected that the specified web server is not runnning ASP.Net version 1.1. Yow will be unable to run ASP.Net web applications or services." in .NET 2003.
I fixed it by running the IIS mappings for ASP.NET, aspnet_regiis -r. But I figured that my IIS had some issue and I had to register the dll for IIS.
After doing that my .net is throwing the same error, "Visual studio.net has detected that the specified web server is not runnning ASP.Net version 1.1. Yow will be unable to run ASP.Net web applications or services."
I ran the aspnet_regiis -r again it is overwriting the 1.1 .net framework scripts but the error in .Net is not fixed.
I know my webserver is running Ok because I can develop ASP pages using Visual Interdev and my default website is running fine.
Here is a simple test class Ive built to try and find out, why another class I built (that works fine on my testing server running iis on xp) throws up an error on the live server running red hat 8.3 on linux, Im new to asp and only just now found out the live server is a linux box. Code:
I want to make a simple simple asp page. All I want is when the page loads it does "net stop <service>". The code is below, it is not running as IUSR_<machine>, I am authenticating as Administrator yet the service does not stop.
The blank page just loads with no errors and the service remains running, what am I missing? I am completely new to ASP, I just want one simple page for this purpose. Code:
