Use of SQL Server OLE Automation stored procedures for email

Discussion in 'Classic ASP' started by TheWhitGroup, Sep 17, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. TheWhitGroup

    TheWhitGroup

    We are in the process of migrating a site to discountasp.net and have run into an issue with our email implementation. The application utilizes SQL Server OLE Automation stored procedures for the email functionality. This requires that our admin user has the sysadmin fixed server role. This is not possible in the discountasp.net server environment.

    Has anyone run into this before? If so, what did you do to resolve it?

    Thanks!
     
    TheWhitGroup, Sep 17, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    this is not supported.

    You can create a simple asp.net application that query the database and send the email. You can then use the Task scheduler to hit the page.
     
    Bruce, Sep 17, 2009
    #2
  3. TheWhitGroup

    TheWhitGroup

    Thanks, Bruce!

    I appreciate your quick response
     
    TheWhitGroup, Sep 18, 2009
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page