Clovertech

Intersystems Cache

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Intersystems Cache

  • Creator
    Topic
  • August 18, 2011 at 9:33 am #52650
    David Harrison
    Participant

      Cloverleaf 5.6 on Solaris 10

      I need to query an Intersystems Cache 2008.1 database from Cloverleaf. I have the Data Integrator v5.2 package but there is no Data Direct driver for this database.

    • Creator
      Topic
    Viewing 8 reply threads
    • Author
      Replies
      • August 18, 2011 at 12:30 pm #74988
        garry r fisher
        Participant

          Hi David,

          You will need the Intersystems Cache SQL driver. Not sure about a version for Solaris.

          Try iSOFT – They may be able to help you. I used it when I was at iSOFT on a couple of system – Windows and Linux.

          Regards

          Garry

        • August 18, 2011 at 12:40 pm #74989
          David Harrison
          Participant

            Thanks Garry,

            From what I’ve found out, the ODBC driver install files are on the Cache install disk so I’ll have to ask iSoft as you suggested. What I need to know is how to use it from tcl.

            Regards,

            Dave

          • August 19, 2011 at 11:16 am #74990
            David Harrison
            Participant

              Cloverleaf 5.6 on Solaris 10

              I

            • August 19, 2011 at 12:28 pm #74991
              garry r fisher
              Participant

                Hi Dave,

                It’s a few years since I did this but you have two options (I think)

                1. Append the ODBCINI with cacheodbc

                2. Edit odbc.ini and include the cacheodbc.ini contents.

                Option 2 will leave your environment alone as all you are changing is odbc.ini – If you make a copy before you change anything then nothing is lost.

                Once you have it in your environment use it like any other odbc driver in Tcl.

                Regards

                Garry

              • August 19, 2011 at 12:59 pm #74992
                David Harrison
                Participant

                  Garry,

                  Problem is how to append an environment variable to an existing one which has been set by hcisetenv.

                • August 22, 2011 at 7:59 am #74993
                  David Harrison
                  Participant

                    OK, Ive got the environment issue sorted and I’ve appended the dsn to the Data Direct ODBC.ini but I’m getting a connection error in tcl: ‘Connect Status: SQL_ERROR’.

                    This appears to indicate a problem with the dsn entry. Is it possible to diagnose the problem within tcl to a greater level of granularity?

                  • August 22, 2011 at 12:09 pm #74994
                    garry r fisher
                    Participant

                      Hi,

                      I’ll need to check my notes but there is a command you can use to return diagnostic info from a connection. Have a search on this forum – It has been mentioned before.

                      Regards

                      Garry

                    • August 22, 2011 at 12:48 pm #74995
                      Jim Kosloskey
                      Participant

                        Look up slqgetdiagrec oops- sqlgetdiagrec 😳  – it has options depending on whether at connect, exec, etc.

                        The Microsoft ODBC Knowledge Base site is a good source.

                        email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

                      • August 22, 2011 at 2:23 pm #74996
                        David Harrison
                        Participant

                          The result of using sqlgetdiagrec is

                        • [DataDirect][ODBC lib] Specified driver could not be loaded

                          • So it looks like it’s trying to use the Data Direct libraries instead of the Cache ones even though these are specified in the odbc.ini file.

                        • [Pastest]

                          Driver          = /usr/cacheodbc/bin/libcacheodbc.so

                          Description     = Cache ODBC driver

                          Host            = shadow

                          Namespace       = NAMESPACE

                          UID             = USER

                          Password        = PWD

                          Port            = 1972

                          Protocol        = TCP

                          Query Timeout   = 1

                          Static Cursors  = 0

                          Trace           = off

                          TraceFile       = iodbctrace.log

                          Authentication Method   = 0

                          Security Level  = 2

                          Service Principal Name = cache/localhost.domain.com

                          • Also, the environment variable is set to point to the Cache library.

                        • LD_LIBRARY_PATH=/usr/cacheodbc/bin:/export/quovadx/qdx5.6/integrator/clgui/java/

                          lib/sparc:/export/quovadx/qdx5.6/integrator/clgui/java/lib/sparc/server:/export/

                          quovadx/qdx5.6/integrator/lib:/export/quovadx/qdx5.6/integrator/bin:/export/quov

                          adx/qdx5.6/integrator/tcl/lib:/export/quovadx/qdx5.6/integrator/dbms/lib:/export

                          /quovadx/qdx5.6/integrator/lib/Connect5.2/lib:/usr/lib:/lib:/shlib:/usr/shlib

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