XSLT Extension function that executes SQL statement

20 Nov 2005 4:38 AM

Buddy Ackerman

I've created an Extension Object for use in XslTransforms. One of the
methods in this class connects to a SQL Server database and execute a sql
statement. However, it returns the following error:

Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.

This only happens when this function is called from the xsltransform. Is
there any way around this error that doesn't involve modifying machine level
config files or machine level security as this application runs on server at
various hosting providers possibly in shared hosting environments?

Thanks

--Buddy

20 Nov 2005 9:21 AM

luxspes

Maybe this link could be helpful for you:
http://dotnetjunkies.com/WebLog/alan.dean/archive/2005/04/19/69129.aspx

Buddy Ackerman wrote:
Show quote

> I've created an Extension Object for use in XslTransforms. One of the
> methods in this class connects to a SQL Server database and execute a sql
> statement. However, it returns the following error:
>
> Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
>
>
> This only happens when this function is called from the xsltransform. Is
> there any way around this error that doesn't involve modifying machine level
> config files or machine level security as this application runs on server at
> various hosting providers possibly in shared hosting environments?
>
> Thanks
>
>
> --Buddy
>
>