I've searched a lot, but I still didn't find out a solution. I have to create a linked server to get the data from a mdb file (MS Access). I use the SQL Server 2012 Express x64 on the Windows 8.1 x64. I ran the odbcad x32 (the one that's inside the syswow64 folder), so I created the data source for this file:

enter image description here

But when I try to create the linked server I got the error:

enter image description here

Searching, I found out that the x64 SQL Server server can use any x32 driver. I can't see what I'm doing wrong.

migrated from stackoverflow.com Aug 15 '15 at 8:04

This question came from our site for professional and enthusiast programmers.

  • 1
    My experience has been that an x64 version of SQL Server is not able to use a 32-bit driver. I would try downloading and installing the 64-bit version of the Access driver (on the SQL host, of course). – Dave Mason Aug 14 '15 at 19:48
  • I see. I installed a new instance of the SQL Server 2012 Express x32 and now I can use the drivers. Thank you so much. – Keoma Borges Aug 17 '15 at 20:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.