That assembly does not allow partially trusted callers: How to solve that in VB2008?

[Tammie Dao]

I used VB.Net 2005 to get a dataset from SQL server database and write to a text file. I had connection string in app.config file. I published this console application to server with strong name key file. It worked nicely.

Recently, I have VS 2008 and would like to learn. I create a same project, create a new strong name key file in 2008, same procedures as the application in vb.net 2005. When I publish to the same server, it has an error, "An error occurred creating the configuration section handler for dataConfiguration: That assembly does not allow partially trusted callers. (V:\PayrollChecks\Bin\Payroll_Offcycle_Report.exe. config line 6)".

How do I solve this problem? What makes it work in vb 2005 but not in 2008?

Here are partial of the codes. The error happens at "Create Database" section.

Sub Main()
        On Error GoTo AppErr
        Dim ds As DataSet
        Dim db As Database
        Dim cmd As DbCommand
 
        Dim report As String
        Dim st As String
        Dim oFile As System.IO.FileInfo
        Dim fWriter As System.IO.StreamWriter = Nothing
 
        report = "D:\reports\PAYROLL_OFFCYCLE.rpt"
        oFile = New System.IO.FileInfo(report)
        If oFile.Exists() Then
            oFile.Delete()
        End If
 
        fWriter = New System.IO.StreamWriter(report, True)
 
        st = "Create Database:  "
        db = DatabaseFactory.CreateDatabase()
 
        st = "Assign Command:  "
        cmd = db.GetStoredProcCommand("Payroll_OffcycleCheck_Rpt")
 
        st = "Execute Command:  "
        ds = db.ExecuteDataSet(cmd)
...
End Sub
 
app.config file:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
        <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
    </configSections>
    <dataConfiguration defaultDatabase="database name"/>
    <connectionStrings>
        <add name="database name" connectionString="Persist Security Info=True;Data Source=database name;Server=server name;User ID=use id;Password=pw"             
         providerName="System.Data.SqlClient" />        
    </connectionStrings>    
</configuration>
 
 

Please help!

Thank you very much,

Tammie Dao