Upgrading Windows Application to VS2008

[=?Utf-8?B?SGVsZW4gVHJpbQ==?=]

I have a Windows application that was developed in VB in VS2003. It
accesses data from a SQL Server 2000 database.

I have recently upgraded it to VS2008. It runs perfectly on my pc, but it
will not run on the users pcs, though the old version does.

The error is: System.Security.SecurityException-Request for the permission
of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version
2.0.0.0. Unable to connect to the database.

Any ideas what the problem is and how I can solve it?

Thanks,
Helen

[rowe_newsgroups]

On Oct 13, 10:55*am, Helen Trim <[e-mail]>
wrote:

I have a Windows application that was developed in VB in VS2003. * It
accesses data from a SQL Server 2000 database.

I have recently upgraded it to VS2008. *It runs perfectly on my pc, butit
will not run on the users pcs, though the old version does.

The error is: System.Security.SecurityException-Request for the permission
of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version
2.0.0.0. *Unable to connect to the database.

Any ideas what the problem is and how I can solve it?

Thanks,
Helen

Did you modify the code access privileges for the .NET 1.1
application? If you you will (most likely) need to set up the same
for .NET 2.0. Also, if you have the application deployed on a network
drive, having the users download and install .NET 3.5 SP1 should fix
the problem. Code Access Security was changed in the service pack to
remove the need to modify the configuration files for allowing apps to
run off a local network.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[=?Utf-8?B?SGVsZW4gVHJpbQ==?=]

Hello Seth

Thanks. I downloaded the service pack and it worked. Hooray!

Cheers
Helen

"rowe_newsgroups" wrote:

On Oct 13, 10:55 am, Helen Trim <[e-mail]>
wrote:

I have a Windows application that was developed in VB in VS2003. It
accesses data from a SQL Server 2000 database.

I have recently upgraded it to VS2008. It runs perfectly on my pc, but it
will not run on the users pcs, though the old version does.

The error is: System.Security.SecurityException-Request for the permission
of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version
2.0.0.0. Unable to connect to the database.

Any ideas what the problem is and how I can solve it?

Thanks,
Helen

Did you modify the code access privileges for the .NET 1.1
application? If you you will (most likely) need to set up the same
for .NET 2.0. Also, if you have the application deployed on a network
drive, having the users download and install .NET 3.5 SP1 should fix
the problem. Code Access Security was changed in the service pack to
remove the need to modify the configuration files for allowing apps to
run off a local network.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[rowe_newsgroups]

On Oct 14, 10:39*am, Helen Trim <[e-mail]>
wrote:

Hello Seth

Thanks. *I downloaded the service pack and it worked. *Hooray!

Cheers
Helen

"rowe_newsgroups" wrote:

On Oct 13, 10:55 am, Helen Trim <[e-mail]>
wrote:

I have a Windows application that was developed in VB in VS2003. * It
accesses data from a SQL Server 2000 database.

I have recently upgraded it to VS2008. *It runs perfectly on my pc,but it
will not run on the users pcs, though the old version does.

The error is: System.Security.SecurityException-Request for the permission
of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version
2.0.0.0. *Unable to connect to the database.

Any ideas what the problem is and how I can solve it?

Thanks,
Helen

Did you modify the code access privileges for the .NET 1.1
application? If you you will (most likely) need to set up the same
for .NET 2.0. Also, if you have the application deployed on a network
drive, having the users download and install .NET 3.5 SP1 should fix
the problem. Code Access Security was changed in the service pack to
remove the need to modify the configuration files for allowing apps to
run off a local network.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

Glad it worked - having the users download the service pack is much
easier than trying to push out the msi that change the security
settings.

At some point the service pack will become available through Window's
Update, which will make our lives even easier.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/