HELP - Novell & .Net & MS SQL Server?
Posted on 2006-05-10
I am having a problem with this VB.NET code when trying to connect to SQL Server.
At home it works, at work there are prolbems.
Home computer is a stand alone computer runninw Window XP and SQL Server 2000.
Work computer is a Novell Network made up of:
MSSQL Server 2000
This code works when I run a copy of the program that is on the Citrix or SQL Server drive, but if run from a Novel drive (no matter which computer I’m running it from) it fails
This is the error that I get:
Application attempted to perform an operation not allowed by the security policy. To grand this application the required permission, contact your system administrator, or use the Microsoft .NET Framework Configuration too.
Request for the permission of type
Dim c As String = "Data Source=SQL;Initial Catalog=AhavaOrder;Integrated Security=True"
Dim conn As New SqlConnection(c)
Dim cmd As SqlCommand = New SqlCommand("select * from tblItem", conn)
cmd.CommandType = CommandType.Text
Dim reader As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)