1 Reply Latest reply on Mar 8, 2011 2:21 PM by TSBear

    Filemaker Pro 9 Developer - ODBC data sources not available

    GrahamHughes

      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.