| Author |
Topic |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2005-03-15 : 06:43:11
|
| Hi,We switched Emails platforms and are now using Lotus Notes. We were using MS Exhange before. What do I need to do to get the SQL mail client working ?Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-15 : 07:01:02
|
quote:
Originally posted by Mathias
Hi,We switched Emails platforms and are now using Lotus Notes. We were using MS Exhange before. What do I need to do to get the SQL mail client working ?Thanks
You can't. Microsoft says so.  use asp or vb instead to send the mails via lotus notes.--------------------keeping it simple... |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2005-03-15 : 07:56:23
|
| Has someone a store procedure to do it from the SQL server? Do I need to install a NOTES client on the server?Thanks, Paul |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-15 : 11:00:15
|
| You can setup SQL Mail and then use xp_sendmail.There's more than one way to skin a cat though. You can execute shell commands using SQL. Since this is possible, the easiest method for sending mail might be something like this:http://www.blat.net/194/ |
|
|
|
jason
Posting Yak Master
164 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-15 : 21:56:19
|
search the forum, i think some SPs were posted  --------------------keeping it simple... |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-16 : 15:09:45
|
Just a few  Been yak'd again... |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-16 : 16:07:48
|
| It's possible, but there's a LOT of work around.Igor. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-16 : 19:29:22
|
| can your Notes server be used as a POP3 server?This is the only way sqlmail or sqlagentmail will work for you. You will still have to use the outlook client, but you configure it to connect to a POP3 server instead of an exchange server.btw, SQL2K requires an extended mapi mail client to work. The only one that microsoft supports is OUtlook 2000 (2002 and 2003 also work).Read the note on setting up sqlmail that was posted earlier and follow the steps and you should have no problems. You can also do some searching on "CDOSYS" and "sql server" in google to find a few scripts that allow you to send email without using sqlmail (xp_sendmail).-ec |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-17 : 05:22:41
|
| yes you need to install lotus notes on the server--------------------keeping it simple... |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-17 : 10:05:16
|
| As Jen mentioned, there is an SPROC on the site that will do what you want. However, I found this one that I recently implemented and it works great for me.http://www.sqldev.net/xp/xpsmtp.htm |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-17 : 13:13:47
|
quote:
Originally posted by jen
yes you need to install lotus notes on the server--------------------keeping it simple...
Do not install the notes client on your box running SQL Server. The notes client won't work at all for SQL Server as an email client. You can only use the Otlook client if you are going to use sqlmail/sqlagentmail. You would then have to make sure that your Notes server supports POP3/SMTP email. The outlook client would be configured to use POP3/SMTP in order to send email.You can use the other alternatives posted here though if you don't want to install the Outlook client:- xp_smtpsendmail from the sqldev site- the 3 or 4 CDOSYS based sprocs that send email (do a search as I suggested)All of these solutions require your Notes server to be able to use POP3/SMTP though.-ec |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-22 : 11:53:37
|
| You need to find out from the Lotus Notes team, if the POP3 profile is available on Lotus Notes, then you'll need to set up a mail profile on the Server and name the services accondingly (Agent/Server) and still doesn't work as good as Exchange... You don't need to install Notes on the server.Igor. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-28 : 01:34:05
|
not sure what you guys mean, but we've installed notes client on our servers and they're working,they're handy too, especially if i need to transfer some files across sites  --------------------keeping it simple... |
|
|
|
|
How to setup SQL server Mapi mail with NOTES