asp.net+access问题：在本地测试没有发现，但在服务器上出现“未指定错误”？

Question

asp.net+access问题：
在本地测试没有发现，但在网站服务器上却出现“未指定错误”？请问该如何处理，谢谢以下是错误信息：
-------------------------------------------------------------------------------------------------
“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------未指定的错误 
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: 未指定的错误源错误: 
行 10:         sjk.sql = "SELECT * from bbs"
行 11:         sjk.sjb = "bbs"
行 12:         sjk.lb()
行 13: 
行 14:         If Page.IsPostBack = False Then
 源文件: D:\ceshiroot\zpyzm2010\wwwroot\htbbs.aspx.vb    行: 12 堆栈跟踪: 
[OleDbException (0x80004005): 未指定的错误]
   System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +969373
   System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4863644
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.OleDb.OleDbConnection.Open() +40
   ClassLibrary1.db.Class1.lb() +136
   htbbs.Page_Load(Object sender, EventArgs e) in D:\ceshiroot\zpyzm2010\wwwroot\htbbs.aspx.vb:12
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 
----------------------------------------------------------------------------以下是数据库操作类代码 Public Class Class1
        Public dbConnectionString As String
        Public dbConnection As OleDbConnection
        Public command As OleDbCommand
        Public rdr As OleDbDataReader
        Public sql As String = ""
        Public sjk As String = ""
        Public sjb As String = ""
        Public dataset As DataSet
        Public dap As System.Data.OleDb.OleDbDataAdapter
        Public zt As Integer = 0
        Public lujing As String
        '---------------------------------连接ＡＣＣＥＳＳ数据库---------------
        Public Sub conn()
            Try
                dbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & lujing & "\sjk.mdb;Persist Security Info=true"
                dbConnection = New OleDbConnection(dbConnectionString)
            Catch ex As Exception
            End Try
        End Sub        Public Sub qz()
            conn()
            dbConnection.Open()
            command = New OleDbCommand(sql, dbConnection)
            rdr = command.ExecuteReader
        End Sub
        Public Sub lb()
            conn()
            dataset = New DataSet
            dap = New System.Data.OleDb.OleDbDataAdapter(sql, dbConnection)
            dbConnection.Open()
            dap.Fill(dataset, sjb)
            dbConnection.Close()
            dbConnection.Dispose()
            Return        End Sub        '----------储存信息－－－－－－－－－－－－－－－－－－－
        Public Sub save()
            zt = 0
            dbConnection.Open()
            command = New OleDbCommand(sql, dbConnection)
            If command.ExecuteNonQuery = 1 Then
                zt = zt + 1
            End If
            command.Dispose()
            dbConnection.Close()
            dbConnection.Dispose()
            Return
        End Sub        Public Sub delete()
            dbConnection.Open()
            command = New OleDbCommand(sql, dbConnection)
            If command.ExecuteNonQuery = 1 Then
            End If            dbConnection.Close()
            dbConnection.Dispose()
            Return
        End Sub
    End Class
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:2.0.50727.3603; ASP.NET 版本:2.0.50727.3082 

Answer 1

感觉你的sql变量声明的时候有问题  你可以试试写个属性
public string sql
{
   get{return _sql;}
   set{_sql = value;}
}

Answer 2

dbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & lujing & "\sjk.mdb;Persist Security Info=true"放到服务器上后对此句作相修改

Answer 3

Public Sub conn()
  Try
  dbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & lujing & "\sjk.mdb;Persist Security Info=true"
中的 liujing 好像没有赋值啊

Answer 4

lujing 不在数据操作类赋值的，而在按钮模块中赋值的    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        sjk.lujing = Server.MapPath("data\")        If Page.IsPostBack = False Then
            sjk.sql = "select * from gsjj"
            sjk.qz()
            Do While sjk.rdr.Read
                Label1.Text = sjk.rdr("gsbt").ToString
                Image1.ImageUrl = sjk.rdr("bsbjtp").ToString
                textarea.Value = sjk.rdr("gsnr").ToString
                Image2.ImageUrl = sjk.rdr("gszs1").ToString
                Image3.ImageUrl = sjk.rdr("gszs2").ToString
                Image4.ImageUrl = sjk.rdr("gszs3").ToString
                Image5.ImageUrl = sjk.rdr("gszs4").ToString
                Image6.ImageUrl = sjk.rdr("gszs5").ToString            Loop
        End If