Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 18th, 2006, 05:44 AM
Friend of Wrox
 
Join Date: May 2006
Location: Delhi, Delhi, India.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Default Handling SqlServer

My asp.net application deals with lots of data modification. I want my application to automatically update the database at regular interval of time, say 5 p.m. everyday.This update should be done regardless of fact that whether my application is receiving any hit or not.
If anyone can provide a solution, it will be great help for me.
__________________
Bijgupt
  #2 (permalink)  
Old May 22nd, 2006, 08:09 AM
Friend of Wrox
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2004
Location: New Delhi, India.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar
Default

hi,

you must be aware that web applications in general are stateless. That means when your application will have zero hits at any moment then it won't be running. So what you want to achieve can only be achieved via a seprate application which should update and do what ever you want at a fix time. This application can be scheduled by using windows schedular. But for that you need access previleges at your web server. Another option is to develop a windows service.

i hope my opinion will solve your problem upto some extent

Anubhav Kumar
  #3 (permalink)  
Old May 26th, 2006, 05:36 AM
Authorized User
 
Join Date: May 2006
Location: New Delhi, Delhi, India.
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am agree with anubhav,
But Anubhav can u tell me how a seprate application will do this if
a web application is not running.

rajkumar sharma
  #4 (permalink)  
Old May 29th, 2006, 12:15 AM
Friend of Wrox
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2004
Location: New Delhi, India.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar
Default

hi All,

from my past post, pls note that i mentioned developing a sepearte application [ windows app] , a windows service is a good choice but you can also go for a interface less windows application [ not a console application]. Use Scheduled Tasks [Control Panel] to schedule this application on the time of your choice. Do what ever you want in this application viz.. updating database, sending emails, transformation, backup, merging or any other maintenance task.

Please note that, developing such application also require a logic for debugging [since you won't be having an interface ]. Also you need access and previleges on web server to actually install and schedule this appplication.

We are doing a similar thing in our application , therefore i suggested this.

You have include a single module in your application with a main method. No forms are needed.

Anubhav Kumar
  #5 (permalink)  
Old May 29th, 2006, 12:20 AM
Friend of Wrox
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2004
Location: New Delhi, India.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar
Default

In addition to above , as far as Bijgupt's problem is concerned, he has work to around my opinion to get his task done. He better knows the situations and requirements afterall

Anubhav Kumar


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rownum in SQLServer Shais SQL Server 2000 2 December 27th, 2007 07:52 AM
SQLServer Express lizhaskin SQL Language 1 July 6th, 2007 05:40 AM
SQLserver 2000 vs SQLserver 2005 Express cJeffreywang BOOK: Beginning ASP.NET 2.0 and Databases 0 April 22nd, 2007 09:52 AM
is there anything like array in sqlserver? starnet SQL Server 2000 5 July 19th, 2006 08:01 AM
search in sqlserver vohra_vikas2004 SQL Server 2000 18 November 22nd, 2004 04:56 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.