josep asked 10 years ago
No achievement estableder grid connection with firebird php to run
consultation
$ db_conf = array ();
$ db_conf ["type"] = "firebird";
$ db_conf ["server"] = "localhost";
$ db_conf ["user"] = 'SYSDBA';
$ db_conf ["password"] = 'masterkey';
$ db_conf ["database"] = "c: development bd gesthor.gdb";
g = new jqGrid $ ($ db_conf);
$ query = "select * from USERS ';
$ g-> select_command = $ query;
$ out = $ g-> render ("activity");
returns the error
Could not execute query. Dynamic SQL Error SQL error code = -104 Token unknown – line 1 char 34 LIMIT – select * from USERS WHERE 1 = 1 LIMIT 1 OFFSET 0
Thank You
Abu Ghufran answered 10 years ago
There are some known issues with firebird connectivity.
We are currently working to resolve it and will update you on success.
Abu Ghufran answered 10 years ago
The firebird database is not supported and we have delayed it's support.
If you have isolated php file that uses firebird using pdo, you can try those settings in phpgrid config.
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "firebird:host=localhost;dbname=C:EMPLOYEE.FDB";
$db_conf["user"] = "SYSDBA";
$db_conf["password"] = "masterkey";
$db_conf["database"] = "";
include("../../lib/inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);
Abu Ghufran answered 9 years ago
Firebird & SQLite support has been added in latest build.
More here: http://www.phpgrid.org/support-firebird-sqlite-databases/
