none
connecting to ms access databse 2010 for 64 bit RRS feed

  • Question

  • I am using 32 bit COM server. From which i am trying to connect to *.mdb database using "Provider=Microsoft.ACE.OLEDB.12.0" connection string. It is giving error "Unknown error 0x800A0E7A". If i build my server exe to 64 bit, everything working fine. I am using windows 7 64 bit and installed "Microsoft Access Database Engine 2010 Redistributable 64 bit". 

    Is there any way to use 64bit driver from 32 bit application?

     


    Thursday, September 2, 2010 12:19 PM

Answers

  • You cannot load a 64-bit component into a 32-bit process space, so the answer is no. If you need to use the 64-bit Access database engine then you will need a 64-bit app or component.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Thursday, September 9, 2010 3:51 AM
    Thursday, September 2, 2010 1:46 PM
  • If I remember correctly, starting with Windows XP SP2 the Jet OLEDB Provider comes installed. I would expect most XP systems would have, at a minimum, SP2. It comes installed on both Vista and Windows 7.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by Ashu23 Thursday, September 9, 2010 5:17 AM
    Tuesday, September 7, 2010 1:54 PM

All replies

  • You cannot load a 64-bit component into a 32-bit process space, so the answer is no. If you need to use the 64-bit Access database engine then you will need a 64-bit app or component.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by liurong luo Thursday, September 9, 2010 3:51 AM
    Thursday, September 2, 2010 1:46 PM
  • Hi,

     

    Thanks for reply. After some try i found that i can use "Provider=Microsoft.Jet.OLEDB.4.0" to use sam *.mdb database from 32 bit application. Is Microsoft ship old jet engine with windows 7 64 bit version or we have to provide this by installer?

    • Marked as answer by Ashu23 Monday, September 6, 2010 10:10 AM
    • Unmarked as answer by Ashu23 Monday, September 6, 2010 10:47 AM
    Monday, September 6, 2010 9:39 AM
  • The Jet OLEDB Provider comes pre-installed in Windows 7 64-bit but only for WoW64 (32-bit Windows subsystem). There is no 64-bit version so you will need to compile your app with the x86 Platform option.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by Ashu23 Tuesday, September 7, 2010 1:21 PM
    • Unmarked as answer by Ashu23 Tuesday, September 7, 2010 1:24 PM
    Monday, September 6, 2010 3:39 PM
  • Thanks again Paul. Just one query, we have to support windows XP/Vista/7 64 bit. Is The Jet OLEDB Provider comes pre-installed in all of these flavors of 64 bit windows?
    Tuesday, September 7, 2010 1:24 PM
  • If I remember correctly, starting with Windows XP SP2 the Jet OLEDB Provider comes installed. I would expect most XP systems would have, at a minimum, SP2. It comes installed on both Vista and Windows 7.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by Ashu23 Thursday, September 9, 2010 5:17 AM
    Tuesday, September 7, 2010 1:54 PM