SQL Server 2012 x64 with Access-DB as linked server

Question

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.
Installing 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!

Answer 1

This one may sort it.

http://www.gregorystrike.com/2010/11/15/access-2007-database-as-linked-server-in-sql-2008-r2/ 

 

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

Answer 2

It seems the office 2010 provider just does not work with SQL Server 2012 :(