Post reply

XPSMTP

  • August 14, 2007 at 9:24 am

    #153745

    XPSMTP from http://www.sqldev.net/xp/xpsmtp.htm is great for sending e-mail, but can it process incoming e-mails?

    Goal: We want to send short status messages to clients as a text message to their cell phones.  We want them to be able to reply via their phone with a two-digit code.  SQL Server to process the incoming message and update certain tables based upon the code.  Security factors aside for the moment, can this be done using xpsmtp?  A different smtp?

  • August 14, 2007 at 9:46 am

    #726844

    I've used XP_SMTP before and found it's pretty darned cool. But if you want to receive e-mails in 2000 you're going to want to use SQL Mail. But even still it looks more like what you want is some sort of mobile application as I don't think SQL Mail has quite this functionality (sp_processmail receives a message and executes the query in that message and returns it to the sender).

  • August 14, 2007 at 4:28 pm

    #726934

    Another option that avoids the sometimes, or maybe mosttimes, problems with SQL Mail is to build your own POP3 email reader. There are a number of examples at http://www.codeproject.com

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply