Home > Ole Db > Cannot Initialize The Datasource Object Of Ole Db Provider Microsoft Ace

Cannot Initialize The Datasource Object Of Ole Db Provider Microsoft Ace

Contents

You should find it at HKEY_CLASSES_ROOT\AppID\{2206CDB0-19C1-11D1-89E0-00C04FD7A829}

Next, follow these instructions to change permissions.

1. Right-click on it and click Permissions . 4. If it is something else (this is configurable, by the way), use that user name in the following steps. 3. By default, at least on the two machines I checked, this is the "Network Service" user. weblink

It is also a SQL 2008 R2 x64 Db-server, Microsoft.ACE.OLEDB.12.0 provider is installed, but it still throwing the mentioned error. You can also get it working without needing AllowInProcess if you follow the instructions in this MSDN article. I also tried setting the role for ASPNET to "public" and "sysadmin". I had exactly the same trouble, but with Windows Server 2008 x64. http://dba.stackexchange.com/questions/36687/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoft-ace-oledb

Cannot Initialize The Datasource Object Of Ole Db Provider Microsoft Ace

Is there a non-medical name for the curve where index finger and thumb meet? Can you help me please? 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 Sever-sort an array How do I answer a question on graduate school applications on textbooks used in my classes, when my class didn't use a textbook?

McClane is a NYPD cop. Use Process Monitor to work out where the temp directory is for NetworkService on Windows Server 2008. The steps provide links to articles that help eliminate possible causes and take corrective action as necessary. Ole Db Provider "msdasql" For Linked Server "(null)" Returned Message When trying to query the linked server, this error message is received:OLE DB provider "MSDASQL" for linked server " SERVICENOW" returned message "[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK Client]Cannot open the configuration

In fact, I don't even need the EXECUTE sp_addlinkedsrvlogin command. (Note: Versions are Windows XP SP3, IIS v5.1, Visual Studio 2005, SQL Server Express 2005, .NET Framework 3.0.) Does anyone know Ole Db Provider "microsoft.ace.oledb.12.0" For Linked Server Returned Message "unspecified Error" Grab the APP ID from the General tab of MSDAINITIALIZE Properties. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. click here now It would seem even though I started the job, the COM component is being initialized using the SQL Agent account?

I would suggest you put all the statements in a stored procedure, and call it from code-behind. Microsoft Sql Server Error 7303 Linked Server Oracle asked 7 years ago viewed 53038 times active 4 months ago Linked 15 Find temp folder for user Network Service? 2 SQL Server 2008 linked server connection string setup 1 Cannot Join them; it only takes a minute: Sign up Cannot initialize the data source object of OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)” up vote 2 down vote favorite I How much effort (and why) should consumers put into protecting their credit card numbers?

Ole Db Provider "microsoft.ace.oledb.12.0" For Linked Server Returned Message "unspecified Error"

Could large but sparsely populated country control its borders? http://www.codeproject.com/Questions/797004/Solving-Cannot-initialize-the-data-source-object-o OLE DB provider "MSDASQL" for linked server "SERVICENOW" returned message "Specified driver could not be loaded due to system error 126:The specified module could not be found, (ServiceNow ODBC Driver 32-bit Cannot Initialize The Datasource Object Of Ole Db Provider Microsoft Ace Get out of the transit airport at Schengen area and the counting of Schengen period Why jitter continuous value in a scatterplot? Microsoft Sql Server Error 7303 Linked Server The provider for the linked server was set to use Microsoft.ACE.OLEDB.12.0, the datasource pointed to the correct folder and the providerstring was set to "TEXT", but I could not test the

This TechNet article is long-winded, but contains a lot of config steps and suggestions: http://support.microsoft.com/kb/319723. have a peek at these guys asked 1 year ago viewed 322 times active 1 year ago Linked 0 I got error like this IErrorInfo.GetDescription failed with E_FAIL(0x80004005) Related 0The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the Can you connect to it from other machines using for example Microsoft SQL Server Management Studio? –Maurits van Beusekom Aug 11 '15 at 12:14 | show 4 more comments Your Answer Article InformationLast Updated:2016-09-13 16:10:01Published:2014-06-20Copy Permalink Blog Sign in Join ASP.NET Home Get Started Learn Hosting Downloads Community Overview Community Spotlight Articles of the Day What's new Community Blogs ASP.NET Team Events Cannot Initialize The Data Source Object

And that is not user-rights related, as usually suggested. asked 3 years ago viewed 40287 times active 1 year ago Related 1Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server0Cannot create an instance of OLE So when the mail landed – well I was not surprised that there was a problem. check over here After making the necessary changes as mentioned above, reset the permissions for the above registry key in the registry settings back to its defaults:

- First make the account

I'll definitely post an update here if I ever figure out what the problem is. -Dan Reply jnhill None 0 Points 1 Post Re: Linked Server: Cannot initialize the data source Msg 7303, Level 16, State 1, Line 1 In Server Roles tab, checkthe checkboxsysadmin, press OK to save. Crazy 8s Code Golf Why do Latin nouns (like cena, -ae) include two forms?

Could you expand a little why you are not satified with the resolution?

If it matters, all users have access to the Temp folder in the Users folder. (These are all suggestions I found in similar answers to this question) Edit: Using SQL Server Allow ad hoc queries in SQL Server using sp_configure. Any help please! Microsoft Sql Server, Error: 7399 Jian Kang Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation greetings, Marcin Reply danthman None 0 Points 16 Posts Re: Linked Server: Cannot initialize the data source object Mar 26, 2009 12:54 PM|danthman|LINK Hi Marcin, No, I haven't found a solution share|improve this answer answered Jun 4 '15 at 8:55 Chagbert 1534 add a comment| up vote -4 down vote Run Management Studio as Administrator. this content Reply [email protected] says: October 9, 2013 at 10:56 pm Thanks, It works.