xp_startmail runs forever??

xp_startmail runs forever??

Post by Sam » Tue, 29 Aug 2000 04:00:00

I am trying to set up SQLMail using Outlook 2000 with Yahoo smtp/pop
mail server.
I create a NT mail profile and outlook2000 can receive and send mail
using this profile.
Then I log in the MSSQLServer and SQLAgentMail using the Administrator
When I click "Test" from the Mail session, the 'Task manager
Application' indicates the SQL Server 7 "no response" and then hangs.
When I tried to use Query Analyzer to exec master.dbo.xp_startmail it
runs forever with no result.

The xp_startmail at master point to the path: sqlmap70.dll

I am currently using NT Server 4.0 SP6,  SQL Server 7.0 SP2, Outlook2000

The mapi32.dll file is 128KB, version 1.0.2536.0 at both winnt\system32
and program files

Thanks for your help!



xp_startmail runs forever??

Post by Neil Pik » Wed, 30 Aug 2000 04:00:00


 Have you tried the smtp FAQ entry?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or    http://www.ntfaq.com/Section.cfm?sectionID=34
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq