SQL Server Performance

Error in Addattachment

Discussion in 'SQL Server 2005 General Developer Questions' started by dineshasanka, Feb 5, 2006.

  1. dineshasanka Moderator

    I am Using CDO.Message to send mail from SQL Server. This was working fine in SQL Server 2000 and Windows Server 2000. Recently this was upgraded to SQL Server 2005 and Windows 2003 and noticed that error is occuring in this SP.
    After analysing I find that issue with the Addattchment function in the above class. I am getting error
    Output values of type Object are not allowed in result sets.

    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka
  2. mulhall New Member

    It seems that AddAttachment returns an object, but the result set handles strings.

    You can get around this by executing the procedure and parsing in variables rather than executing the result set.

    Check out this thread:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38239

Share This Page