ODBC in cloverleaf

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf ODBC in cloverleaf

  • Creator
    Topic
  • #49399
    Hongle Sun
    Participant

      We would like to retrieve some data in sql server/window. populate those data in oracle database…. since it cross the different server, I think of the cloverleaf interface engine’s odbc option, can anyone who experienced ODBC in cloveaf throw some light on it and i got some ideal, any input will be much appriciated, again i am new to ODBC in cloverleaf…. thanks

    Viewing 8 reply threads
    • Author
      Replies
      • #61785
        Austin Adams
        Participant

          I’m currently experimenting with the TCL ODBC driver functionality within Cloverleaf.  The product is a DataDirect product (I think).  I am just a newbie when it comes to using and configuring Cloverleaf.  I

        • #61786
          garry r fisher
          Participant

            Hi,

            The ODBC Tcl extensions provided by Quovadx are quite good but I have found them to be a bit ‘fussy’ sometimes.

            I have connected to Oracle, MS SQL Server and MySQL using both DataDirect and Native drivers.

            I run a course teaching Tcl and ODBC but I’m afraid this is only available in the UK – Any body want to fund my trip to the States:-)?

            Regards

            Garry

          • #61787
            Richard Hart
            Participant

              I have not used ODBC, but I have experimted with JDBC and have succesfully connected to our PAS systems Oracle (7.3!) database without issue and with no Oracle software installed on our (AIX) server.

            • #61788
              Dennis Pfeifer
              Participant

                Just my ignorance .. how do you connect the JDBC to your TCL?

                Dennis

              • #61789
                Hongle Sun
                Participant

                  Thanks, Austin, would you  mind giving me some details pieces which are you working on, thus, i can start from them, send me email if you dont mind @ hosun@tegh.on.ca.. Thanks all

                • #61790
                  Richard Hart
                  Participant

                    We use the Cloverleaf Java hooks to call the Java classes.

                  • #61791
                    Dennis Pfeifer
                    Participant

                      Richard ,

                      Are you using TCLBlend, or writing Java UPOCs?

                      Dennis

                    • #61792
                      Richard Hart
                      Participant

                        Dennis.

                        We are using the Java UPOC’s.

                      • #61793
                        Sundeep Kumar
                        Participant

                          Austin Adams wrote:

                          I’m currently experimenting with the TCL ODBC driver functionality within Cloverleaf.

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