3 Replies Latest reply on Feb 17, 2012 2:46 PM by philmee95

    FMPro 11 ODBC Data Source on Windows 7

    RonSteiner

      Title

      FMPro 11 ODBC Data Source on Windows 7

      Post

      I need suggestions as to how to debug this problem:

      I am running FMPro 11.0v2 on Windows 7 (64bit). I have data in a MySQL database that I'd like to link to with FM Pro.  I have set up the MySQL ODBC DSN using the 32 bit drivers.

      When I do an import the 'Select ODBC Data Source' list is populated as I'd expect with all the local ODBC DSNs and I can import data from the MySQL ODBC DSN I set up with no difficulty.

      But if I try to link to the data instead of import it (using File | Manage ... | External Data Sources | New... | Edit Data Source and selecting ODBC, then Specify ... button) no DSNs appear in the 'Select ODBC Data Source' list.

      What should I do next to figure out why?

      Thanks

        • 1. Re: FMPro 11 ODBC Data Source on Windows 7
          Patrick Maurer

          I've got the same problem. Have you made any progress?

          • 2. Re: FMPro 11 ODBC Data Source on Windows 7
            RonSteiner

            I'm still testing, but think I am making progress. Unfortunately, I've learned of no better ways to debug this than trial and error.

            Here are some things you can check/try:

            1) Ensure you're using the 32 bit ODBC Data Source Administrator to set up the DSN. (From the SysWOW64 folder).

            2) Ensure you're using the MySQL ODBC 3.51 Driver.

            3) Create/use a System DSN (Not User DSN).

            4) Ensure you don't have a conflicting DSN set up in the 64 bit ODBC Data Source Administrator. (May be best to get rid of all 64 bit DSNs at least for setup/ test purposes.)

            I'm waiting for a fresh copy of FM to set up a clean install on a test machine. Hopefully it will go smoothly.

            • 3. Re: FMPro 11 ODBC Data Source on Windows 7
              philmee95

               System datasource. 64 bit DSN are never used sincefmp is 32 bit (had lots of fun with this in SQL server SSIS also). (run / search box and type ODBC. Select ODBC and not odbc 64)

              Linked tables have to have the user and password saved in the dsn itself. Only the server needs to be setup with the DSN used in the external datasource DSN, not each client using linked tables. Script step imports though will need a local DSN as that is all client side.