Post reply

Sending SQL notifications with CDOSYS

  • April 12, 2006 at 3:22 pm

    #171171

    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.

     

     

     

  • April 12, 2006 at 3:39 pm

    #632225

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

  • April 13, 2006 at 3:27 pm

    #632536

    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.

  • April 14, 2006 at 2:43 am

    #632572

    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