Post reply

Service Pack

  • September 29, 2005 at 4:11 pm

    #594210

    Search for: cdoSMTPServerName

    Change it to 'your.fully.qualified.dnsname' or 'your.ip.add.ress'

     

    ... and Yes, the server name or IP address need to be supplied by your network or email admins.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 30, 2005 at 10:47 am

    #594375

    Hooray, the sp works.  Thanks!! charger

  • August 28, 2007 at 1:02 pm

    #729898

    So I used the same stored procedure and everything was working fine until a couple of days ago. Then all of a sudden it stopped working.

    I get the following rows in my error table.

    NULL;Failed at sp_OASetProperty sendusing

    Description: A dynamic link library (DLL) initialization routine failed.;

    sp_OAGetErrorInfo for sp_OASetProperty sendusing

    But if i'm reading it correctly then there's something wrong with this statement?

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

    Which i don't think is the case since it worked before. Any clues on how i can narrow this down to the source of the problem?

    Thanks!

    Nam

  • August 28, 2007 at 1:51 pm

    #729910

    I cut out the URL and apparently MS has moved the page !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 17, 2007 at 8:32 am

    #760707

    I am having the same issue. Running SQL 2005, the stored proc works for a period of time and then suddenly it stops working giving the DLL initialization error when setting the sendusing parameter. I have tried both 1 (local pickup) and 2 (remote server) and both behave similarly. Once I restart the SQL service the emails start working again (for god knows how long). What's going on? If the URL is the issue (i.e. MS has moved it) then it should never work, right?

  • December 17, 2007 at 1:26 pm

    #760808

    Fyi... i solved this issue a different way... see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2564725&SiteID=1

  • December 18, 2007 at 9:14 am

    #761089

    not sure why you have two objects for mail..

    bin the Imsg one.

    here is my working sample of the same code

    set msg = CreateObject("CDO.Message")

    msg.From = "sql.server@businessName.com"

    msg.To = "joebloggs@businessName.com"

    msg.Subject = "Your Web Log for " & date()

    msg.HTMLBody = " "

    msg.Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "2sfg-exchange"

    msg.Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

    msg.Configuration.Fields.Update

    msg.Send

    set msg = nothing

    good luck..

  • December 18, 2007 at 9:18 am

    #761095

    Doh.. sorry, I really should look to see if there are other pages.. ffs... going home... 🙁

  • December 18, 2007 at 11:53 am

    #761180

    Did I read somewhere that you can not install SP 4 on a SQL 2000 machine running on an NT4 box?

  • May 20, 2010 at 1:43 am

    #1169907

    Hi,

    How can i use this mail sending option to send mail alert to users when job failes at Sql Agent other than creating failure step in sql agent job ?

    Thanks in Advance

Viewing 10 posts - 16 through 24 (of 24 total)

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