Reply Yogesh says: November 17, 2015 at 1:07 am Was facing this issue many times without any clear idea. Is it the best way to use Import/Export wizard in SSMS?Reply Samarth November 30, 2015 10:10 amThank you and Mitch!Reply parasuraj July 13, 2016 2:24 pmOLE DB provider ‘Microsoft.Jet.OLEDB.4.0' cannot be We changed the configuration: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO Ran the stored proc again and then got this error: share|improve this answer edited Jul 28 '15 at 15:45 Code Maverick 12.5k73985 answered Mar 18 '15 at 19:48 Diego Castro 211 add a comment| up vote 1 down vote Here is

Great for personal to-do lists, project milestones, team priorities and launch plans. - Combine task lists, docs, spreadsheets, and chat in one - View and edit from mobile/offline - Cut down Option 1: Log out of the machine and log in as the account that starts the SQL Server Service (in this case Admin/Admin) then start a command prompt and type “set However, the OLEDB provider will execute under the account that called it. Privacy Policy Site Map Support Terms of Use

I tried everything, the thing that made it work was: EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 0 I don't know why the AllowInProcess turned off makes it work but that was the key Now, the simple explanation is this, when using a linked server (and the OPENROWSET is a sort of linked server) then a temporary DSN (Data Source Name) is created in the Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)". So, can I depend on OpenRowSet for importing data from a csv file, or do I need to start over?

So what is the best way to proceed for the data copying? Ecarri Aug 23 '12 at 11:51 I was accidently runnng off the wrong server, so it was 32 bit, It doesnt work on my laptop at all. The second one has both the 32bit and 64bit. Restart the services so that the new changes are applied as shown in figure below.

Now, a more verbose error would explain why the query fails, this is the case for other situations, for example: If the filename is wrong or if the file doesn’t So I thought I would share some of the things that I've come across, and hopefully tha OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". ★★★★★★★★★★★★★★★ Michael The provider did not give any information about the error. Access denied.

Select the SQL Server Services folder in the left pane. Not the answer you're looking for? It will give this error message if it can't access the file, regardless of why. It worked for me after that.

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Interruption 'enumerate' list Was Roosevelt the "biggest slave trader in recorded history"? I searched for hours looking for a resolution to this problem and your solution was the only one that made sense and worked. Applied your solution (write permission to temp directory).

From Jim's information, this needs to be around 71MB or more for the OpenRowSet and OpenDataSource to work. I would still take a methodical approach. Leave new Pawel August 8, 2013 2:54 pmHelloI'm also facing this problem. I think a service pack changed the setting.

Therefore let ASP.net handle the connection to your Access database and viola! To modify this area, edit the advanced options for the SQL Service (using SQL Configuration Manager) and put in the "-g512;" option with the other existing ones. Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". This can cause side effects if you don't have a lot of memory (like performance and other issues), so be careful.

Solution ??? Reply SnehaDeep says: April 7, 2009 at 3:53 pm hi another reason for this issue might be that if you have renamed the original database file. I do not have access to changing environment or startup parameters to SQL Server. The problem: You issue a select using the OPENROWSET and the OleDb Provider against a text file, for example: SELECT * FROM OPENROWSET(‘MICROSOFT.JET.OLEDB.4.0',‘Text;Database=C:\Temp\;',‘SELECT * FROM [Test.csv]') And sometimes you

I have seen it reported in several different forums with no real solutions found. November 3, 2010Pinal DaveSQL, SQL Server, SQL Tips and Tricks98 commentsI recently got email from blog reader with following error.MS Jet OLEDB 4.0 cannot be used for distributed queries because the more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Since making this change both Jim and I have not had further problems with this.

Join them; 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 Come on over! Access Database Engine 2007 32 bit Access Database Engine 2010 32 bit and 64 bit The lesson here is; be sure to install the version 32 bit or 64 bit that If ‘Sheet1$' is not a local object, check your network connection or contact the server administrator.".Msg 7350, Level 16, State 2, Line 3 Cannot get the column information from OLE DB

Make sure that something or someone doesn't have the file that's trying to be accessed open. I have researched answers to no end and none have worked for me. Please provide the solution for this. I can't quite get it without the formatting being objected to in some way. Reply Yves says: January 3, 2011 at 1:38 pm Hello, I have the same message. Monday, February 18, 2013 4:35 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. The p...

Spent a long time looking for a article like this and finally able to understand the workings of openrowset. I have also checked permissions of C:\Users\MSSQLSERVER\AppData\Local\Temp and C:Windows\ServiceProfiles\NetworkService\AppData\Local which have granted Full Control for the following: System, MSSQLSERVER, and Administrators, Network Service (on the latter). Who knew? Solution Column names might be wrong. If you have feedback for TechNet Subscriber Support, contact [email protected]

When running my program returns the following error message: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. It works fine if I run it from SQL Server Management Studio Express (2005). Posted by Riaz Bashir on 5/12/2008 at 3:48 AM I enabled Ole Automation Procedures and it didn't work immediately, but it didn't work after restart either. The provider did not give any information about the error.Msg 7303, Level 16, State 1, Line 10Cannot initialize the data source object of OLE DB...

Apply the new permissions. N(e(s(t))) a string Should I record a bug that I discovered and patched? Don't type them, copy/paste. Bcoz it is very big data and just to reduce my effort in ROR, I have designed so many Stored Procedure by which I extract the information from DB. By joining today you can post your own programming questions, respond to other developers? questions, and eliminate the ads that are displayed to guests. Just re-registering alone didn't solve the problem, I had to...