IDBInitialize::Initialize returned 0x80004005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

IDBInitialize::Initialize returned 0x80004005

Author

Topic

ATHAR
Starting Member

2 Posts

Posted - 2008-06-05 : 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 message
Server: Msg 7399, Level 16, State 1, Line 5
OLE 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 on
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Windows 2003, build 3790.srv03_gdr.070301-2306

Have checked a number of knowledge base articles
C:\Windows\system32\msjet40.dll version 4.0.8618.0

REGEDT32: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC, Administrator/everyone full access

D:\Applications\xxxxxxxxx\AppRoot\xxxxxxxxxSQL\Catalogues has full permissions for Administrator/everyone groups

Can anyone suggest the next step to identifying a possible cause to this issue.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-05 : 06:26:54

http://support.microsoft.com/kb/814398

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-05 : 06:28:45

Can your SQL Server reach the D: path? All paths are relative to your server´, not your workstation.
Do the SQL Server has security access to the path mentioned?

Temporarily switch to another provider for possible more error information as seen here
http://weblogs.sqlteam.com/peterl/archive/2007/10/24/Getting-errors-when-working-with-Excel-and-SQL-Server.aspx

E 12°55'05.25"
N 56°04'39.16"

ATHAR
Starting Member

2 Posts

Posted - 2008-06-05 : 07:22:48

visakh16
Went throguh the steps included in the article, http://support.microsoft.com/kb/814398
Identified that the user account a different user, setup the temporary folder with full permissions to user and configures TMP/TEMP variables, following restart, this has now been resolved, thanks

Peso
Our paper product import routine runs locally on the server.

Thanks again for your input into helping to sort this issue
I may well have plodded on for many days reading this/that
Who knows when I would have found the article above

Now then

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources