Database Maintenance Message

I have created a DTS package that imports 12 Visual FoxPro tables into SQL Server 2000. This package drops the existing tables, recreates them and imports the data and is scheduled to run every night.

I would like to restrict access to the database while the package is running. If a user does try to access the database during this time I would like to inform the user that the 'database is currently undergoing routine maintenance'.

Also, is it possible to implement a method to check if the database is being accessed. For example, 10 minutes before the DTS package begins, a message should be sent to inform users that the 'database will be disconnected in 10 minutes for routine maintenance'. This database will be accessed via ASP.

View Replies


ADVERTISEMENT

Maintenance Or Shutdown Message

Let’s say we have some connectivity problem or say UPS failure and web server is under shutdown condition .Can something be done for user to avoid confusion. Say M/C is running but due to some online code issue I want to show pre written message like “site is under shutdown till say 12.00 O’clock” .One way might be change index page for time being. Any other way-out ?

View Replies View Related

IIS Redirect For Maintenance

we have an ecommerce application that needs to come down for
maintenance. The application is normally only accessed via
http://www.mydomain.com/virtualdir/aspfile.asp.

I'm using W2K Advanced Server/SP4.

I would like to create a generic HTML page that can easily be put on the IIS
server to redirect all users that access any files on this domain to my
maintenance page.

Originally, I thought I could create a directory called "maint" or whatever
from root and from the "Directory" tab within IIS Manager, change the URL to
redirect to a specific page and set the checkbox (directory below current or
whatever). This appears to work, as long as no virtualdirector or specific
ASP file is referenced at the end of the URL.

Does anyone know the best way to handle this without making a bunch of
permanent changes? My site will be down about 6 hours and I need a
maintenance page to display during this period.

BTW, I do have other banking sites that have their own logon/password form
on their site. Their sites <FORM> action attribute points to my server.

View Replies View Related

File Maintenance Problem

I want to create a menu that will allow a user to chose the following options:

1)Add a project
2)Change a Project

For add I want the user to supply the values for the new row ie the asp will present a new table for the user to input data to the existing DB

For change, I want the user to
1)select the project number
2)chose from the following fields Pname, Plocation,Dnum
3)supply a new value for the chosen field

The DB i want to connect to is called Company2000.mdb and the table is Project.

The Project table has the following fields Pnumber, Pname, Plocation, Dnum

I've created the html form: Code:

View Replies View Related

Error Message When Deleting A File From Access Database

I get an error message when deleting an table from a Access database. The code is as follows and the error message is after it. Code:

View Replies View Related

Redirect All Pages From Domain B To A Maintenance Page On Domain A

We have two sites hosted on different servers and we have many pages on
domain A which has many links(asp programs) to domain B.

My question is if domain B server is in trouble, what is the best way to
have all domain pages redirect to domain A? Right now I just have redirect
code in each program on domain B to redirect to a maintenance page on domain
A.

Can I just write on program to solve this issue?

View Replies View Related

CDO.Message

I'm using CDO.Message to send emails and i'm using the .CreateMHTMLBody to send an html page, the only problem that i have is that when you view the email, you notice all the images that are in that page as attachments !!!! the email loads fine, but is there a way not to show the images in the attachments line

View Replies View Related

CDO.Message

I have a asp page that sends a excel price list to customers, this worked
fine untill now, but now when i sent one to myself it arrives as a dat file.
Does any one know why, and how to fix it, is it a problem with my emailk
reader (Outlook) or is it some thing to do wih Exchange?

View Replies View Related

CDO Message

I am using CDO Message to send mail from ASP page. I find that all the mails sent goes to bulk folder or appear as spam message in both yahoo and gmail. How can i prevent that.

View Replies View Related

Message Box

Is There a Message Box in Active Server Script like in
Visual Basic?
The four books I have show it the same as VB but I get a
Message "Permission Denied"
MsgBox "Message"

View Replies View Related

Message Box

does anyone knoe how to make a message box in asp vbscipt??

I am using

msgbox hello

or

msbox "hello"

to try and get a message but i get the error:

Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'msgbox'
change.asp, line 17

View Replies View Related

Message Box

When I load this script it says, �No record found�. This message suppose to display when I put something in search box and there is no record that matches in database. Everything else works fine. How can I get read of �no record found� message when I load page Code:

View Replies View Related

CDO.Message

I am using CDO.Message object with code below. When I execute the .Send command, I get the following error.

Error: -2147220973
Description: The transport failed to connect to the server.

Note: The SMTP Server and the IIS Server are the same machine.

Anyone come across this error message in the past? This error also occurs when I use Method #1 where I use the schema reference provided by Microsoft. Here is the code:

View Replies View Related

CDO.Message

I've created a form that e-mails the response to a person. Problem is that I want to include their name in the From attribute. Unfortunatly, the .From doesn't like spaces between strings. Are there any suggestions how to fix this? Code:

View Replies View Related

CDO.Message

I use CDO.Message to send mail. The problem is, CDO.Message will send to any malformed address, (eg. smtp:email.address@domain.com) and no errors are thrown.

View Replies View Related

Message Box

I want to delete a record from sql DB in asp page.. When the word "delete" is click, there will be prompted by message box about want or not to delete the record.

If the message box is clicked "yes" then record will be deleted. If the message box is clicked "no" so the record will not be deleted.

I've tried to use vbscript, but it didn't work, because I don't know how to combine this vbscript with ASP which is should connect to DB too.

If anyone who read this, has a complete coding for solving my problem, n would like to share with me ...

View Replies View Related

CDO.Message

Does anyone know if it's possible to send an email out in the Session_OnEnd script?
I Know it's possible to create a connection object in Session_OnEnd but unsure if it will create a cdo.message object.

View Replies View Related

Message Box

My ASP is limited and I can't recall how to pop up a simple message box
(with OK button).

I want to use them for debugging some code.

View Replies View Related

Message Box

im making an online course and on a certain page there are 3 items that each user needs to open and read. I want to check and see if they have opened all of these items before they can continue, so I would like to have a msg box pop up when they try and leave the page if they havent opened all 3 items first.

I have the database set up so if i know if its they're first visit to the page, and it knows when they open each of the 3 items, I just dont know how to get a msg box to appear when they try and leave the page. I know there is no msgbox fuction in asp.net, and i have tried javascript alert on page unload, but i get a "Response is not available in this context." error.

View Replies View Related

CDO Message

I am using CDO Message Class for sending email.My program is working properly.But some times it sends only part of mail.

I am sending through my mail server using authentication.Every thing is fine.I sending mail in html format.I am not understading the reason behid this problem.is there any limitation of size of message to be sent?

View Replies View Related

CDO.Message

i recive this error when sending the email that uses cdosys

------------
CDO.Message.1 error '80040213'

The transport failed to connect to the server.

/admin_SubscribedCust_email_processor.asp, line 42
-------------

line 42 is --> myMail.Send

View Replies View Related

Cdo.message

Can someone explain the with/end with operative used with cdo.message.I havent come across this before.

View Replies View Related

Message Box

I have created a page which loops through a recordset and creates a new row for each record.This row contains an image which the user can click to delete the record that is displayed in that row.

When the user clicks the delete image (link) I wish to make a message box appear with YES/NO buttons and a "Question" Icon.The message box will display "Are you sure you want to delete record x from the database?"where x is the primary key from that table (objRS.Fields("RecordID") )

If the user clicks YES it will redirect the user to a page.If the user clicks NO no action is performed.

View Replies View Related

Message Box In Asp

How do i insert a messagebox in asp?

View Replies View Related

SMS Message

I wonder how http://mobile.yahoo.com SMS works. By entering a phone number and service provider, how ASP page can send SMS message to a cellular phone?

View Replies View Related

CDO Message

I just installed windows xp sp2 and now my asp pages doesn't send CDO.Message objects?
Are these two related somehow?

View Replies View Related

Cdo.message

I'd like to use cdo.message to send emel trough ASP pages, but comes to an error that dont really know why. Can somebody give me a complete guide on how to configure the smtp server and so on. Code:

View Replies View Related

CDO.Message

I am lost with the CDO.Message error I am getting. The problem is intermitten. It seems to go away after overnight. I also have one page that runs Dundas Mailer and it works fine while CDO.Message comes up with this error, both tested at the same time! (I made it for testing purposes but would like to stay with CDO).

My ISP keep saying that the server is running fine and it is my code that is causing the problem.

View Replies View Related

CDO.Message

Is there a way to change encoding of a message created with CDO.Message, or otherwise send international characters (unicode) in Textbody? The messages I get now show question signs instead of international characters.

View Replies View Related

Cdo.message

i m using cdo.message to send site generated messages to our members. Is there a cdo function (such as cdo.validate for example)

whereby one could check the validity of an address before one sends, thereby avoiding the flood or error messages caused by people discontinuing an address without informing us.

View Replies View Related

Displaying Message Box!

I have a requirement to display a message and then redirect the controls to
some file, I tried with the below method but its not working, where as If I
use server.transfer or server.execute it works but I cant give relative Url
(it will dynamically genrate), If any one has an alternate way, pls respond.

ShowMessage("Hello World")

Sub ShowMessage(sMessage)
Response.Write "<script> alert("& Chr(34) & sMessage & Chr(34) &" );
</script>"
Response.redirect "xyz.asp"
End Sub

View Replies View Related

Message Box Issues

I'm trying to display a message box when they fall into the IF statments below. I understand that you cannot prompt with a message box on the server side which is why I placed it with in script tags, but this code doesnt do anything differently. Code:

View Replies View Related

Message Boxs ?

I am a new ASP user working on a university project. The design plan calls for the use of message boxs to confirm deletions from the DB. I have seen client side message boxs, but the design plan calls for server side pop ups using ASP. Can anyone show me how this is done.

View Replies View Related







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