7 Replies Latest reply on May 18, 2016 7:46 AM by user26893

    ODBC

    user26893

      I'm trying to connect to 4D server v13.6 on OSX 10.9.5 using filemaker pro 15 on el capitan 10.11.4. Someone can suggest me how to do because using external data source i can't see the odbc source and using odbc manager i have a successful connection between the machine that are on 192.168.1.xxx local network

        • 1. Re: ODBC
          mikebeargie

          Have you already setup a DSN pointing to the datasource in the OSX ODBC Manager? That's located under Applications > Utilities > ODBC Manager.

           

          You have to setup a DSN to your ODBC datasource BEFORE you are able to view that data source inside of FileMaker's External Data Source dialog.

          • 2. Re: ODBC
            user26893

            Dearets Mike,

             

                 thanks a lot for Your support. Yes I've set up the OSX ODBC manager with some slight modification to the odbc.ini and odbcinst.ini - so actually i can see from filemaker external data source the ODBC source that i'd netted up. But no way to work ... may be as Beverly says i need to do the sync procedurally and not with live connection?

            • 3. Re: ODBC
              mikebeargie

              Correct, 4D is not supported for ESS:

              https://www.filemaker.com/downloads/documentation/techbrief_intro_ess.pdf

              (page 5, supported sources)

               

              So you would either be using the Import Records, or Execute SQL script steps to get information from your ODBC source.

              • 4. Re: ODBC
                user26893

                Dearest Mike,

                 

                     thanks truly a lot for document and infos, anyway I'll keep on trying to establish some connection between 4D Server and Filemaker ... anyway the document refer to FM10 so maybe till FM15 there's some changes and at least i can try via import record s or other scripts ... I'll keep the post updated if I collect news

                • 5. Re: ODBC
                  mikebeargie

                  Fundamentally it is the same. I know for a fact that 4D is not supported for ESS in FileMaker 15. Generic ODBC is still supported for the other methods I've pointed to.

                  • 6. Re: ODBC
                    user26893

                    Dearets Mike,

                     

                    thanks a lot again for infos, so i didn't waste time I'll try something that can automated with applescript or so on

                    • 7. Re: ODBC
                      user26893

                      I have this two alert from filemaker pro 15 right now:

                       

                      1st

                       

                      "You have exceeded the maximum allowed login attempts"

                       

                      2nd

                       

                      "this title could not be imported because it is password protected"

                       

                      have suggestions?