Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to capture email contain into sql server

    can somebody help me capture all field in email into database.for example the contain of email was like this

    Thanks for registering at CodingForums.com! We are glad you have chosen to be a part of our community and we hope you enjoy your stay.

    username:nanotect
    password:ekasam


    so how to capture username into username field and password into password field into sql server database

  • #2
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    This is actually possible with SQL Server and Exchange, but I can't give you much more useful information than that cos it's far too involved and I'm far too stupid. But basically you can give SQL Server a user account to get into Exchange with, and it'll be able to read all email sent to that account. Once you've actually got the two of them talking, writing some SQL to process the emails is relatively easy. Be prepared for significant hair loss in getting the two servers to talk to each other, though. And I'm not sure how, in your case, you'd go about stripping the usernames/passwords from the email body. SQL isn't really much cop as a string manipulation language. Anyway, Google "SQL Server Exchange account" or something like that if any of what I just babbled makes any sense.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •