Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
Error when trying to connect to SQL 2000 DB

Question Error when trying to connect to SQL 2000 DB

  • mardi 13 décembre 2005 21:18
     
     
    Connectez-vous pour voter
    0
    Hi,
       I'm a VB 6 user, trying to create something in .NET 05 for the first time.  I am trying to create a connection to a SQL 2000 DB and this is my code:

    conSQL = New SqlClient.SqlConnection

    Dim connectStringBuilder As New SqlClient.SqlConnectionStringBuilder()

    connectStringBuilder.DataSource = "CMASQL"

    connectStringBuilder.InitialCatalog = "ROGS"

    connectStringBuilder.IntegratedSecurity = True

    Dim myConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection(connectStringBuilder.ConnectionString)

    myConnection.Open()

    However, I get the following error consistently and the process fails:
    Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

    I have no idea where to look to solve this issue, nor why it is occuring.  Any help would be appreciated.  Thanks!