Microsoft.ace.oledb.12.0 For Linked Server Null Reported An Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ole db provider "microsoft.ace.oledb.12.0" for linked server returned message error". and policies of this site About Us Learn more about Stack Overflow the ole db provider "microsoft.ace.oledb.12.0" for linked server reported an error. access denied. the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation the ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)" does not contain the table Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; cannot fetch a row from ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)". it only takes a minute: Sign up The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” up vote 8 down vote favorite 1 I'm trying to run the following statement but am receiving the error messages just below. I have researched answers to no end and none have worked for me. I'm running Office 365 (64bit). I have loaded the
Msg 7303, Level 16, State 1, Line 1
Microsoft Access Database Engine (64bit). This is in Visual Studio 2013 with SSDT as well as SQL Server 2012. I do not have access to changing environment or startup parameters to SQL Server. Any help is appreciated. SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.15.0', 'Excel 12.0;Database=C:\Users\UserName\Folder\SomeFile.xlsx;;HDR=NO;IMEX=1', [Table 1$]) Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.15.0" for linked server "(null)". Here's what I have tried: First, I ran... sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE; GO Followed by...with no love. EXEC sys.sp_addsrvrolemember @loginame = N'<
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ
Msg 7303 Level 16 State 1 Line 1 Cannot Initialize The Data Source Object Of Ole Db Provider
Search related threads Remove From My Forums Answered cannot initialize the data source object of ole db provider oraoledb.oracle for linked server 7303 by: How resolve error OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned microsoft.ace.oledb.12.0 linked server message "Unspecified error" SQL Server > Transact-SQL Question 0 Sign in to vote Error: OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server http://stackoverflow.com/questions/26267224/the-ole-db-provider-microsoft-ace-oledb-12-0-for-linked-server-null "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". I am using the following query select * from openrowset('Microsoft.ACE.OLEDB.12.0' ,'Excel 12.0;Database=\\abc\k\excel.xlsx',[sheet1$]) driverMicrosoft.ACE.OLEDB.12.0 installed https://social.msdn.microsoft.com/Forums/sqlserver/en-US/475c4d52-e60b-4f3e-bb60-c1be56e34fd4/how-resolve-error-ole-db-provider-microsoftaceoledb120-for-linked-server-null-returned?forum=transactsql and configure properly. Any help ? Thursday, April 09, 2015 12:18 PM Reply | Quote Answers 0 Sign in to vote See if this helps http://visakhm.blogspot.ae/2013/12/how-to-solve-microsoftaceoledb120-error.htmlPlease Mark This As Answer if it solved your issue Please Vote This As Helpful if it helps to solve your issue Visakh ---------------------------- My Wiki User Page My MSDN Page My Personal Blog My Facebook Page Marked as answer by pituachMVP, Moderator Saturday, May 14, 2016 11:11 PM Thursday, April 09, 2015 12:28 PM Reply | Quote 0 Sign in to vote Check this link:http://sqlwithmanoj.com/2012/07/10/querying-excel-2010-from-sql-server-in-64-bit-environment/ You might need to register the ACE OLEDB provider, go thru all the steps I've mentioned in my blog, may help. Are you getting any other error also? ~manoj | email: http://scr.im/m22g http://sqlwithmanoj.wo
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question http://www.codeproject.com/Questions/692004/The-OLE-DB-provider-Microsoft-ACE-OLEDB-for-l View Unanswered Questions View All Questions... Linux questions C# questions ASP.NET questions SQL questions fabric questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / http://visakhm.blogspot.com/2013/12/how-to-solve-microsoftaceoledb120-error.html Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & linked server Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird for linked server & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Rate this: Please Sign up or sign in to vote. See more: SQL Server when i try to import ms excel to sql server table this msg will come... i want to import data from ms excel sheet to sql server table Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" Posted 3-Dec-13 22:37pm meranaamshahul390 Updated 3-Dec-13 22:54pm v2 Add a Sol
error message OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". And finally managed to solve it! Thought of sharing the steps I went through for others benefit. Problem statement When trying to use Microsoft.ACE.OLEDB.12.0 provider in a linkedserver or distributed query you'll get the above error. Environment Win 7/vista 32 bit, SQL Server 2008 R2 SP! Steps to resolve Check the following steps Step 1: Check the In Process and Dynamic Provider options for the ACE provider This can be done through T-SQL statement or through GUI T-SQL command Use the below command to set the properties EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters', 1 GO
GUI
Connect to server instance through SQL Management Studio. Expand Server -> Server Objects -> Linked Servers -> Providers -> Microsoft.ACE.OLEDB.12.0. Right click choose properties.Select the Dynamic Provider and Allow inProcess properties as shown below Step 2: Check the permissions on the Temp folder This is needed because the provider uses the temp folder while retrieving the data. The folder can be one of the below based on whether you use a local system account or network domain account. For network accounts, folder is :\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp and for local system account its:\Windows\ServiceProfiles\LocalService\AppData\Local\Temp Right click on this folder and give it read write access to the account executing the code. Step 3: Check the MemToLeave memory area allocated This was the step I took maximum time