May 11, 2002 at 10:36 pm
Hi All,
We have recently moved up from SQL 7 to SQL 2000 SP2. My organisation uses Lotus Notes as its email provider and so I have implemented email functionality for the SQL Server installation using a MAPI profile to the Lotus Notes MAPI provider which then sends the email through the Lotus Notes system.
In this configuration SQL Server Email is working fine from the sqlserveragent but when I use xp_sendmail from within a T-SQL stored procedure the following error is returned each time:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I had set the Lotus Notes user id file password to blank.
I have spent several hours combing the web for information without success.
Would someone please enlighten me on why and how to fix the problem
Many Thanks
May 12, 2002 at 9:15 am
This has been asked about on two other occasions and this was what cam of that. See thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2708&FORUM_ID=48&CAT_ID=1&Forum_Title=Service+Packs&Topic_Title=SQL+2000+SP+2+and+sendmail
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 13, 2002 at 11:07 am
There is a hot fix out for this that has been released to those that have called MS for support. I will check with the MS contact to see when it is going public and post information.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 13, 2002 at 2:32 pm
I went to the aforementioned thread WRT reverting back to SP1 sqlmap70.dll - it doesn't fix the issue. xp_sendmail says it has sent the email but nothing appears in the respective user's email inbox.
In terms of the hot fix, great ! I will fire up our local MS support.
thanks
July 28, 2002 at 3:45 pm
Hi All, The answer from Microsoft Support is that the SQL Server 2000 / Outlook (any version) / Lotus Notes MAPI transport combo will not work on Win2000 Adv server as they believe the Lotus Notes part of the solution does not comply with the MAPI standard in Win2000. Interesting to note that the Lotus Notes solution works well with SQL 7 SP3 / Outlook (any version) on WinNT 4 SP 6a... They could not specify what the difference was except to say that the Lotus Notes MAPI interface was not 100% compliant. I can accept that as the respective Lotus Notes MAPI transport web page at IBM did not cite Win2000 as a tested platform.
Still, I am OK as during the waiting period I changed the SQL Server emailing solution to the following:
1. Created an email staging table in the source SQL 2000 dB
2. Created a small target dB in a SQL 7 / WinNT server with an
identical table to step 1 (this SQL installation has Lotus Notes
installed)
3. In the SQL 2000 installation:
a. Set up a linked server to the SQL 7 staging database
b. Replaced the xp_sendmail call with an insert statement to write
the email variables to the local staging table
c. Set up a job to move the contents of the local staging table to
the linked server target dB every 5 minutes
In the linked server target dB:
a. Set up a job to go through each row in the staging table and build
a complete xp_sendmail command and execute (this job fires each 5 min)
This solution is working well.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply