none
IIS 8 and JET OLEDB

    Question

  • I was wondering if anyone can answer if there is a way to utilize Jet OLEDB connections in IIS 8 on Windows Server 2012?

    Currently, even with the application pool having 32bit mode enabled we receive the error:

    [HttpException (0x80004005): The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.]

    Thursday, September 20, 2012 11:47 AM

Answers

  • I did a little research but I can't confirm whether the Jet Database Engine is supported/installed under Windows 2012 Server. The Jet technology is considered deprecated by Microsoft. The provider library is msjetoledb40.dll and would be found under the Windows\SysWOW64 folder. If the file is on the system and properly registered then I would suspect a permissions problem. The Process Monitor utility is a good tool for troubleshooting.

    The replacement for Jet is the ACE OLEDB Provider, which supports both 32 and 64-bit environments:

    http://www.microsoft.com/en-us/download/details.aspx?id=13255




    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, September 20, 2012 1:36 PM