Can anyone advise on how to configure mail support between Lotus Notes 6.5 and SQL Server 2000.
My attempt is to have the SQL Server send notifications to various operators via lotus notes 6.5 when an error occurs or back up completed.
Also, can someone tell me exactly what the MAPI connection is and how to create it between the SQL server and the Notes server.
I await any help I can get.
LAW
Subject: Help in configuring mail support between Lotus Notes 6.5 and SQL Server
Lorraine,I’ve never had much luck with MAPI. Is it not possible to send a generic email from SQLServer out to the address of an SMTP server and then make Domino the SMTP server by switching on the SMTP listener? That would be simpler IMHO.
Ian
Subject: RE: Help in configuring mail support between Lotus Notes 6.5 and SQL Server
Worked for us…
Subject: Help in configuring mail support between Lotus Notes 6.5 and SQL Server
I am experimenting with a JMS approach to send to Domino from outside.
The problem with all approached that do not go throught the SMTP gateway is that they will need to logon.
In sunmmary, what we do know is that it is possible to do but you need to do a bit of work to your message when it arrives into Notes.
Here is the theory, application (say SQL Server 2000) sends a JMS (Java) message to the DIIOP port on Domino. It arrives in a common mail-box where it is forwarded on to the intended recipient.
This scheme does not use SMTP to deliver email, that is, you don’t need SMTP to be switched on.
Regards
Rolf Pfotenhauer