5 Replies Latest reply on Jul 23, 2013 12:50 AM by davidd

    ODBC and FM Server

    typeleven

      Title

      ODBC and FM Server

      Your post

      I want to have my database pull some data from an ODBC source. I also want to serve this from FM server. Does the ODBC connection happen on the server or do I have to setup the ODBC drivers on each host machine?

        • 1. Re: ODBC and FM Server
          Datagrace

          You only need the DSN on the server. Set it up on the FMS box, and add it as a data source in the Filemaker file. 

           

          • 2. Re: ODBC and FM Server

                 Hi, I have the same issue. Basically I want to do this: (see linked image)

                 I have a win2k8r2 server with a 32bit 4D odbc driver installed and configured as a data source.

                 How can I make it communicate with filemaker server?

                  

                 Thank you very much.

                  

            • 3. Re: ODBC and FM Server
              davidd

                   Hi, you may have resolved this by now but this is my take on how you go about it.

                   As outlined you add the relevant driver to Windows Server with the settings that point to the data source etc.

                   You then add an External Data Source (Manage menu/External Data Source) - if its set up correctly it will be in the list (we are using MySQL and we initially had issues with driver related to 32 and 64 bit issues)

                   You then add a (shadow) table in the Relationship Graph (Manage/Database - select Relationship tab)

                   When you add the table you can specify the External Data Source from the Data Source pull down menu.

                   You can then add a layout which uses the external table to show the records.

              • 4. Re: ODBC and FM Server

                     Ok, I wasted hours of time (for the 64bit bug too).

                      

                     IT DOESNT SUPPORT ALL SQL SOURCES!

                     I have 4D and it doesn't connect to it!  : (

                • 5. Re: ODBC and FM Server
                  davidd

                       Yep, sorry missed the 4D reference - bit of a pain if there is no way to connect.

                       We are using it for MySQL and there is a driver (although I think it could be improved).