Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 xp_sendmail and Lotus Notus

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-15 : 09:29:55
Mark Stafford writes "Hi All,
We have recently moved up from SQL 7 to SQL 2000 SP2. My organisation uses Lotus Notes as its email transport and so I have implemented email functionality for the SQL Server installation using a MAPI profile to the Lotus Notes R5 MAPI service 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 (and Microsoft) for information without success.
Would someone please enlighten me on why this happens and how to fix the problem
Many Thanks"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-15 : 09:33:27
According to our resident (former) MS Support Specialist, Chadmat, Access Violation errors occur due to known bugs with SQL Server. You should contact MS Product Support and give them all of the specifics. Since it is a bug, the case will be free of charge, and they might have a workaround for you.

Go to Top of Page
   

- Advertisement -