SQL Server 2005 Notification Services

  • Hi

    We are migrating SQL server 2000 Notification Instances to SQL Server 2005. We were using XSLT for forming mail format. In XSLT we have javascript functions. In SQL Server 2005 we are getting following error:

    Description: The XSL transform is not valid.

    EventParameters:

      XSLT Transform File: E:\Notificationservices\XX.xslt

    Description: Execution of scripts was prohibited. Use the XsltSettings.EnableScript property to enable it. An error occurred at E:\Notificationservices\XX.xslt(56,9).

    InstanceName: AA

    Component: Other

    ComponentDetails: ComponentName: XsltFormatter

    Thread: 4

    Please help us where need to set this property.

    In SQL server 2000 Notification this was working fine.

    Thanks,

    Gagan

  • This was removed by the editor as SPAM

  • Any immediate response will be of great help! It is blocking our release.

    We configure the XSLT formatter in the ADF file using following tags:

    <ContentFormatter>

                            <ClassName>XsltFormatter</ClassName>

                            <Arguments>

                                        <Argument>

                                                    <Name>XsltBaseDirectoryPath</Name>

                                                    <Value>%_BaseDirectoryPath_%\Notificationservices\</Value>

                                        </Argument>

                                        <Argument>

                                                    <Name>XsltFileName</Name>

                                                    <Value>ApplyJoinNotice.xslt</Value>

                                        </Argument>

                                        <Argument>

                                                    <Name>DisableEscaping</Name>

                                                    <Value>true</Value>

                                        </Argument>

                            </Arguments>

    </ContentFormatter>

     

    After that Notification services send the Notification using this formatter and our application don’t have any control over that.

     

    We are not getting where we should put the following code to enable it.

     

    Thanks in advance.

     

  • I've not worked with this before so can't help you directly, but you might want to try here:

    http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=97&SiteID=1

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

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