944,198 Members | Top Members by Rank

Ad:
  • ASP.NET Discussion Thread
  • Marked Solved
  • Views: 24859
  • ASP.NET RSS
You are currently viewing page 1 of this multi-page discussion thread
Nov 22nd, 2007
0

Send automatic email

Expand Post »
I am working on a web-based app, and I need to implement a function whereby it checks the dates daily, and send reminder email automatically.

May I know how can I do that? I saw some websites that mentioned about Console Application and Windows Scheduler.
Is that what I need? If so, how can I link to my app?
Otherwise, what are the methods that are available?

I'm new to C# and asp.net, please help.
Thanks.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dotNetDummi is offline Offline
53 posts
since Nov 2007
Nov 23rd, 2007
0

Re: Send automatic email

hi,
there are different options to send email automatically
1) you can use windows schedular in u r computer to send them
the following urls will help u :
http://blogs.msdn.com/dditweb/archiv...0_-Part-I.aspx
http://www.gridviewguy.com/ArticleDe...x?articleID=32

2)u can achieve the same functionality using sql server,if u are using that in u r project.
first u need to configure the sql to send emails the procedure and requirements for a computer to send email are given below,hope it helps

Requirements for Domain User Account


All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).-->the server account we r using should be db owner.
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.-->go to control panel->administrator tools->services->local security settings->local policies->user rights assignment->double click we will get logon as service->check whether the account is included in the list displayed otherwise add
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
start->run>regedit>HKEY_LOCAL_MACHINE>Software>
Microsoft>mssqlserver>right click and check for permisions and check whether u r account is listed or not
HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQL$Instancename. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib. start>run>regedit>HKEY_LOCAL_MACHINE>System>
currentcontrolset>services>mssqlserver>right click and check for permisions and check whether u r account is listed or not.
Even after checking permissions if u get error then it may be due to u r password.check whether u have typed correct password.if neccessary change u r password.
the detailed procedure for configuring sql mail is given in http://blogs.techrepublic.com.com/wi...windows/?p=164
Reputation Points: 25
Solved Threads: 29
Posting Whiz
greeny_1984 is offline Offline
372 posts
since Apr 2007
Nov 23rd, 2007
0

Re: Send automatic email

Hi, Thanks for your reply.
Erm, if I deploy this website app to the web-server,
I should be using method two. am I correct?

hi,
there are different options to send email automatically
1) you can use windows schedular in u r computer to send them
the following urls will help u :
http://blogs.msdn.com/dditweb/archiv...0_-Part-I.aspx
http://www.gridviewguy.com/ArticleDe...x?articleID=32

2)u can achieve the same functionality using sql server,if u are using that in u r project.
first u need to configure the sql to send emails the procedure and requirements for a computer to send email are given below,hope it helps

Requirements for Domain User Account


All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).-->the server account we r using should be db owner.
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.-->go to control panel->administrator tools->services->local security settings->local policies->user rights assignment->double click we will get logon as service->check whether the account is included in the list displayed otherwise add
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
start->run>regedit>HKEY_LOCAL_MACHINE>Software>
Microsoft>mssqlserver>right click and check for permisions and check whether u r account is listed or not
HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQL$Instancename. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib. start>run>regedit>HKEY_LOCAL_MACHINE>System>
currentcontrolset>services>mssqlserver>right click and check for permisions and check whether u r account is listed or not.
Even after checking permissions if u get error then it may be due to u r password.check whether u have typed correct password.if neccessary change u r password.
the detailed procedure for configuring sql mail is given in http://blogs.techrepublic.com.com/wi...windows/?p=164
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dotNetDummi is offline Offline
53 posts
since Nov 2007
Nov 23rd, 2007
0

Re: Send automatic email

hii,
yes.if u want to use windows schedular .u should schedule in u r clients computer.if u r using sql server ,u can use the second method.its very easy to use also.u have a option called jobs in sql server that does the work very easy but before that u need to configure the sql mail.
Reputation Points: 25
Solved Threads: 29
Posting Whiz
greeny_1984 is offline Offline
372 posts
since Apr 2007
Nov 23rd, 2007
0

Re: Send automatic email

hi,
i think the thread is not working.check out this :
http://search.techrepublic.com.com/i...uring+sql+mail
Reputation Points: 25
Solved Threads: 29
Posting Whiz
greeny_1984 is offline Offline
372 posts
since Apr 2007
Nov 23rd, 2007
0

Re: Send automatic email

Hi, thanks for your reply.
I am not able to install that to my clients' computer so I think I'll go for method two.

Erm, I need to ask you something.
My database is using MS SQL Server.
So if my users don't have to login to the system and the database is able to trigger the method (sending email accordingly) itself?

Sorry, I don't understand about database mail.

Thanks for your reply.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dotNetDummi is offline Offline
53 posts
since Nov 2007
Nov 27th, 2007
0

Re: Send automatic email

Hi.. I've developed the console application already.

Now I have a question.
In the end, the database which is attached to my web application will be deployed in a web server.

Will this console application (install in one of my user's PC) connect to that database?

The connection string is the same.

Is there anything I've to do or I can just install the exe file to my user's PC and it will be link to the database in the web server?
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dotNetDummi is offline Offline
53 posts
since Nov 2007
Nov 27th, 2007
0

Re: Send automatic email

hii,
using sql server to send emails,i have tested locally in a lan network.it worked i have no idea how it works for a deployed website.'help' of sql sever is one of the best teaching guides,so check the topic 'multi server Administration',hope this works
Reputation Points: 25
Solved Threads: 29
Posting Whiz
greeny_1984 is offline Offline
372 posts
since Apr 2007
Nov 27th, 2007
0

Re: Send automatic email

Thanks for your reply.

actually I didn't use SQL server to send the email.

I need a function whereby i retrieve the email address if there is no response from the users' clients after 3 days.

My Console Application contained the sql statements and the Stmp mail..

It's working if I run.. But still, I'm not too sure if this is the method I should use.

Sorry to trouble you.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dotNetDummi is offline Offline
53 posts
since Nov 2007
Nov 30th, 2007
0

Re: Send automatic email

I was reading your problem and wanted to say that 'greeny' is right. However there is a problem with using a Console application and scheduler - many IT admins will not like that option. Running the scheduler requires and administrator's user and if that user changes his password or is deleted the process will stop running. Another option you might use is using a cache refresh process in .NET. Using that option how ever does not let you good control over the time the method runs. I think the SQL option is the cleanest but requires an friendly DBA
Reputation Points: 10
Solved Threads: 4
Newbie Poster
shaulf is offline Offline
18 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: Reporting Service Problems
Next Thread in ASP.NET Forum Timeline: Strange problem with vs 2005 when starting application





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC