2 Replies Latest reply on Feb 26, 2009 11:49 PM by diquito

    ODBC Connection to AS400



      ODBC Connection to AS400


      Hi All,

      Has anyone managed to create a ODBC connection to a AS400 database?

      I have manage to import a table through the ODBC connection but when I try to link it as a relation it fails..

      I use WIndows XP so the odbc is a standard DSN connection.

      I use filemaker 10 advanced.


        • 1. Re: ODBC Connection to AS400

          Hello Diquito,


          FileMaker can perform ODBC imports from other software providing you have the correct driver from the software manufacturer of the source of the data (AS400). You can setup your ODBC Data source in the FileMaker file if you wanted to script an ODBC Import.


          That said, you cannot relate that ODBC Data source to your FileMaker tables unless it is one of the supported External SQL sources. The ESS feature allows you to create relationships and pull live data from a number of SQL sources, and you can find more information on that here: link


          In short, you cannot relate an AS400 data source to a FileMaker table. For more information about ODBC you can visit: link


          If I have misunderstood your situation, or you have further questions please feel free to ask away :)




          FileMaker, Inc.


          • 2. Re: ODBC Connection to AS400

            Hi TSNanner,

            Thanks for the reply.. yes it solves the problem. I managed to after some googleing to get to the same conclusion yesterday.

            So I have to make do with the import only.


            Thanks again.