4 Replies Latest reply on Oct 15, 2016 5:47 AM by wimdecorte

    Create an ODBC Data Source

    sp-1370

      Hi Guys,

       

      I'm fairly new to connecting databases to systems, in fact this is my first time.  So, I've read all of the documentation, blogs, watched YouTube videos and think I have a fairly good handle on what I'm supposed to do.  But I think I'm missing one very important piece and I'm hoping you can help me out.

       

      I have ensured the FileMaker Server and the FileMaker DB are ODBC enabled; I have then created a User DSN and a System DSN for our Oracle DB (I wasn't sure which DSN should be created) through C:\Windows\SysWOW64\odbcad32.exe and tested the connections and they were both successful.

       

      Then I went into my FileMaker DB to add a new External Data Source, however when I try to "specify" the DSN I don't see any listed.  Am I doing something wrong?  The FileMaker DB is being hosted on the FileMaker Server, so do I need to do something on the Server to see the Data Sources?

       

      Thanks for your help,

      Rachael

        • 1. Re: Create an ODBC Data Source
          David Moyer

          Hi,

          yes, your DSN should be defined on your server (on Windows, it's ODBC Data Sources control panel).  This is good because it means that you don't need to do it on the client machines.

          There might also be issues between 32 and 64-bit drivers/machines.

          • 2. Re: Create an ODBC Data Source
            David Moyer

            I should add that Perform Script on Server is required to take advantage of a single DSN on your server.  You probably knew that ... but, it is a forum.

            • 3. Re: Create an ODBC Data Source
              user19752

              I have ensured the FileMaker Server and the FileMaker DB are ODBC enabled; I have then created a User DSN and a System DSN for our Oracle DB (I wasn't sure which DSN should be created) through C:\Windows\SysWOW64\odbcad32.exe and tested the connections and they were both successful.

               

              You defined 32bit DSN. FMS is 64bit so use C:\Windows\System32\odbcad32.exe on server for DSN used in ESS.

              The folder name is confusing... WOW64 is Windows on Windows64, it is not for 64bit.

              1 of 1 people found this helpful
              • 4. Re: Create an ODBC Data Source
                wimdecorte

                sp-1370 wrote:

                 

                 

                 

                I have ensured the FileMaker Server and the FileMaker DB are ODBC enabled;

                 

                If you want to use data from Oracle then the settings  you mention here are not relevant, and can in fact introduce a security issue if that is important.  These settings are meant to let other applications access the FM data through xDBC and do nothing for letting FM access data from other sources.