Filemaker Pro 9 Developer - ODBC data sources not available
Windows 7 professional
I am experiencing this problem when using Filemaker Pro 9 Developer on my Windmws-7 professional desktop.
If I create a DSN (through control panel) to a SQL data source, the DSNdoes not appear in the list for selection when I try to access it from Filemaker - using Manage External Data Sources.
This works fine when I do it on older machines running XP or Vists.
Is there a fix available so that this will work correctly under Windows-7?
1. Create User or System DSN via ODBC administrator. Link to SQL data source and test = OK.
2. Filemaker > Manage External Data sources > Select ODBC.
3. DSN does not appear in the list.
DSN should be available for selection
DSN does not appear in the list
Works fine if done on XP or Vista machine.
Copy the filemaker file to another machine, setup the DSN and copy it back to W7 machine.
Thanks for posting!
Is this Windows 7 64-bit? If it is, try creating the DSN again, but this time use the 32-bit version of the ODBC Data Source Administrator tool. You should be able to find it here: C:\Windows\SysWoW64\Odbcad32.exe