invalid data source name with PDO Sqlite

Question

I'm having this error when trying to do a request from a PDO object (with ez_sql) on a sqlite database.

I read here: http://us.php.net/manual/en/ref.pdo-sqlite.php that the db could be empty and that pdo will create automatically the db file.

So i do :

$ezSQL = new \ezSQL_pdo('sqlite:'.CHM.'/includes/stouv.sq3'); // file exists and is empty
// query on the $ezSQL object

And i get this error :

invalid data source name

I'm using the last version of WAMP with pdo_sqlite extension..

I don't know how to fix it.

What is the value of the `CHM` constant? The path to the file needs to be writable by PHP — Phil, Nov 29 '11 at 21:21
only a dot: '.'. This: `$ezSQL = new \ezSQL_pdo('sqlite:includes/stouv.sq3');` product the same error. — Leto, Nov 29 '11 at 21:30
Try `__DIR__ . '/includes/stouv.sq3'`. Is that file writable by PHP? — Phil, Nov 29 '11 at 21:46

score -1 · Answer 1 · answered Nov 29 '11 at 22:18

-1

Ok, the problem was that ez_sql do not connect to the DB before the first query, because no username and password were set (second and third argument of the constructor).

answered Nov 29 '11 at 22:18

Leto

2,594
3
24
37

invalid data source name with PDO Sqlite

1 Answers1