I have a pure asp (Vbscript) page that manipulates data between MSAccess and
SQLServer2000. I'm trying to use the Scheduler app on the IIS server to run
this page nightly but there must be a better way of doing this.
How can I make my code in to an object and install it on the server and have
it schedule to run nightly?
Below is the code:
I'm looking for a solution for the following problem:
I created ASP code to convert an URL such as:
http://localhost/mypage/category_20/article_15/
into the following URL:
http://localhost/index.asp?page=myp...20&articleid=15
Now, the first URL is submitted by the user. The second one is the real URL,
but not visible for the user. This one should be handled by the web server
internally.
I thought I could accomplish this task with server.execute or
server.transfer, but none of them can handle querystrings. Is there another
way to do this?
Are there perhaps any COM objects? (This will be my last choice, because the
whole system should go running on an iASP (instant ASP) server too if
possible)
we have started to upgrade our server form Windows2000 Advanced server to Windows2003 server. The website we are developing is done using classic ASP. When we put the website on the new server the asp pages didn't work and we receive an error (500 - Internal Server Error). I would like to know if there is a specific configuration for the IIS ver.6 on Windows2003 Server for classic ASP?
View Replies View RelatedI am building up a library of Class'es that represent various columns of
table layouts. One often used column is "name" and each occurrence is
treated identically. (What a concept, eh?)
Part of that library of Class'es includes representations of various tables.
(Just let me know if you see a trend going on here.) These Class'es use the
column Class'es.
What I would like to do, but I have yet to find a way around duplicated
names, is to place all the necessary supporting column Class #include's in
the table's Class so that I need only place the table's Class in the module
utilizing them.
I understand entirely why the "duplicate name" error occurs.
What I am looking for is a way around the conundrum that does not require
duplication of code. Any ideas?
Is ASP page compiled or interpreted by the web Server and what about the internet explorer how it deal with HTML and other realted pages?
View Replies View RelatedI want to create ASP page that shows the schedule of TV station. Since each day's (Monday - Sunday) schedule is different, and I want each day will display the schedule on that day of a week. I wonder if I need to create 7 different ASP pages and call different one on each day? This is just my idea, but I think this is not a good solution.
View Replies View RelatedI am trying to create a Function to delete records in database on daily basis. I am stuck with date/time.
Sql:
Delete * from MyTable where date = &date& 'not sure of quotes also.
How can I rewrite my sql to delete records daily at 8.00pm?
I want to allow the users to shedule a particular task (shedule the time and date of inserting thier forms and data into the table ) such that i ll provide a simple form where the user can enter his name , age , and some other details at the end of this form , there is field to enter the date and time of inserting those fields into the table in the database,so that data inside this form will be inserted into the table as per the user scheduled date and time
View Replies View RelatedHow to do the above without global.asa?
I need the script to run every 24 hours. Currently I am using database.
If rsDB("date") < DateAdd("h",-24, Now()) then
<--SCRIPT HERE-->
Then I have a script that puts the rsDB("date") to Now().
Any way to do a Scheduled task without having access to a "Scheduled Task" feature in the hosting control panel. IOW, I want to run a single Update Table query every Sunday at Midnight but I don't want to have to manually run it. I use SQL 2000 on a Win2k machine.
View Replies View RelatedI'm trying to find a way where I can schedule a task to be run within a web site, either in VB (COM) or within the web site (ASP). What I want to do is to run a daily scheduled task which will cleanup a desired folder within the web site. As I say, this must be an automated scheduler which can kicked off by itself without any interaction from a user etc.
View Replies View Relatedhow to create an on-call schedule. It just needs to be really simple. Basically a two column table with names on the left and dates on the right. There is a specific order that the names are in in the Access db and need to stay in that order to keep the schedule rotating properly.
I want the name of the person who is on-call this week to be at the top of the table and then when the on-call week is over that person drops to the bottom of the table. A typical on-call week is from Mon-Sun. Also making the dates populate correctly without having to manually enter them in the db
i have this event sign-up program that displays events from access databases and allows a user to click on a sign-up button to sign up for these events. currently when viewing an individual summary, the users see a listing of events they've signed up for, but it's been suggested to create a grid schedule for a better visual.
these events cover a 9 day period (Friday through Saturday) and i was wondering if there's a relatively easy way to create a grid schedule for the users?
We have a web application to allow user register a meeting and want to automatically add into their outlook calendar. how to do this in asp?
View Replies View RelatedI wanted to run an ASP script to send mails, to be executed every 24 Hours.
View Replies View RelatedI have developed a website in ASP 3.0 and Acesss 2000/SQl
Server.
I wan my web site sent invoices to my customer
automatically ...at some specified time
(lets say it execute ceratain ASP page at 3:00 am that
send emails)
how can i schedule that?
Should i write some program (EXE) that will run on web
seerv to do this task or do we have soem other decent
solution?
I'm building an asp website with calendar for a High School Basketball team. A database holds dates for all events on the calendar. I want to build a schedule for a SEASON automatically based on the current date() they are visiting the site, and a SEASON is June of one year through May of the next. Example:
If they are accessing the schedule in January 2007, a query will filter all events for the 2006-2007 season (June of 06 through May of 07)
If they are accessing the schedule in August of 2007 I want them to get events filtered from June of 2007 through May of 2008 (the 2007 - 2008 season).
I can't seem to get my mind around the logic (and code) needed to build this query. If i build a query based on the year alone, by picking 2007 you would get the end of the 2006-2007 season and the beginning of the 2007-08 season (events from Jan 2007 through Dec 2007).
I am in a Intranet project for Global telehone Directory for my company.Is there is a solution in which we can connect to the microsoft mail exchange server and get a details of a employee through Outlook schedulewhether he/she is available or not.
View Replies View RelatedI would like to know if there is any way to schedule an asp page to run once a month.
The purpose of this process is to automatically insert data to a table in a monthly basis to allow users to manupilate it without having them to add any fields to the table.
Is it possible with ASP to schedule tasks such as the following:
A database contains hundreds of registered users. Within three days of their registration expiry an email should be automatically generated to inform all relevant users that their account will expire shortly.
A sheduled task should also run every night (say, at midnight) to remove expired accounts from the system.
I need to write one program to schedule the job to run the DTS created at SQL Server 2000 with Global Variable passing in every time when user select. I have search from internet, there only have example written in Visual Basic, can any body help me because my company not have Visual Basic.
And When I try to copy the example from VB Code to ASP code, there are error :
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
After I check is because of ProgID "SQLDMOUtil.Job" used in code.
I am developing site in asp where I need to call a url at every interval. Is there a way to automate this. I want to call the url every 15 or 30 mins.
Cureently I have written a asp script tp call it using
Set objWinHttp = Server.CreateObject("WinHttp.WinHttpRequest.5.1")
objWinHttp.Open "GET",URL
objWinHttp.Send ' Send it.
strResponse3 = objWinHttp.ResponseText ' Get the response string from the object.
But it is not schedule..I can call it only when I rum the asp script. So is there any way I can schedule this url call for every 15/30 minutes.
Also forgot to mention : the site does not have that much traffic that I can add it in index page...there may be a user visiting the site in 5 hours time or within next 5 mins or for next 2 days there may be no visitor.
An ASP script written in ASP.NET has worked fine on one computer, and since it has been moved to another, it doesn't.
The part that does not work deals with executing CMD.EXE. Here is a part of the code:
System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe");
psi.UseShellExecute = false;
psi.RedirectStandardOutput = true;
psi.RedirectStandardInput = true;
psi.RedirectStandardError = true;
psi.WorkingDirectory = @"c:SOME PATH";
System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi);
System.IO.StreamReader sOut = proc.StandardOutput;
System.IO.StreamWriter sIn = proc.StandardInput;
sIn.WriteLine("SOME COMMAND LINE PARAMETERS");
...and instead of executing like it did on the last server and displaying the output, it creates a web page with the following output:
Microsoft Windows [Version 5.2.3790]~(C) Copyright 1985-2003 Microsoft Corp.~~c:SOME PATH>SOME COMMAND LINE PARAMETERS"~~SOME PATH>EXIT
...followed by the rest of the web page as it did before.
What I figured is that for some reason this script on the new server instead of executing the command, it just sends it as an output to HTML.
I have tried to readjust .NET security, then to adjust the folder permissions (I gave EVERYONE permissions to all the needed folders). Nothing helped.
I have got a problem executing a query. The driver indicates an error in Internet Explorer : No value given for one or more required parameters It refers to the recordset definition. I have tested the query in my DBMS, it works.
SOURCE :
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & server.mappath (BDname) "
Dim StrSQL
StrSQL = " SELECT NOM FROM ATTRIBUT WHERE LIBELLE = TRUC"
Dim rcdSet
rcdSet = Server.CreateObject("ADODB.Recordset")
rcdSet.Open StrSQL, objConn , adOpenForwardOnly, adLockPessimistic
I currently have an asp page that ask for an email address and then with selection values runs a stored procedure.
Everything runs fine but the concern is that with enough records the processing limit will be exceeded by the web server and it will cause the page to crash.
Is there a way with ASP and MSSQL to send a request to process a stored procedure but have the processing of the asp continue while the sql runs its cousre? My sp will already email the user when processing is complete I just need the asp to send the request for it to be run but not try and run it while the next page loads.
The statement was made that the following code works.
Is This ture?
stringa = "response.write 1"
Execute(stringa)
Timed Execution for Access Database?
I was reading a book about access databases and sql, when i came upon the time execution part it simply said it could be done but did not go into details as to how. Does anyone out there know of a way to produce a time execution with a access database?
ex: ability to set an email to be sent out on the 1st of january at 5pm, and on that date/time it would send it out. I know that you can simply have a asp page check the time when opened and if it's the correct time use a function to send it, BUT is there a way to do it with out having to go to the page on that time???
Is there a way to execute sql queries besides using recordset? If so, can someone provide me with links to materials i can read online or post an example?
View Replies View RelatedI have an asp page that contains a simple insert statement and redirect i.e.:
Page1.asp
<%oconn.execute "insert into table 1 values(1)"
response.redirect "newpage.asp"
%>
I have to add some code to it to not allow execution of this script if the page was called from the <img> tag i.e.
<img src=http://webname.com/page1.asp width=1 height=1>
The page should be opened in browser in order for the script it contains to be executed. How do i acomplish that?
i do have a little problem.....i have 2 difrent functions in my asp pages. function1 and function2.
funktion 2 has to be executet 15sec after function 1 had been executet.how can this be solved in ASP, and is it impossible.
How do I execute a users program from a web page? When a user goes to a webpage - I want a link on that page that will execute a program on the users local hard drive - like say...notepad.exe . Everything I have tried will only execute it on the server.
View Replies View RelatedI have a problem: I have an ASP page who takes a lot of time in execution, but I want to "abort" it when the user make click in a link. I have heard I can use the Response.IsClientConnected, but I am not sure if this will work.
View Replies View Relatedhow can i stop execution. in betweeen a few lines of code. i dont want the complete execution of code and in middle i want to stop?
View Replies View Related