[SOLVED]SQLite not working with SC8

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

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

sqlite_bug03.jpg

sqlite_bug01.jpg

sqlite_bug02.jpg

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann

It all worked fine in SC7
this is crucial, please report when this would be fixed ?

Hello Arthur,

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

regards,
Bernhard Bernsmann

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.

Hello,

Its database is SQLite2 or SQLite3?
If possible, send us your database to do tests.

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

Hello,

I’m sorry, my e-mail is j.lennon@netmake.com.br

[size=7]this is crucial ![/size]

                            any progress ?

Hello,

Your problem has already been reported to our development team and will be fixed in the next updates.

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.