1
I’ve done a lot of research, but I haven’t found a solution for my case yet. I need to create a Linked server for an Access database (mdb file). Use SQL Server 2012 Express x64 in Windows 8.1 x64. I ran odbcad x32 (which is inside the syswow64 folder) and created the data source pointing to my file:
However, when I create Linked server, error appears:
The solutions I found mentioned that I was supposed to do this, because the x64 server is capable of recognizing x32 drivers. What is my mistake?