Sending SQL notifications with CDOSYS

  • Hi,

    -- This is to configure the Server Name or IP address.

    -- Replace MailServerName by the name or IP of your SMTP Server.

    EXEC sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas. microsoft.com/cdo/configuration/smtpserver").Value', 'MailServerName'

    How and where can i get the information as to what is the MailServerName or IP of SMTP server.

    Thnx.

     

     

     

  • Speak with yor provider. Otherwise speak with the server admin for the mail server.

  • do you use Microsoft Outlook?  i'm using Outlook 2003.  if you are using Outlook, try selecting 'Tools' from the toolbar at the top, then 'Email Accounts...'.  From the wizard that pops up, click 'Next', then 'Change'.  your current settings will be displayed, your 'Microsoft Exchange Server' is your SMTP server.

  • Hi ,

     

    Why dont you use the xp_smtp_sendmail ? its flexible and easy to implement. Its available free and tested on 7.0 and 2000

    Regards,

    Deepak Uniyal

     

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

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