locked
Microsoft.Jet.OLEDB.4.0 - 32bit and 64bit RRS feed

  • Question

  • We are having a 64Bit compatibility problem.  Something that was working in 32 bit is no longer working in 64 bit.  We need a short / Quick solution for the following:

    The issue we are having is with the
    Microsoft.Jet.OLEDB.4.0 driver. We are using this driver to read and write data to the Excel File (Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=YES;").

     

    But currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS. The topic titled Deprecated MDAC/WDAC Components in the below given link describes about this issue. It also suggests using a new driver (2007 Office System Driver) as a replacement to the current JET driver. But when I did a quick search about this new driver, it says the 2007 Office System Driver is also currently supported in 32 bit OS versions (need to confirm on this)

    Saturday, January 2, 2010 5:00 PM

Answers

All replies

  • Do you test ODBC drivers?
    With best regards, Yasser Zamani
    Saturday, January 2, 2010 6:07 PM
  • Hello,

     

    Welcome to ADO.NET Data Providers forum!

     

    As you said, Microsoft.Jet.OLEDB.4.0 is not supported for 64-bit OS.  Also, currently Office 2007 System Driver is not support 64-bit OS either. 

     

    However, I think the 64-bit OLEDB Provider for ODBC might be helpful to you:

    http://blogs.msdn.com/data/archive/2008/04/07/64-bit-oledb-provider-for-odbc-msdasql-is-now-available-for-windows-server-2003.aspx

    http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en


    If you wanto to use the original provider, we need to build the project as x86 instead of x64 or Any CPU in 64bit OS. 


    Happy New Year!

     

    Best Regards,
    Lingzhi Sun

    MSDN Subscriber Support in Forum

    If you have any feedback on our support, please contact msdnmg@microsoft.com


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Monday, January 4, 2010 6:24 AM
  • On more addition tp Lingzhi's post. I am not sure what exactly you need in terms of functionality, but you could try components for Excel from my web site that are developed in .NET and support both 32- and 64-bit modes.
    Val Mazur (MVP) http://www.xporttools.net
    Monday, January 4, 2010 10:57 AM
  • The 64-bit Microsoft Access Database Engine (Office 2010) is currently in Beta. There is a download available:

    http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

    The other alternative is to compile your app with the x86 option so that it runs in WoW64 (32-bit Windows subsystem).
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Monday, January 4, 2010 12:11 PM
  • Hello,

     

    I am writing to check the status of the issue on your side.  Would you mind letting us know the result of the suggestions? 

     

    If you need further assistance, please feel free to let me know.   I will be more than happy to be of assistance.

     

    Have a nice day!

     

     

    Best Regards,
    Lingzhi Sun

    MSDN Subscriber Support in Forum

    If you have any feedback on our support, please contact msdnmg@microsoft.com


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, January 7, 2010 1:00 AM
  • The 64-bit Microsoft Access Database Engine (Office 2010) is currently in Beta. There is a download available:

    http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

    The other alternative is to compile your app with the x86 option so that it runs in WoW64 (32-bit Windows subsystem).
    Paul ~~~~ Microsoft MVP (Visual Basic)

    Anyone have got the solution? It is not helpful to my issue, Thanks very much!
    Sunday, October 10, 2010 2:52 AM
  • There is Microsoft Access Database Engine 2010 http://www.microsoft.com/download/en/details.aspx?id=13255 but my problem is a bit opposite. I have Office 2010 and I believe I do have 64 bit version of the OleDB, but I could not find this C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL so I'm missing 32 bit version of OleDB 12 provider. Do you know where can I get 32 bit version to install on my Windows 7 64 and Office 2010 64 bit? I need 32 bit provider as I'm trying to download Excel files into VFP which is 32 bit application.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    • Edited by Naomi N Wednesday, March 14, 2012 9:01 PM
    Wednesday, March 14, 2012 9:01 PM
  • You can install either the 2007 or 2010 version. I believe the 2010 version will require the /passive command line argument if the 64-bit version is already installed

    http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e&displaylang=en

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


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, March 15, 2012 11:54 AM
  • I was able to install AccessDatabaseEngine /passive and it now works great from VFP application. Thanks a lot.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    • Edited by Naomi N Thursday, March 15, 2012 12:40 PM
    Thursday, March 15, 2012 12:33 PM
  • We are having a 64Bit compatibility problem.  Something that was working in 32 bit is no longer working in 64 bit.  We need a short / Quick solution for the following:

    The issue we are having is with the
    Microsoft.Jet.OLEDB.4.0 driver. We are using this driver to read and write data to the Excel File (Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=YES;").

    But currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS. The topic titled Deprecated MDAC/WDAC Components in the below given link describes about this issue. It also suggests using a new driver (2007 Office System Driver) as a replacement to the current JET driver. But when I did a quick search about this new driver, it says the 2007 Office System Driver is also currently supported in 32 bit OS versions (need to confirm on this)


    Wednesday, July 17, 2013 8:17 PM
  • Dear Author,

    Thank you very much for providing these tips.They were really helpful.I spent lot of time on finding a solution for my problem. 

    "I couldnt update the Access database (2007) from Visual Studio(2012),Nothing was written to the database."

    My OS is 64 bit.And later I did changed the building configuration as you have said.It worked really well.

    Thank you very much for your great job...

    Wednesday, November 20, 2013 1:15 PM
  • It works, but there is a side effect. After install x64 driver as passive, Excel began to show a install wizard every opening.
    Wednesday, November 4, 2015 1:55 PM
  • Do you know what should I do to be able to load Excel xlsx files from VFP application (VFP is 32 bit application).

    I have Windows 10 and Office 2016 64 bit installed.


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles

    Wednesday, August 24, 2016 11:33 AM