'System.Security.SecurityException' with .NET 2005 Only

[steveeisen]

microsoft.public.dotnet.languages.vb.upgrade isn't getting much
traffic, so I'll try here.

Ours is a VB6 shop exploring .NET.


First I wrote a new application with VB .NET 2003 to create a pdf
Crystal Report from a SQL Server 2000 table. I followed advice from
the MSDN article "Add Professional Quality Reports to Your Application
with Visual Studio .NET"
(http://msdn.microsoft.com/msdnmag/issues/02/05/Crystal/), and it
worked fine.


Then we got in VB .NET 2005, and I tried to open this solution
there, with the idea of deploying it as our first .NET server app in a
few days. The Wizard seemed to take it from 2003 to 2005 with no
problem, and I get a clean build. However, when I run, I can't connect

to the test SQL Server I've been using even though I am an
administrator.


Here's the code:


Friend WithEvents scnSQLConnection As _
System.Data.SqlClient.SqlConnection
Friend WithEvents sdaDataAdapter As _
System.Data.SqlClient.SqlDataAdapter
Friend WithEvents ndsMain As MySolutionName.MyDatasetClassName
.. . .
Public Sub FrmThatHasCrystalViewer_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
scnSQLConnection.ConnectionString = _
"Persist Security Info=False;Integrated Security=SSPI;database=" & _

"MyDatabase;server=OurTestSQLServer2000"
sdaDataAdapter.Fill(ndsMain)


It fails on the line above and, in the immediate window, I get:


A first chance exception of type 'System.Security.SecurityException'
occurred in System.Data.dll


When I click on view detail, I get:


System.Security.SecurityException was unhandled
Message="Request for the permission of type
'System.Data.SqlClient.SqlClientPermission,
System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed."
Source="mscorlib" . . .


The dialog box suggests clicking on "Add Permission to the Project." I

did that, and get a dialog box saying "The new permission has been
added to your application. However, the change will not take effect
until the debugging session is restarted."


Restart the debugging session, same problem again. Go all the way of
VS and back in again, still same problem. Reboot, same problem.


I could deploy the VS 2003 build, but it would be nicer startingt off
with a consistent current version inventory, not to mention that I
would like to understand more.


All ideas and suggestions will be appreciated.


Steve Eisenberg

 

[Jim Hughes]

Please show how you are initializaing the variablles and the sql text.

Does the same sql text work from Query Analyzer under the same user
credentials?

 

[+Vice]

This is most likely caused by your project residing in an old folder that
doesn't have the necessary .Net security permissions. When you open the
project you may have received an error message stating something about
unsafe location. Also, this would happen if you save your project to a
network folder that is not a part of the .Net security framework. I can't
recall everything to be exact but the quickest way to test to see if this is
the case is to save your project to the project folder the initial VB.net
installation has created for you and run it from there. Read more about the
..Net Configuration tool to setup your security for a networked folder.

 

[steveeisen]

This is most likely caused by your project residing in an old folder
that doesn't have the necessary .Net security permissions.

Yep. Just the kind of error a newbie might and did make.

Usenet still rocks for this kind of stuff.

Thanks to +Vice for the solution and Jim Hughes, who probably would
have gotten me there also.