3 of 3 people found this helpful
FMS11 I believe was not 64bit, FMS15 I believe is only 64bit.
This means you need to use the 64bit ODBC manager to make a DSN, whereas you are probably using the 32 bit manager for 11.
I believe you need to look for:
or something similar to that. the 32bit one is in:
It's confusing since the .exe file is named the same thing in the same folder.
Mike, thanks very much. I will check this.
This is inverted. system32 has 64bit programs, syswow64 has 32bit. wow64 means windows(32 running) on window64
Right, so to clarify for my simple mind…
On a computer running a 64 bit version of Windows e.g. Windows 7 or Windows Server 2008, choose which version of the ODBC Administrator as follows:
1. If running FileMaker 11 (a 32 bit application), look in in the folder SysWOW64 for the application odbcad32.exe (c:\Windows\SysWOW64\odbcad32.exe)
2. If running FileMaker 15 (a 64 bit application), look in in the folder System32 for the application odbcad32.exe (c:\Windows\ System32\odbcad32.exe)
The slightly confusing thing is that the application itself is always called odbcad32.exe. How come it’s always called odbcad32.exe?
This is all assuming you have installed the right ODBC driver for FileMaker in the first place. In terms of the driver to use, the FIleMaker website recommends MySQL ODBC 5.2 Unicode Driver version 5.2.7, (32-bit and 64-bit). Presumably you install the 32 bit version if you’re using FileMaker 15 and the 64 bit version if you’re using FileMaker 15. Again confusingly, I’m sure I used to use the version 3.51 in th past. Is this superseded?
Now I’ve started, I would dearly love to crack this once and for all.
All help gratefully received.