Linked Server Unspecified Error 7303
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of ole db provider "microsoft.ace.oledb.12.0" for linked server returned message "unspecified error". this site About Us Learn more about Stack Overflow the company Business Learn ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)" more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
The Ole Db Provider "microsoft.ace.oledb.12.0" For Linked Server Reported An Error. Access Denied.
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; it only takes a minute: Sign up
Msg 7303, Level 16, State 1, Line 1
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 Microsoft Access Database Engine (64bit). This is in Visual Studio 2013 cannot initialize the data source object of ole db provider oraoledb.oracle for linked server 7303 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
Cannot Initialize The Datasource Object Of Ole Db Provider Msdasql For Linked Server (null)
Search related threads Remove From My Forums Answered the ole db provider "microsoft.ace.oledb.12.0" for linked server "(null)" does not contain the table by: 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 SQL Server > Transact-SQL Question 0 Sign in to vote I am trying to execute this Select against my excel file http://stackoverflow.com/questions/26267224/the-ole-db-provider-microsoft-ace-oledb-12-0-for-linked-server-null SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; HDR=NO; IMEX=1; Database=C:\Temp\test.xlsx', 'SELECT * FROM [Sheet1$]') I have followed every single step according to this article here http://visakhm.blogspot.ca/2013/12/how-to-solve-microsoftaceoledb120-error.html but still getting the same error as metioned in the title. Can anyone suggest what else could https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6f663ab8-c75d-419b-a4bf-bb6c0f5b84c4/ole-db-provider-microsoftaceoledb120-for-linked-server-null-returned-message-unspecified?forum=transactsql be wrong? The environment is SQL 2005 64 bit with Office 64 Bit drivers (Access 64 bit engine installed) Edited by BI Learner Friday, February 28, 2014 6:17 PM Friday, February 28, 2014 6:14 PM Reply | Quote Answers 2 Sign in to vote I just added Read/Write Rights on the folder C:\Users\
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows http://database.ittoolbox.com/groups/technical-functional/sql-server-l/error-ole-db-provider-microsoftaceoledb120-for-linked-server-null-returned-message-unspecified-error-5250640 < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca bracke iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES Sophos EdgeWave Skybot Software Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics linked server Database Groups Ask a New Question SQL Server The SQL Server group is a forum where peers share technical expertise, solve problems, and discuss issues related to Microsoft SQL Server. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and ole db provider 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error - OLE DB Provider 'Microsoft.ACE.OLEDB.12.0' for Linked Server '(Null)' Returned Message 'Unspecified Error' chprakash asked Jul 10, 2013 | Replies (7) Hi everyone, I am getting following error. "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)"." Could anyone help me out to resolve this problem? Regards, Prakash.ch Join this group Popular White Paper On This Topic 10 Critical Questions to ask a Manufacturing ERP Vendor 7Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... brett replied Jul 10, 2013 Has it ever worked? Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... John Warner replied Jul 10, 2013 Is the drive where the Access Database lives on the local (to SQL Serv
OleDB-SQL Utility SQL Server Excel SQL Server Export to Excel using SSIS SQL Server Export to Excel using bcp/sqlcmd and CSV SQL Server Export to Excel using bcp/sqlcmd and XML SQL Server Import to Excel using Excel Add-Ins Excel SQL Server Excel SQL Server Import-Export using VBA Excel SQL Server Import-Export using VSTO Excel SQL Server Import-Export using Excel Add-Ins Download Buy Contacts Excel Import to SQL Serverusing Distributed Queries Introduction This article describes the complete steps for Microsoft Excel data import to SQL Server using distributed queries technique. The article describes the steps for all modern platforms: Microsoft SQL Server 2005-2014 on the x86/x64 platform. Microsoft Excel 2003-2016 files like *.xls, *.xlsx, *.xlsm, *.xlsb. Bonus You may develop amazing Microsoft Excel applications for working with Microsoft SQL Server using database development skills only! Visit www.savetodb.com, download and install SaveToDB Add-In for Microsoft Excel. That's all! Connect to tables, views, and stored procedures, edit the data and save it back to a database. Add features to your Microsoft Excel applications step by step configuring apps via SQL. Table of Contents Introduction The basics of Excel Data Import to SQL Server Configuration steps for Excel data import to SQL Server Install Microsoft.ACE.OLEDB.12.0 driver Configure Ad Hoc Distributed Queries Grant rights to TEMP directory Configure ACE OLE DB properties How-To: Import Excel 2003 to SQL Server x86 How-To: Import Excel 2007 to SQL Server x86 How-To: Import Excel 2003/2007 to SQL Server x64 Conclusion See Also The Basics of Excel Data Import to SQL Server To import data from Microsoft Excel to SQL Server OPENROWSET and OPENDATASOURCE functions with OLE DB data source can be used. The basic for