Enterprise Library error: Request for the permission of type System.Data.SqlClient.SqlClientPermissi

[sumguyb]

I've written a Windows application using VB and Visual Studio 2005.
I've used the Data Application Block in the Microsoft Enterprise
Library 2.0 to make all of my SQL calls.

The application runs fine on my local machine but throws a CAS error
on client machines that says:

Request for the permission of type
System.Data.SqlClient.SqlClientPermission

I've read some posts that advise steps to take on the client machine
to overcome this such as granting more rights to different zones or
running caspol, but I have no control over settings on the client
machine. I can't make any changes whatsoever to the client machines
that run the code.

I can only make changes in my program. Is there a way to get around
this?

 

[Mr. Arnold]

I've written a Windows application using VB and Visual Studio 2005.
I've used the Data Application Block in the Microsoft Enterprise
Library 2.0 to make all of my SQL calls.

The application runs fine on my local machine but throws a CAS error
on client machines that says:

Request for the permission of type
System.Data.SqlClient.SqlClientPermission

I've read some posts that advise steps to take on the client machine
to overcome this such as granting more rights to different zones or
running caspol, but I have no control over settings on the client
machine. I can't make any changes whatsoever to the client machines
that run the code.

I can only make changes in my program. Is there a way to get around
this?

Well, you need to setup .Net rights for the application on the client
machine so that the application works. You're not coming around the issue
programming wise I think, where as, you can program your way out of it.

Maybe, you need a setup package that will run caspol for you during the
install. The link may help you to determine if that is the approach you need
to take.

http://msdn2.microsoft.com/en-us/library/aa168860(office.11).aspx