Post reply

Sending SQL Notifications with CDOSYS

  • April 1, 2009 at 2:36 pm

    #970229

    I have added several propertities to use google smtp as smtp server

    But I get the error "Description: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first. 28sm166958fxm.4"

    It is rather strange cause I enabled SMTPUseSSL

    Does any one have ideas?

    EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/SendUsing").Value','2'

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

    EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusingport").Value', '465'

    EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SMTPUseSSL").Value',True

    -- SMTPAuthenticate

    EXEC @hr = sp_OASetProperty @iMsg,

    'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate").Value',1

    --0 is do not authenticate

    --1 is Use basic (clear-text) authentication. The configuration

    --sendusername/sendpassword or postusername/postpassword fields are used

    --to specify credentials.

    --2 Use NTLM authentication. The current process security context is used

    --to authenticate with the service. Integrated security.

    EXEC @hr = sp_OASetProperty @iMsg,

    'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SendUsername").Value','myAdr@gmail.com'

    EXEC @hr = sp_OASetProperty @iMsg,

    'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SendPassword").Value','myPass'

Viewing post 16 (of 15 total)

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