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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Can someone explain the with/end with operative used with cdo.message.I havent come across this before.
View Replies
View Related
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
How do i insert a messagebox in asp?
View Replies
View Related
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
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
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
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
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
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
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
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
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
