Clovertech

using tclodbc

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › using tclodbc

  • Creator
    Topic
  • December 12, 2005 at 1:46 pm #48195
    John Harvey
    Participant

      Hello,

      I’m attempting to use a package called tclodbc within an engine process and it isn’t connecting to our database.  I get the error “client unable to establish connection”.  If I call the same code outside of the Quovadx application (for instance, calling it from hcitcl), the tcl code I have works just fine.

      I’ve seen past threads here where people mentioned using this package. Has anyone encountered this before?

    • Creator
      Topic
    Viewing 2 reply threads
    • Author
      Replies
      • December 15, 2005 at 2:05 pm #57972
        James Cobane
        Participant

          John,

          What OS are you running on?  I am looking forward to any responses to this topic as well as I would like find out how well the tclodbc works.

          Thanks,

          Jim Cobane

          Henry Ford Health

        • December 15, 2005 at 3:03 pm #57973
          John Harvey
          Participant

            we are using the windows platform.  

            It’s a strange situation I’m having because I have a tcl proc that connects to sql server 2000 and writes an insert statement to a few tables.  When I run the proc from the Testing Tool provided in Quovadx, the program succeeds with no problems.  I can go to sql 2000 and see the data that the proc wrote to it.

            However, when I place the code within an interface thread, I get the error of “client unable to establish a connection” when the actual code is called.  What gives?  If it works with the testing tool, why won’t it work in the actual interface?

          • June 14, 2006 at 12:19 pm #57974
            John Mercogliano
            Participant

              John,

              Did you ever resolve the problem? I just ran into the same issue using the smtp package.  It would work from the testing tool but when run from with in cloverleaf tps I could get a could not open socket error and it would return a -1.  We ended up writing a standalone mail tcl script that we then called with in the tps using exec and this works.  For some reason cloverleaf will not let you open a socket from with in the engine directly.

              John Mercogliano
              Sentara Healthcare
              Hampton Roads, VA

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