Database Error On Idbinitialize
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums New to SQL Server Programming IDBInitialize::Initialize returned 0x80004005 Reply to Topic Printer Friendly Author Topic ATHAR Starting Member 2 Posts Posted-06/05/2008: 06:22:57 When executing the following SQL statement we get the error as message below:INSERT INTO [dbo].[ProductImport] ([CustomerName], [AccountCode], [ProductCode], [Description1], [Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns], [PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL]) SELECT [CustomerName], [AccountCode], [ProductCode], [Description1], [Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns], [PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL] FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\Applications\xxxxxxxxx\AppRoot\xxxxxxxxxSQL\Catalogues;HDR=YES', 'SELECT * FROM [product_test.csv]')AS ImportFile WHERE [ImportFile].[MaterialType] IN (1, 2, 3, 4)Error messageServer: Msg 7399, Level 16, State 1, Line 5OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Unspecified error]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].This is being run onMicrosoft SQL Server 2000 - 8.00.2039 (
SERVER - Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 March 16, 2007Pinal DaveSQL, SQL Server, SQL Tips and Tricks11 commentsError received:Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16 Source: Microsoft OLE DB Provider for SQL Server Error message: [DBNETLIB]SQL Server does not exist or access deniedThe simple fix: Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104233 Configuration Manager >> SQL Server 2005 Network Configuration >> Enable TCP-IP.Reference : Pinal Dave (http://blog.SQLAuthority.com) Tags: SQL Error Messages, SQL Server Security, SQL Utility1Related Articles SQL SERVER - Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa', because it does not exist or you http://blog.sqlauthority.com/2007/03/16/sql-server-fix-sqllib-error-oledb-error-encountered-calling-idbinitializeinitialize-hr-0x80004005-sqlstate-08001-native-error-17/ do not have permission December 26, 2008Pinal Dave SQL SERVER - How to fix the SQL Server Error 8657 or 8658? February 4, 2015Pinal Dave SQL SERVER - Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing April 19, 2009Pinal Dave 11 comments. Leave new chuck August 1, 2007 1:47 pmI have (Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server 2005 Network Configuration >> Enable TCP-IP) already enabled and I'm getting this error:Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16 Source: Microsoft OLE DB Provider for SQL Server Error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Then this error:An error occurred while attempting to log in to the following server: "HFPDEXCH". SQL error number: "0011". SQL error message: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access de
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://stackoverflow.com/questions/3919167/sql-server-2000-openrowset-issue Discuss the workings and policies of this site About Us Learn more http://www.sqlservercentral.com/Forums/Topic223480-92-1.aspx about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, database error helping each other. Join them; it only takes a minute: Sign up Sql Server 2000 openrowset issue up vote 1 down vote favorite 1 I’m attempting to query and Excel spread sheet on a network share, using the openrowset function with no success. I get the following error: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=\\server\Xdrive:\Spreadsheet.xls', 'Select * from [Sheet1$]') database error on Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. I have searched the site and have tried different syntax with no success. I have read that the account may not have access to the network share. What account does this process run under? sql sql-server tsql sql-server-2000 share|improve this question edited Oct 12 '10 at 21:30 OMG Ponies 198k36356415 asked Oct 12 '10 at 21:27 Oscar 112 Is this something voor ServerFault? –littlegreen Oct 13 '10 at 8:31 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote 0x80004005 very much looks like Access Denied. You can look in the services.msc what account the SQL Server runs under. A local account will not work outside of the local machine, a Domain account is the better choice
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Notification Services » Administration » Linked Server problem ! Linked Server problem ! Rate Topic Display Mode Topic Options Author Message Olivier TACKELSOlivier TACKELS Posted Monday, September 26, 2005 4:06 AM Forum Newbie Group: General Forum Members Last Login: Thursday, June 15, 2006 3:18 AM Points: 1, Visits: 1 I try to link a Oracle Server with a SQL Server but this message always appears : "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."So, I installed Oracle client 7.3.3.5.0 on my SQL Server. This server is a Windows 2000 Server SP4. When I use a "SQL Plus 3.3", little Oracle tool to query building I can connect my Oracle Server.But, when I want to create a "Linked Server", after that I clicked on "Tables" I receive message that you had read more high.I inputed this paramaters :"Product name : Oracle7""Data Source : MyDBOracle" (Oracle DB Name)"Provider String : MSDAORA"Can you help me ?Olivier Post #223480 dbuchandbuchan Posted Tuesday, September 27, 2005 12:19 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, September 28, 2009 5:41 PM Points: 182, Visits: 61 What version is the Oracle database ? Can you make an ODBC connection on the SQL server ? (To the Oracle Database)You have also set the login/password in the Linked server for the Oracle connection ?I'd still be going for a later client....DB The systems fine with no users loggged in. Can we keep it that way ?br> Post #223790 Steve MedvidSteve Medvid Posted Tuesday, September 27, 2005 6:41 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, February 19, 2014 1:27 PM Points: 3, Visits: 82 Also check your MDAC Version on the SQL Server machine. We had out brilliant IT Team push out new security patches that include MDAC Changes. Well - All linked servers went down - for Oracle. I don't know the exact changes they made to fix the issue, but