You cannot delete your own topics. How to block Hot Network Questions in the sidebar of Stack Exchange network? Join them; it only takes a minute: Sign up SQL Server: Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” up vote 3 down vote Insults are not welcome. Source
up vote 0 down vote I also met this issue and did the steps as yours,finally I met the error as yours. The provider did not give any information about the error.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".Could Not the answer you're looking for? Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "220.127.116.11". http://dba.stackexchange.com/questions/36687/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoft-ace-oledb
Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Acess Database Engine x64 is installed, all Office products are 64-bit, and my SQL Server is also 64 bit. Reply danthman None 0 Points 16 Posts Re: Linked Server: Cannot initialize the data source object Feb 13, 2009 04:56 PM|danthman|LINK Thanks very much, Jian. I have created linked server by using option "Be made using this security context".
Do you need your password? This is my query: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\dataSource.xls;HDR=YES', 'SELECT * FROM [Foglio1$]') I get the following error message (mine is in italian, here is the english version): OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)" When testing the connection, it works properly, but when running queries, this error message is received:Msg 7399, Level 16, State 1, Line 1The OLE DB provider "MSDASQL" for linked server " Microsoft Sql Server Error 7303 Linked Server Does Wand of the War Mage apply to spells cast from other magic items?
Posted by mje113 on 9/9/2008 at 2:16 AM I am also having this problem just after a system restart. Default Authentication = Connect. But it worked so I am happy. –Warren Mar 5 '14 at 0:59 Without the permission fresh shared, you will only be able to run the script locally by check these guys out So I went ahead and created linked server.
Give full rights to these accounts. Cannot Initialize The Data Source Object This operation will be tried later!', 16, 2 ); -- OR BEGIN TRY EXEC sp_testlinkedserver N'LnkSrv_RemoteServer_TEST'; END TRY BEGIN CATCH PRINT 'Linked Server not available'; RETURN; END CATCH ---------------------------------------------------------------------------------------------------------- -- Get why do they give the same output? Import excel data with OPENROWSET on production server - by Riaz Bashir Status : Closed as Not Reproducible Not Reproducible The product team could not reproduce this item with the
sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1 GO EXEC master . read this post here Is there a fix for this bug yet? Cannot Initialize The Datasource Object Of Ole Db Provider Msdasql Authentication failed.Msg 7303, Level 16, State 1, Procedure sp_testlinkedserver, Line 1Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "SQL16NODEB\SQL2014".The message "Invalid authorization specification" means that Cannot Initialize The Datasource Object Of Ole Db Provider Oraoledb.oracle For Linked Server Success!
You cannot post or upload images. And that is not user-rights related, as usually suggested. To make sure of the account, press Windows Key + R to get a run prompt, and enter services.msc to bring up the services console. have a peek here Terms of Service Layout: fixed | fluid CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Close Messages"HomePlatformConfiguration Management Database (CMDB)LoginCancel changesDiscard all changes?NoYesClose MessagesTroubleshooting Linked Server20324
I've just gone out for a quick meeting and suddenly I get the error "Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"" I've made Microsoft Sql Server Error 7303 Mysql If not, you need to install the Microsoft Access Database Engine (either x86 or x64 depending on your SQL server install) which will install the provider for you. Quit Registry Editor. => Clear the contents in the TEMP directory. => Now try re-running the linked server query from this limited user. Let me know if this doesnt
All-Star 28639 Points 2444 Posts Re: Linked Server: Cannot initialize the data source object Feb 14, 2009 04:14 AM|Jian Kang - MSFT|LINK Please refer to the following link, http://blogs.msdn.com/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx Based on But now I try to implement this solution on my customers network and I cannot get it to work. Whentrying to configure Microsoft SQL Server Integration Services (SSIS) to work with ODBC.Ensure thatyou are using the 32-bit version of the ODBC driver regardless of the OS bitness. Microsoft Sql Server Error 7303 Linked Server Oracle Please click the link in the confirmation email to activate your subscription.
RegardsReply Pinal Dave January 18, 2016 10:20 amWhat is the provide you are using?Reply Dima Rabino January 10, 2016 6:15 pmThank you! :-) really helped me.Reply Pinal Dave January 18, 2016 Hope this helps!Here's my reply to a post on it (bottom of page).http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/83300532-e780-4ac6-9a64-7246e58c253a/ Attach a file File Name Submitted By Submitted On File Size dataSource.xls (restricted) Riaz Bashir 6/25/2007 - How should night time be determined and logged in a fast westbound plane? Check This Out We can grant the permissions as below:GRANT ALTER ANY LOGIN TO MachineName\ASPNET GRANT ALTER ANY LINKED SERVER TO MachineName\ASPNETOropenSQL Server Management Studio, expand Security -> Logins, right-click ASPNET and open Properties
I gave the remote server name as SQL16NODEB\SQL2014 and “Server type” as SQL Server as shown below.While saving I got error as belowTITLE: Microsoft SQL Server Management Studio-------------------- The linked server The suggestion was to enable ole automation (with surface area config or sp_configure). Type it into the address bar and press enter. 4. You cannot vote within polls.
Right click and choose properties. When using a wrong bit level of a driver (for example, 64-bit driver with 32-bit MSSQL Server),this error message is received: The test connection to the linked server failed. You cannot edit your own posts. I'm afraid this workaround is not a general solution (btw, when working, openrowset behaves fine even without ole automation enabled) Posted by RayNovak on 4/14/2008 at 4:57 AM enabling ole automation