Clovertech

SQLite Questions

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › SQLite Questions

  • Creator
    Topic
  • October 27, 2009 at 8:09 pm #51283
    Garrett Fletcher
    Participant

      Hi Everyone,

      I need to script some information into a table from an interface, and read it later in another interface. I dont really want to pay for the Data Integrator product just for this one task. From what I have read here it looks like SQLite is the best way to go.

      I am trying to gather info on installing it on QDX 5.3. A lot of the threads say to call your support staff for help. My question is are they going to try to charge me for help setting up SQLite?

      Thanks.

      Garrett

    • Creator
      Topic
    Viewing 11 reply threads
    • Author
      Replies
      • October 27, 2009 at 8:41 pm #69518
        Max Drown (Infor)
        Keymaster

          Garrett, is is pretty simple to install and use sqlite. I’ll include my notes for 5.6 below, but you should search the forum as there is tons of good info out there.

          -- Max Drown (Infor)

        • October 27, 2009 at 8:43 pm #69519
          Max Drown (Infor)
          Keymaster

            * Download tclsqlite for linux from here: http://www.sqlite.org/download.html

            -- Max Drown (Infor)

          • October 27, 2009 at 9:07 pm #69520
            Garrett Fletcher
            Participant

              Wow thanks that is great info. I will get started on this today and post again if I run into trouble.

              Thanks again!

              Garrett

            • October 27, 2009 at 9:32 pm #69521
              Garrett Fletcher
              Participant

                Anyone know how to set up SQLite in Windows? I am trying to update my pkgIndex.tcl, but I have like 15 pkgIndex.tcl files. Which one do I update?

                Thanks,

                G

              • October 28, 2009 at 3:21 pm #69522
                Troy Morton
                Participant

                  Some of my colleagues here at Hospital Sisters have said that Healthvision will not support QDX Cloverleaf Integrator if it co-exists on the same server with another application such as a Database or Web-Server, etc.

                  Can someone from Healthvision confirm/deny this?

                  I have to believe that Max still has a support contract with Healthvision, so I’m curious where this idea may have come from.

                  We currenlty use and external SQL database on a different server and connect to it with ODBC.

                • October 28, 2009 at 4:19 pm #69523
                  Garrett Fletcher
                  Participant

                    Update on my condition:

                    I was trying to use the pkg_mkIndex command to create the tclIndex file, but it would keep ending my TCL session and not create the file.

                    We are currnetly running TCL Ver 8.3. It turns out that SQLite is not compatable with TCL 8.3. We are going to have to upgrade to ver 8.4 or later in order for this to work.

                    I will post again after we upgrade.

                    G

                  • October 28, 2009 at 4:35 pm #69524
                    Jim Kosloskey
                    Participant

                      Troy,

                      First off I would not be concerned regarding support of Cloverleaf while using Sql-Lite.

                      Secondly, I would not count on Sql_lite replacing a full blown DB so I think ODBC is likely to remain in your future.

                      As to the connectivity issue, there are ways to detect if you are still connected and thus take remedial action if you are coded to expect a persistent DB connection via ODBC.

                      If you are coded to connect and dis-connect with each message then naturally you have the opportunity to detect connection issues with each message.

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

                    • October 28, 2009 at 4:46 pm #69525
                      Troy Morton
                      Participant

                        Thanks Jim.

                        We do detect the connection loss and the thread goes into a ‘wait’ state until a reply is received from the Db.  An automated email is sent to our support when this happens, so we can find out what happened with the ODBC connection during business hours.

                        Troy

                      • October 28, 2009 at 5:39 pm #69526
                        Rob Abbott
                        Keymaster

                          Troy – we will support Cloverleaf.  

                          What we can’t do is certify/qualify Cloverleaf on the same server as every software package on the planet.  We recommend that Cloverleaf is installed on a standalone server.

                          If you’re having an issue with Cloverleaf and we find (through tech support) that Cloverleaf is having issues due to conflicts with another app on the server, that’s where we would ask that you de-install the app that is causing a conflict.  It doesn’t mean we won’t provide support.

                          If you have detailed questions like this about support that you need someone from HV to confirm, please contact Support either through email (techsupport@healthvision.com) or phone  1-469-420-2525.  These channels are better for “official” answers.

                          Rob Abbott
                          Cloverleaf Emeritus

                        • October 28, 2009 at 6:03 pm #69527
                          Troy Morton
                          Participant

                            Thanks for the clarification, Ron.  This makes perfect sense.

                            Troy

                          • October 28, 2009 at 10:34 pm #69528
                            Max Drown (Infor)
                            Keymaster

                              Troy, SQLite actually comes bundled with Cloverleaf 5.7.  ðŸ˜€

                              -- Max Drown (Infor)

                            • October 29, 2009 at 1:28 pm #69529
                              Troy Morton
                              Participant

                                Sweet!!

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