SQL Server 2012 x64 with Access-DB as linked server


  • Hello!

    I'm trying to add an access database as linked server to my SQL Server 2012 x64, but i'm missing the necessary OLEDB-Provider..

    My developing enviroment:

    Access 2010 x86
    SQL Server 2012 x64

    Executing "EXEC xp_enum_oledb_providers" gives following:

    • Microsoft OLE DB Provider for SQL Server
      Microsoft OLE DB Provider for Analysis Services 11.0
      SQL Server Native Client 11.0
      OLE DB Provider for Microsoft Directory Services
      Microsoft OLE DB Provider for Search
      Microsoft OLE DB Provider for ODBC Drivers
      Microsoft OLE DB Simple Provider
      Microsoft OLE DB Provider for Indexing Service

    I've tried to install AccessDatabaseEngine.exe (Microsoft Access Database Engine 2010 Redistributable), but it has not changed anything.
    AccessDatabaseEngine_x64.exe fails because of x86-Version of Access.

    Question: is it possible to add x86-Access as linked server to SQL Server 2012 x64?? Or is it necessary to install either the x64-Version of Access or x86-Version of SQL Server?

    Thanks for the answer!

    Friday, May 4, 2012 8:26 PM


All replies