3 Replies Latest reply on Mar 11, 2017 2:05 PM by Sean_Wilson

    How do I access DBF databases from Director

    Level 7
      Hi

      I need to access DBF files from Director.
      How can this be done?

      Is there any Xtra that works directly with DBFs or do I need to work with
      this files through ODBC?

      Thanx in advance
      LM


        • 1. Re: How do I access DBF databases from Director
          Level 7
          LM wrote:
          > Hi
          >
          > I need to access DBF files from Director.
          > How can this be done?
          >
          > Is there any Xtra that works directly with DBFs or do I need to work
          > with this files through ODBC?
          I worked for a company who makes a binary io xtra. And I wrote an example
          for this xtra to read dbf files.
          You can find it here
          http://www.g5tools.com/index_a.php

          --
          Bubar - Wapiti Studio
          http://www.wapitistudio.com
          Xtras for Director : http://www.wapitistudio.com/xtra.htm


          • 2. Re: How do I access DBF databases from Director
            Level 1

            You may checkout this manual process:

            To configure a connection manager to connect to a dBASE or other DBF file

            1. Add a new OLE DB connection manager to the package. For more information.

            2. On the Connection page of the Connection Manager dialog box, select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider as the Provider.

            3. When working with DBF files, the folder represents the database, and the individual DBF files represent tables. Therefore the Database file name text box must contain the path of the folder where the DBF file resides, and must not include the file name itself. You can type or paste in a folder path, or you can use the Browse button to select your DBF file, and then remove the file name from the end of the folder path.

            4. On the All page of the Connection Manager dialog box, enter dBASE III, dBASE IV, or dBASE 5.0, as appropriate, as the value of Extended Properties.

            5. Click Test Connection to validate the values that you have entered. You should see the message, "Test connection succeeded." Click OK to close the message box.

            6. Click OK to save the configuration for the connection manager.

            7. To use your connection manager in the data flow of the package, select an OLE DB source or destination and configure it to use the connection manager that you created by using the preceding steps

            • 3. Re: How do I access DBF databases from Director
              Sean_Wilson Adobe Community Professional

              Not much point replying to a post from more than 10 years ago. One would expect the OP has moved on…