Microsoft.ACE.OLEDB.12.0提供程序未注冊我有一個帶有兩個項目的Visual Studio 2008解決方案(一個Word-Template項目和一個用于測試的VB.Net控制臺應用程序)。這兩個項目都引用一個數據庫項目,該項目打開與MS-Access 2007數據庫文件的連接,并引用System.Data.OleDb。在數據庫項目中,我有一個函數,它按如下方式檢索數據表 private class AdminDatabase
' stores the connection string which is set in the New() method
dim strAdminConnection as string
public sub New()
...
adminName = dlgopen.FileName
conAdminDB = New OleDbConnection
conAdminDB.ConnectionString = "Data Source='" + adminName + "';" + _
"Provider=Microsoft.ACE.OLEDB.12.0"
' store the connection string in strAdminConnection
strAdminConnection = conAdminDB.ConnectionString.ToString()
My.Settings.SetUserOverride("AdminConnectionString", strAdminConnection)
...
End Sub
' retrieves data from the database
Public Function getDataTable(ByVal sqlStatement As String) As DataTable
Dim ds As New DataSet
Dim dt As New DataTable
Dim da As New OleDbDataAdapter
Dim localCon As New OleDbConnection
localCon.ConnectionString = strAdminConnection
Using localCon
Dim command As OleDbCommand = localCon.CreateCommand()
command.CommandText = sqlStatement
localCon.Open()
da.SelectCommand = command
da.Fill(dt)
getDataTable = dt
End Using
End FunctionEnd Class當我從我的Word 2007模板項目中調用此函數時,一切正常; 沒有錯誤。但是當我從控制臺應用程序運行它時會拋出以下異常ex = {“'Microsoft.ACE.OLEDB.12.0'提供程序未在本地計算機上注冊?!眪兩個項目具有相同的引用,并且控制臺應用程序在我第一次編寫時(前一段時間)確實有效,但現在它已停止工作。我必須遺漏一些東西,但我不知道是什么。有任何想法嗎?
添加回答
舉報
0/150
提交
取消