Clovertech

Cloverleaf ODBC Driver Custom Data Types

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Cloverleaf ODBC Driver Custom Data Types

  • Creator
    Topic
  • March 11, 2010 at 8:37 pm #51624
    Garrett Fletcher
    Participant

      Hello,

      Does the Cloverleaf ODBC driver support custom data types?

      Thanks,

      G

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • March 11, 2010 at 9:26 pm #71013
        Jim Kosloskey
        Participant

          Garrett,

          The constraint is with the target DB Type. Each has the DataTypes they support. As far as I know the ODBC Drivers support all of the target DB DataTypes.

          Now using ODBC against files rather than DBs might be a different story.

          email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

        • March 11, 2010 at 9:31 pm #71014
          Garrett Fletcher
          Participant

            Oracle is the database will be referencing. But our schema had some custom Data Types in the Oracle database. Will we be able to work with those custom data types within the database?

            Thanks,

            G

          • March 11, 2010 at 9:37 pm #71015
            Jim Kosloskey
            Participant

              Garrett,

              Look in the Data Direct Documentation (you can find it  @ http://www.datadirect.com support). There are tables of the DataTypes for Oracle.

              Sometimes the ‘custom’ datatypes are simply one of the other DataTypes.

              This is not something we run into because we don’t do the Sql inside Cloverleaf(R).

              We found it much better to simply invoke a Stored Procedure on the DB in question and let them take care of the DataType stuff.

              email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

            • March 11, 2010 at 9:56 pm #71016
              Garrett Fletcher
              Participant

                Thank you for the link. I looked it up, there is no mention of custom data types. I bet we can at least select the data in the custom types.

                So can we just downlaod and use this ODBC driver to connect to a Oracle database, and somehow run SQL statements in TCL? Or do we need to buy the driver from Cloverleaf.

                Thanks,

                Garrett

              • March 11, 2010 at 11:22 pm #71017
                Jim Kosloskey
                Participant

                  Garrett,

                  If you are on UNIX you need to purchase the Data Integrator (ODBC Drivers) from Healthvision/Lawson.

                  If on Windows you can use the native ODBC to whatever extent you can reference it from Tcl.

                  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

              • Author
                Replies
              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.