問題描述
這不是問題，但這篇文章可能對社區有用，因為我在互聯網上找不到答案.
This is not a question, but this post may be useful for community because I could not find the answer on the Internet.
經過測試
- Windows 2008 R2 x64 和 Windows 2003 x64
- SQL Server 2008 SP3 x64
- 提供程序 Microsoft.ACE.OLEDB.12.0 x64
SQL Server 在非本地計算機管理員的域帳戶下運行.SQL Server 連接身份驗證是 Windows.
SQL Server is running under domain account that is not admin of local machine. SQL Server connection authentication is Windows.
問題是:
在使用此提供程序創建和使用鏈接服務器或臨時查詢時，您可能會收到如下錯誤:
when creating and using a linked server or adhoc querying using this provider, you may receive errors like these:
OLE DB 提供程序MSDASQL"用于鏈接服務器xxx"返回消息[Microsoft][ODBC 驅動程序管理器] 驅動程序的 SQLSetConnectAttr 失敗"
OLE DB provider "MSDASQL" for linked server "xxx" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
OLE DB 提供程序MSDASQL"用于鏈接服務器xxx"返回消息[Microsoft][ODBC dBASE 驅動程序]您的網絡訪問被中斷.要繼續，請關閉數據庫，然后再次打開.
OLE DB provider "MSDASQL" for linked server "xxx" returned message "[Microsoft][ODBC dBASE Driver] Your network access was interrupted. To continue, close the database, and then open it again.
無法初始化 OLE DB 提供程序MSDASQL"的數據源對象；對于鏈接服務器xxx"
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "xxx"
找不到可安裝的 ISAM
Could not find installable ISAM
OLE DB 提供程序MSDASQL"用于鏈接服務器xxx"返回消息[Microsoft][ODBC dBASE 驅動程序]一般錯誤無法打開進程 0x16f4 線程 0x2728 DBC 0x1ce64ae8 Xbase 的注冊表項臨時(易失性)Ace DSN'
OLE DB provider "MSDASQL" for linked server "xxx" returned message "[Microsoft][ODBC dBASE Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x16f4 Thread 0x2728 DBC 0x1ce64ae8 Xbase'
原因是提供程序使用用戶連接的憑據在 SQL Server 域帳戶的臨時文件夾中創建了一個臨時文件.普通用戶沒有這樣的權限.
The reason is that the provider creates a temporary file in SQL Server's domain account's temporary folder, using user connect's credentials. Ordinary users does not have such permissions.
推薦答案
解決方案是
授予 Sql Server 域帳戶臨時文件夾上的 sql server 用戶修改"權限.這個文件夾通常是
The solution is
grant "Modify" permission to sql server users on Sql Server's domain account's temporary folder.
This folder ordinarily is
- Windows 2003:c:\Documents 和Settings\sql_server_account_name\Local Settings\Temp\"
- Windows 2008:C:\Users\sql_server_account_name\AppData\Local\Temp\"
這篇關于查詢“Microsoft.ACE.OLEDB.12.0"時出錯來自 SQL Server 的提供程序的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！