Wednesday, March 7, 2012

Microsoft.Jet.OLEDB.4.0 has not been registered. ?

Hi folks,
We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg,

: Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed. I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box. I am stucked. Any advice would be appreciated.

Sunny

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft|||

Does MS have some kind of plans for x64 based 64-bit .net apps to connect to Access 2007 or this a permanent solution?

|||

David Sceppa - Microsoft wrote:

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft

Would this also be revelant for OPENROWSET queries that use the driver? For example, the following select runs fine on my dev box (32bit SQL 2005), yet fails on our live box ((SQL 2005 64 bit)) .(it is part of a greater process that *should* bein in SSIS, but is being pushed in as a 'quick fix')

select [User Name],[Password], [Store Number] ,getdate(),''2008-12-31 00:00:00.000'',''1980-01-01 00:00:00.000''

from OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=c:\Username and passwords v1.1.xls'',''SELECT * FROM [staff login details$]'')

version info from live:

7 FileDescription SQL Server Windows NT - 64 Bit
8 FileVersion 2005.090.2153.00

No comments:

Post a Comment

Post a Comment