Error Cannot Initialize Read Db
Contents |
log in tour help Tour Start 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 this site About Us Learn cannot initialize the datasource object of ole db provider for linked server more about Stack Overflow the company Business Learn more about hiring developers or posting
Cannot Initialize The Datasource Object Of Ole Db Provider Microsoft Ace
ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question
Microsoft Sql Server Error 7303 Linked Server
and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can
Ole Db Provider "microsoft.ace.oledb.12.0" For Linked Server Returned Message "unspecified Error".
ask a question Anybody can answer The best answers are voted up and rise to the top Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server up vote 4 down vote favorite This is going to be a long story I'm afraid ;-( I have to read some text-files into a SQL database. This database is on a SQL 2008 R2 x64 database server. microsoft sql server error 7303 oracle I want to use a linked server so after some research I found that I had to install the Microsoft.ACE.OLEDB.12.0 x64 provider. I did this on my local machine and after I created my linked server I had some trouble reading text files. 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 connection. It was throwing this error: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XXXXXXXXX". OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XXXXXXX" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303) After some research, I found that the SQL Service was running under the NETWORKING SERVICE-account. When I changed this to Local Account, everything was working fine. Note: I also had to change some settings for the provider, "Allow inprocess" is checked, otherwise it was not possible to browse the files in the configure datasource folder. But now I try to implement this solution on my customers network and I cannot get it to work. It is also a SQL 2008 R2 x64 Db-server, Microsoft.ACE.OLEDB.12.0 provider is installed, but it still throwing the
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 this site About Us Learn microsoft sql server error 7303 linked server oracle more about Stack Overflow the company Business Learn more about hiring developers or posting sql server error 7399 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack microsoft sql server error 7303 mysql Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cannot initialize the data source object of OLE DB provider “MSDASQL” http://dba.stackexchange.com/questions/36687/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoft-ace-oledb for linked server “(null)” up vote 10 down vote favorite 6 Having an interesting issue. I'm reading from an excel file on a server via an OpenRowset in Sql2005. I've run the query a number of times without any problems. 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 http://stackoverflow.com/questions/1362108/cannot-initialize-the-data-source-object-of-ole-db-provider-msdasql-for-linked "(null)"" I've made sure the files are not in use on the server and even deleted them and recopied them over onto the server and still I'm getting the same error. UPDATE: This only seems to happen if I join two selects from different openrowsets. If I run the queries individually they still work fine. I have done the join before without any issues. Ideas? sql-server-2005 openrowset msdasql share|improve this question edited Sep 1 '09 at 12:07 asked Sep 1 '09 at 12:01 StevenMcD 8,754103250 add a comment| 5 Answers 5 active oldest votes up vote 12 down vote accepted The problem comes because the Temp folder of the User under which the SQL server service is running isn't accessible under the credentials which the query is running. Try to to set the security of this temp folder with minimal restrictions. The dsn that gets created every time you run an openrowset query then can be recreated without any credentials conflict. This worked for me without any restart requirements. share|improve this answer edited Sep 9 '11 at 10:39 Tim Cooper 86.6k21162181 answered Jul 16 '10 at 5:48 Rajesh 13612 1 Where would I find this Temp folder? –Slider345 Jan 7 '13 at 1
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Cannot initialize the data source object of OLE DB https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d92a73c0-9c87-4adf-a6a3-061a48b8dac5/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoftjetoledb40-for-linked?forum=sqldatabaseengine provider "Microsoft.Jet.OLEDB.4.0" for linked server SQL Server > SQL Server Database Engine http://community.thomsonreuters.com/t5/EndNote-General/EndNote-X4-quot-Could-not-initialise-database-error-in-Windows-7/td-p/17753 Question 0 Sign in to vote Okay, this is what's happening. My drive: H Webserver: W Access Database: G Created a linked server on W, which points to the Access DB on G. Can run queries from W to see the data, no problem. Trying to run sql server a simple select statement from an asp page, the error: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "blah". What is that all about? I see this error everywhere on the 'net, but there doesn't seem to be a solution that works! Now get this - if I move the DB to W, create sql server error another Linked Server pointing to it (the same box as SQLExpress), it displays the data, no problem. What is that? Thanks to whomever can help! Wednesday, October 18, 2006 9:37 PM Reply | Quote All replies 0 Sign in to vote I'm going to move this to the Engine forum, I think they'll have more info on Linked Servers. Mike Thursday, October 19, 2006 2:05 AM Reply | Quote Moderator 0 Sign in to vote Here is the solution, after HOURS on the phone and more on the 'net: To create a Linked Server:sp_addLinkedServer 'DatabaseName', 'Access', 'Microsoft.Jet.OLEDB.4.0', '\\PathToDB\vol2\Directory\someDB.mdb' *** The directory in which the .mdb resides MUST HAVE Everyone with FullControl at the share level. Right-click the linked Server, Properties. In Security, click 'Be made using this security Context', and type in 'Admin' for the remote login, with no password. (This is a default to access the DB). In MS SQL Server Management Studio, Right-click the webserver where the server is, Properties. Click 'Security'. It should be the SQL Server and Windows Authentication Mode. Under 'Security', 'Login', m
på svenska ResearcherID ResearcherID General ResearcherID How To ResearcherID Suggestions ResearcherID Web Services InCites InCites Customer Forum Reference Manager General How To Styles, Filters, and Connections Product Suggestions Using Citations Citation Impact Center CommunityCategoryBoardUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Do you mean Register · Sign In · Help Community : EndNote : General : EndNote X4 "Could not initialise database error in... Reply Topic Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » bmak Visitor Posts: 2 Registered: 03-07-2011 0 EndNote X4 "Could not initialise database error in Windows 7 with Office 2007 Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 03-07-2011 06:50 PM Hi Guys,We are currently attempting to get EndNote X4 to function correctly in a education environment where we have many computer labs. We are currently experiencing the initalising database error when trying to create or open a existing library with any users who are logging in after the first user. We have already turned off UAC in our image but this does not seem to be working. We've tried giving full rights to the everyone group at the EndNoteX4 folder in C:\Program Files folder.We've also tried running the application in Compatibility mode as well as running the application as an administrator.Any ideas would be helpful at this point in time. As we're quite heavily invested into EndNote here at our University. I'd like to rectify this issue as soon as possible.Thanks for vewing guysBerry Report Inappropriate Content Message 1 of 7 (11,662 Views) Reply Leanne Mentor Posts: 6,435 Registered: 04-10-2008 0 Re: EndNote X4 "Could not initialise database error in Windows 7 with Office 2007 Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content