Announcement

Collapse
No announcement yet.

program won't run from a batch file

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #21
    Originally posted by Chris Holbrook View Post
    Maybe the ODBC driver is an oldie too. ODBC drivers were not exactly reliable when I first made their acquaintance in the 90s.

    Which version of ODBC does the driver implement?
    CONNX 10.5 is what I use. v13 is the most current.
    Dataflex DF32 does not have a native SQL driver, or native SQL ability, afaik.

    Comment


    • #22
      "CONNX works by accepting SQL commands through the ODBC interface, then converting those calls to navigational commands to the DataFlex DBMS and returning record sets that qualify for the query results. This driver is not a Client/Server product, and navigates the data files directly."

      Whatever that means. I read it as "DataFlex 3.2 doesn't natively do SQL"

      Comment


      • #23
        Originally posted by Shawn Anderson View Post
        "CONNX works by accepting SQL commands through the ODBC interface, then converting those calls to navigational commands to the DataFlex DBMS and returning record sets that qualify for the query results. This driver is not a Client/Server product, and navigates the data files directly."

        Whatever that means. I read it as "DataFlex 3.2 doesn't natively do SQL"
        Correct. Dataflex uses its own proprietary "4GL" language.
        Based on the last bit of that quote, it doesn't use Datraflex's DFQuery engine to retrieve the data.

        It accepts an ODBC connection, receives SQL commands and pulls the requested data directly from the Dataflex data and index tables without going through the DFQuery engine. How well it does that appears to be debatable .


        CONNX seems very similar to FlexODBC - the FlexODBC site has exactly the same wording

        http://www.flextools.com/flexodbc
        "FlexODBC works by accepting SQL commands through the ODBC interface, then converting those calls to navigational commands to the DataFlex DBMS and returning record sets that qualify for the query results. This driver is not a Client/Server product, and navigates the data files directly."
        --
        [URL="http://www.camcopng.com"]CAMCo - Applications Development & ICT Consultancy[/URL][URL="http://www.hostingpng.com"]
        PNG Domain Hosting[/URL]

        Comment


        • #24
          have you ever used FlexODBC?

          Comment


          • #25
            Originally posted by Shawn Anderson View Post

            CONNX 10.5 is what I use. v13 is the most current.
            Dataflex DF32 does not have a native SQL driver, or native SQL ability, afaik.
            I don't think there is an ODBC version > 4.

            Comment


            • #26
              Originally posted by Chris Holbrook View Post

              I don't think there is an ODBC version > 4.
              I mean 10.5 version of CONNX, not ODBC

              Comment


              • #27
                CONNX seems very similar to FlexODBC - the FlexODBC site has exactly the same wording .... "FlexODBC works by accepting SQL commands through the ODBC interface, then converting those calls to navigational commands.."
                Um, er... It's not all that surprising they sound alike...because that's what ODBC drivers DO!

                Michael Mattias
                Tal Systems Inc.
                Racine WI USA
                mmattias@talsystems.com
                http://www.talsystems.com

                Comment


                • #28
                  Originally posted by Michael Mattias View Post

                  Um, er... It's not all that surprising they sound alike...because that's what ODBC drivers DO!
                  Not necessarily true. A lot of ODBC drivers interface to the DBMS, not to the data files. (You need SQL Server to be running on the server for the SQLServer ODBC driver to work. You point the Driver to the Server instance, not to the location of the data files.).

                  The driver(s) in question don't require a DBMS to be running anywhere, they access the Dataflex data and index files directly

                  And they don't just "sound alike". The wording is identical. That IS surprising if they are different products by different companies.
                  --
                  [URL="http://www.camcopng.com"]CAMCo - Applications Development & ICT Consultancy[/URL][URL="http://www.hostingpng.com"]
                  PNG Domain Hosting[/URL]

                  Comment


                  • #29
                    A lot of ODBC drivers interface to the DBMS, not to the data files
                    Huh?

                    An ODBC driver accepts commands (including "execute SQL statement") in the official ODBC format and does - opaquely - whatever it needs to do to match the command n the target database regardless of DBMS structure. HOW it does it or EXACTLY what it does are immaterial.

                    Some drivers may require a service be running ( Oracle; SQL/Server); others don't and access data storage (files) directly (MS-Access).

                    But I'll buy the "identical wording" as an... er, "interesting" observation.
                    '
                    Michael Mattias
                    Tal Systems Inc.
                    Racine WI USA
                    mmattias@talsystems.com
                    http://www.talsystems.com

                    Comment

                    Working...
                    X