Solved

Use SQL Server to send mail via Lotus Notes

Posted on 1998-07-14
10
470 Views
Last Modified: 2010-03-19
I understand that Lotus Notes has a MAPI interface. How do I
get SQL Server to make the connection to Notes? I understand
the xp_sendmail stuff, it's the connection between SQL Server and Notes that I'm not sure of.
SQL Server 6.5, Notes version 4.5.2, on NT 4.0 sp3.
0
Comment
Question by:zimmy
  • 6
  • 3
10 Comments
 
LVL 2

Expert Comment

by:odessa
ID: 1091757
no SP xp_sendmail stands for that to send mail through MAPI you must configure your NT to be a mail client to Lotus Notes after that you can sending mail
0
 

Author Comment

by:zimmy
ID: 1091758
Odessa, sorry if my original question wasn't clear. You have restated the problem I'm trying to solve - '. . . configure your NT to be a mail client to Lotus Notes'

My original wording was 'the connection between SQL Server and
Notes'
0
 

Author Comment

by:zimmy
ID: 1091759
Adjusted points to 100
0
 

Author Comment

by:zimmy
ID: 1091760
Adjusted points to 200
0
 
LVL 2

Accepted Solution

by:
threshold earned 200 total points
ID: 1091761
There are 2 ways for SQL to connect other Mail Server than MS Exchange or MS Mail:
1. Configure the NT server to be an internet Mail Client:
    First, create a local account on the NT Server that installed MS SQL
    Allow the account to login locally, then login into server with the account
    Go to [Control Panel][Exchange(or Mail)] , Create a profile contains Internet Mail for current login.
    Try Exchange on Desktop to make sure the login can access Internet Mail via your Lotus Notes
    Then, re-login as Administrator, and configure the SQL Mail to use the Exchange Profile (with specifing login/password of the account  or profile name)
    And, the SQL mail will access the Notes Mail System via  xp_sendmail...

2. The MAPI(MS) of NT is unstable frequently.
    If you have to use your MAPI of Notes, You can write an Automation COM component for SQL Server.
    In MS SQL, there are several store procedure (sp_OAxxx) to access Automation COM.
    You can find some information about COM in Book Online - What's New. and you can write an Automation COM with VB5 simply.
    If you try in this way, you will find that it's not easy to transmmit long text data in stored procedures.
    Maybe, you will create more COM to help you process TEXT data in stored procedures(not easy).

3. Write a Program as Notes Client and SQL Client.
    It can get/insert data from MS SQL via ODBC and send/receive mail from Notes via MAPI of Notes,
    and it can be actived by timer. It seems to be stupid, but it's the most easy and stable method i thought.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:zimmy
ID: 1091762
Threshold,

I tried your process and got hung up trying to create a profile that would work. It asked me for five things:

-name: I entered the name that I logged on as.

-email address: Seems to be irrelevant. Besides, the server doesn't have an internet email address.

-internet mail server: I tried every combination I could think of  that pointed to my Notes server (name, ip address). Nothing worked.

-account name: I put in my Notes id.

-password: Easy. My Notes id is set up without a password.

After I created the profile I clicked on the Inbox to start it up. It tries to log on, is unsuccessful, and puts up a dialog box with Internet Mail Server, Account Name, and Password inputs. Nothing I seem to do works at this point

I don't understand the logic of creating an internet mail profile, but if you think it will work, and have any more ideas, I'll keep on trying.

Thanks.

Z.
0
 
LVL 2

Expert Comment

by:threshold
ID: 1091763
I didn't use Notes, but I am sure that Internet Mail should be supported by it.
Can you use the Netscape to receive/send mail via Notes?
If the answer is yes, Notes will support SMTP and POP3 protocol, and the Mailbox Profile will work with Notes.
The Profile need five fields to be filled:

Name : your full name to be displayed in mail (ie: Scott Chen)
Email Address : Your Email Address. It will be displayed in mail for replay. And It should be the mail address on Notes server.
                           (ie: scott@mynotes.mysite.com.tw)
Mail Server : the DNS address or IP address of your Notes, (ie: mynotes.mysite.com.tw)
Account : a login account of your Notes
password : the password of the login account above.

The setup is just like as Netscape Mail Client.
Make sure that you can receive mail with the Profile via Internet mail, then setup the SQL Mail to use the profile.

hope it will work.


0
 

Author Comment

by:zimmy
ID: 1091764
I don't mean to be rude, but if you don't KNOW the answer to a question, you probably shouldn't try answering it.

Lotus Notes is a proprietary workgroup/email software package. It can't use Netscape to send email, never could. The version I have doesn't support SMTP or POP3.

My question SPECIFICALLY mentioned MAPI.

Thanks for trying, though.
0
 
LVL 2

Expert Comment

by:threshold
ID: 1091765
So, I gived your 3 methods. And the 2nd/3rd one are the solutions you need.
Try the sp_OAxxx stored procedure, or write the xp_xxx for SQL Server by VC++.
It's the only way to let  MS SQL to access MAPI(Notes) directly.
Maybe, you can create SQL Client on your Notes, to let Notes to access SQL.
If I were you and I know about MAPI of Notes, I will create a SMTP/POP3 server as gateway between Nots and Internet Mail.
I know it's not easy, but it will be most useful solution. Try to search the gateway products on net or Lotus, maybe, there was one as you need.
0
 

Author Comment

by:zimmy
ID: 1091766
Threshold,

Thanks for trying. Sorry I took so long to respond; I was on vacation last week.

I've run out of time on this one, so I'm giving up on Notes and trying another approach (bcp/ftp/PROFS) to get the mail out.

Thanks again.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MSSQL 2014 Query Synthax 8 38
c# code 19 58
Updating variable table 9 17
MS SQL json query/where clause nested array items 2 39
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now