OBDC -> Architecture mismatch between the Driver and the Application(#0)
I tried to setup an OBDC connection with FileMaker Pro 11 Advanced and connect via Access but I am receiving this error:
[Microsoft][OBDV Driver Manager] The specified DSN contains an architecture mismatch between the Driver and the Application(#0)
These are the steps I took before adding it in Access. Does anyone have any ideas why this might not be working?
0) Turned on ODBC/JDBC sharing in File -> Sharing on FileMaker Pro 11 Advanced for "All Users"
1) installed the FileMaker OBDC driver included on the filemaker disc
2) odbcad32.exe in C:\Windows\SysWOW64 and added a new filemaker System DSN and directed it to the filemaker database.
This problem is solved but I have a new one. I will make a new solution.
For people of the future, this was my problem.
The driver I installed was 32bit driver, for thr 32bit manager of windows. I was trying to connect with 64bit SQL and 2013 access.