AnsweredAssumed Answered

Filemaker Pro 9 Developer - ODBC data sources not available

Question asked by GrahamHughes on Feb 16, 2011
Latest reply on Mar 8, 2011 by TSBear

Summary

Filemaker Pro 9 Developer - ODBC data sources not available

Product

FileMaker Pro

Version

Pro-9 Developer

Operating system version

Windows 7 professional

Description of the issue

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?

Steps to reproduce the problem

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.

Expected result

DSN should be available for selection

Actual result

DSN does not appear in the list

Configuration information

Works fine if done on XP or Vista machine.

Workaround

Copy the filemaker file to another machine, setup the DSN and copy it back to W7 machine.

Outcomes