locked
ACE Driver 64 bit ??? please confirm RRS feed

  • Question

  • User-1112204889 posted

    i have a small app that requires the use of ACE to connect to an access database

    i'm currently running win7 x64 and have downloaded the following ACE driver, it says to use OLEDB.14, but i've read in other places that this is incorrect, it still uses OLEDB.12

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

    my logic are as follows

            Dim sectionDS As New DataSet
            Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\temp.mdb;"
            Dim connectionObject As New OleDbConnection(connectionString)
            Dim commandText As String = "get_sections"
            Dim command As New OleDbCommand(commandText, connectionObject)
            Dim adapter As New OleDbDataAdapter()
    
            command.CommandType = CommandType.StoredProcedure
            If connectionObject.State = ConnectionState.Closed Then connectionObject.Open()
    
            adapter.SelectCommand = command
            adapter.Fill(sectionDS, "sectionDS")
            adapter.SelectCommand.Connection.Close()
            adapter.SelectCommand.Connection.Dispose()
            connectionObject.Close()
            connectionObject.Dispose()
    
            GridView1.DataSource = sectionDS
            GridView1.DataBind()


    on IIS7 in the application pool v4.0 i set 'enable 32-bit applications = false' i get error

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    but if i set it to true, it works... i also noticed when installing the AccessDatabaseEngine.exe it defaults to C:\Program Files(x86)\...

    i thought the driver that MS released was a x64 bit driver, please confirm if i'm doing something wrong, or if the x64 bit driver has not been released yet

    Saturday, May 8, 2010 5:17 AM

Answers

All replies

  • User-821857111 posted

    There's a 64 bit driver in the download package, but the version (12 or 14) is important. 12.0 relates to Office 2007. Office 2010 is version 14, so you do need to change the value in your connection string to 14 to use the new provider - especially if you do not have the previous version of ACE installed.


    Saturday, May 8, 2010 5:23 AM
  • User-1112204889 posted

    There's a 64 bit driver in the download package, but the version (12 or 14) is important. 12.0 relates to Office 2007. Office 2010 is version 14, so you do need to change the value in your connection string to 14 to use the new provider - especially if you do not have the previous version of ACE installed.

    i have tried 14.0 also... error 'The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.'

    it may be related to a reported problem which MS hasn't fixed before releasing the package

    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/ea313c55-b5e8-4272-9035-d5ec414bfa08

    i have not got any ACE installed other than the one i stated above (i don't even have office 2007 or 2010 installed either)

    can someone please confirm that this is actually a 64 bit ACE driver and not a 32 bit driver allowed to be installed onto a x64 bit system

    Saturday, May 8, 2010 5:38 AM
  • User-821857111 posted

    I just installed it, and got exactly the same issue as reported in the other thread you referenced. It's not clear from the download page whether there is a 64 bit version or it's just supported on 64 bit platforms. I know that the plans were to release a 64 bit version with Office 2010, so my assumption is that it is sitting in there, especially as the download page has this under "Supported Operating Systems":

    - Access Database Engine 2010 (64-bit): Windows 7, Windows Server 2008 R2, Windows Server 2008, Windows Vista, Windows Server 2003 R2, Windows Server 2003

    I didn't get an option to install anywhere except Programs(x86), although I am using Win 7 x64.

    However, I found this: http://connect.microsoft.com/data/feedback/details/541090/access-database-engine-2010-installation-issue-to-use-with-ado-access-technology-to-access-data-from-jet-database-mdb-files which is counter-intuitive and silly.


    Saturday, May 8, 2010 6:07 AM
  • Saturday, May 8, 2010 6:13 AM
  • User-821857111 posted

    I eventually got the thing running, but I had to enable 32 bit applications for the AppPool and use 12 in the connection string. That suggests to me that this installation did not include a 64-bit provider. Or that the installation programme is not very clever.


    Saturday, May 8, 2010 10:22 AM
  • User-821857111 posted

    Or that the installation programme is not very clever.

    An update on this: I could not get any of my Office 2010 32 bit beta apps to open this morning. I uninstalled the provider, but that made no difference. I eventually had to resort to a system restore to the point just before I installed the driver. That worked. They couldn't have got this provider and its install package more wrong, really.


    Monday, May 10, 2010 12:18 PM
  • User-1112204889 posted

    Or that the installation programme is not very clever.

    An update on this: I could not get any of my Office 2010 32 bit beta apps to open this morning. I uninstalled the provider, but that made no difference. I eventually had to resort to a system restore to the point just before I installed the driver. That worked. They couldn't have got this provider and its install package more wrong, really.


    well said... anyone know if the 64bit office 2010 beta is out? might be a good idea to look into the iso and check if there are the driver package in that

    Monday, May 10, 2010 5:44 PM
  • User-821857111 posted

    64bit office 2010 beta is out? might be a good idea to look into the iso

    It's not an iso. It's an exe. And I have it. I can't use it at the moment because of issues with MAPI and 64 bit, which is why I'm using the 32 bit version.

    If I were you, I'd take this up on an Office forum or newsgroup.


    Monday, May 10, 2010 5:49 PM
  • User-1112204889 posted

    you have the link?

    have you taken your MAPI problem up wtih them?

    Monday, May 10, 2010 5:53 PM
  • User-1112204889 posted

    finally 64 bit is now out!!

    the file is AccessDatabaseEngine_X64.exe

    but still needs to be referenced as Microsoft.ACE.OLEDB.12.0

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 12, 2010 11:03 PM