3 Replies Latest reply on Sep 9, 2015 4:20 PM by Draco

    ODBC, ...not appear

    Draco

      Hi all, a question about ODBC.

       

      - I created an ODBC data source (DNS system,...I also tested with DNS user).

      - Authenticity via: Integrated Windows Authentication.

      - Enter the name of the database (BD is a ... SQL Server 2008r2,...driver v11)

      - I test the connection, ... successful test.

       

      In FileMaker, trying to create an external data source (ODBC) DNS newly created,... does not appear.

      .. ???

       

      Use : FMP 14 v2

       

      Any recommendation ?

      Thanks in advance.

       

      Draco

        • 1. Re: ODBC, ...not appear
          user19752

          Make sure which version of FMP/ODBC is used that 64bit or 32bit.

          • 2. Re: ODBC, ...not appear
            Draco

            Hi user19752,  (excuse my English)

             

            Server : SQLServer 2008 R2

             

            Client:

            - FMP 14 try

            - Windows 8.1 64bit

            - Driver 1 : ODBC Driver 11 for SQL Server   (01-11-2012)

            - Driver 2 : SQL Server 6.03.9600  (28-10-2014)

             

             

            DNS

            - user DNS ,... test ok,... with driver 1 y 2.

            - system DNS ,... test ok,... with driver 1 y 2.

             

            • ...NOT VIEW DATASOURCE in script,
            • ...NOT VIEW DATASOURCE ESS.
            • ...only view ODBC ( when use DNS Drive 2), view the tables of DB. But only when create import (file-import records - datasource ODBC). But select table and field (generator query) and... PLAF ERROR. <<"ERROR ODBC... The name of object not valid (name table)">>

             

               ....thanks in advance

             

            Draco

            • 3. Re: ODBC, ...not appear
              Draco

              The DATASOURCE must be 32 bit