Announcement

Collapse
No announcement yet.

[SOLVED]SQLite not working with SC8

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED]SQLite not working with SC8

    I just tried to generate a simple App based on existing SQLite database. Everything seems to be configure correctly but SC8 throws an error

    sqlite_bug03.jpg

    sqlite_bug01.jpg


    sqlite_bug02.jpg



    switching from SQLite PDO to SQLite driver causes error as well
    ERROR:
    The extension is not loaded on the php.ini file.
    Click on the help icon for more informations.


    Here is a fragment of PHP.INI responsible for SQLite
    ..........
    ; Windows Extensions
    ; Note that ODBC support is built in, so no dll is needed for it.
    ; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
    ; extension folders as well as the separate PECL DLL download (PHP 5).
    ; Be sure to appropriately set the extension_dir directive.
    ;
    ;extension=php_bz2.dll
    extension=php_curl.dll
    extension=php_fileinfo.dll
    extension=php_gd2.dll
    extension=php_gettext.dll
    ;extension=php_gmp.dll
    extension=php_intl.dll
    ;extension=php_imap.dll
    extension=php_interbase.dll
    extension=php_ldap.dll
    extension=php_mbstring.dll
    ;extension=php_exif.dll ; Must be after mbstring as it depends on it
    extension=php_mysql.dll
    extension=php_mysqli.dll
    extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
    extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
    extension=php_sqlsrv_54_nts.dll
    ;extension=php_mssql.dll
    extension=php_dblib.dll
    extension=php_com_dotnet.dll
    extension=php_pdo_firebird.dll
    extension=php_openssl.dll
    extension=php_pdo_sqlsrv_54_nts.dll
    extension=php_pdo_mysql.dll
    ;extension=php_pdo_oci.dll
    extension=php_pdo_odbc.dll
    extension=php_pdo_pgsql.dll
    extension=php_pdo_sqlite.dll

    extension=sqlite.dll
    extension=php_pgsql.dll
    extension=php_pdo_informix.dll
    ;extension=php_pspell.dll
    ;extension=php_shmop.dll
    ........................

    PS>
    I've tested this same database file with SC7 and it works OK

    Arthur
    Last edited by aka; 10-13-2014, 10:00 PM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    Hello,

    Issue reported to our bugs team.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      It all worked fine in SC7
      this is crucial, please report when this would be fixed ?
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment


      • #4
        Hello Arthur,

        I will let you know on any feedbacks from our bugs team.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Hello,

          PHP 5.4 does not support the SQLite 2, connection available in Scriptcase.
          We will be enabling SQLite 3 connection in the next updates.
          Best Regards,
          John L. Santos

          Bug Tracker Team
          NetMake - IT Solutions

          Comment


          • #6
            Hello,

            Its database is SQLite2 or SQLite3?
            If possible, send us your database to do tests.
            Best Regards,
            John L. Santos

            Bug Tracker Team
            NetMake - IT Solutions

            Comment


            • #7
              It is SQLite3 (which is available at least to 2-3 years already) and I have existing data which I need to connect to
              Yes I can send you a data file but only on personal email (it is not for public sharing). Although I do not see much sense to do that.
              I am able to connect to this same database with SC7 but not with SC8

              Art
              Last edited by aka; 10-10-2014, 02:10 AM.
              -----------------------------------------
              Arthur Klisiewicz
              dATA POINT SOFTWARE
              www.datapointsoftware.com

              Comment


              • #8
                Hello,

                I'm sorry, my e-mail is j.lennon@netmake.com.br
                Best Regards,
                John L. Santos

                Bug Tracker Team
                NetMake - IT Solutions

                Comment


                • #9
                  this is crucial !


                  any progress ?
                  -----------------------------------------
                  Arthur Klisiewicz
                  dATA POINT SOFTWARE
                  www.datapointsoftware.com

                  Comment


                  • #10
                    Hello,

                    Your problem has already been reported to our development team and will be fixed in the next updates.
                    Best Regards,
                    John L. Santos

                    Bug Tracker Team
                    NetMake - IT Solutions

                    Comment


                    • #11
                      Hello,

                      The SQLite connection uses the SQLite_PDO and SQLite3 drivers, so for you to connect to SQLite3, you should use the SQLite_PDO connection.
                      Best Regards,
                      John L. Santos

                      Bug Tracker Team
                      NetMake - IT Solutions

                      Comment

                      Working...
                      X