Clovertech

Cloverleaf 6.0 ODBC connection

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Cloverleaf 6.0 ODBC connection

  • Creator
    Topic
  • March 11, 2013 at 6:51 pm #53558
    Mike Campbell
    Participant

      AIX platform.  Dual ‘root’ install of CL 5.7 – patch 2 and 6.0

      On 5.7, we have the odbc connection used to access external databases.

      The configuration is in the /lib/Connect5.3 directory in the file odbc.ini

      I do not see any Connect*.* in the 6.0 lib/ directory.  Does this new install use something different?

      Thanks.

      Mike C.

    • Creator
      Topic
    Viewing 5 reply threads
    • Author
      Replies
      • March 11, 2013 at 7:33 pm #78108
        Jim Kosloskey
        Participant

          Mike,

          I just looked at that briefly last week and I saw what I expected (don’t recall the details and I do not have access to that platform right now).

          Did you install Data Intgrator? I know a stupid question but if not, might explain why it is not there.

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

        • March 12, 2013 at 3:17 pm #78109
          Mike Campbell
          Participant

            😳

            Knew there was something missing…

            Installed that and will resume testing.

          • May 20, 2013 at 10:16 pm #78110
            Peter Heggie
            Participant

              the odbc.ini file delivered with the 6.0 install refers to SQL Server Wire Protocol, where the 5.8 odbc.ini refers to SQLServer Wire Protocol. Yes there is a space between SQL and Server. This stopped our production implementation of 6.0 until I found it. You can take the space out in the header and the protocol section name, or you can add another header entry without the space but having the same value.

              Peter Heggie
              PeterHeggie@crouse.org

            • May 21, 2013 at 7:50 pm #78111
              Jim Kosloskey
              Participant

                Peter,

                What issue exactly did you experience before adjusting the odbc.ini file?

                Thanks

                Jim Kosloskey

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

              • May 21, 2013 at 7:53 pm #78112
                Peter Heggie
                Participant

                  The connect failed; the preceding statements allocating handles and setting timeouts succeeded.

                  Peter Heggie
                  PeterHeggie@crouse.org

                • May 21, 2013 at 8:51 pm #78113
                  Jim Kosloskey
                  Participant

                    Peter,

                    Thanks.

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

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