Search code examples
phpsqlitepdo

pdo sqlite could not find driver... php file not processing

Hi i'm received the could not find driver error when trying to connect to sqlite via a php file. I've set permission to 777... PHP Version 5.2.16, i have the module install. any reason why its not finding the driver, also php.ini is showing the extension pdo.so and pdo_mysql.so installed.

PDO

PDO support enabled PDO drivers mysql

pdo_mysql

PDO Driver for MySQL, client library version 5.0.92

try {
    // Connect to the SQLite Database.
    $db = new PDO('sqlite:.subscribers.db');
} catch(Exception $e) {
    die('connection_unsuccessful: ' . $e->getMessage());
}
Solution

  • You need

    [PDO_SQLITE]
extension=pdo_sqlite.so

    to be enabled, for sqlite:.subscribers.db

    or, for Windows:

    [PHP_PDO_SQLITE]
extension=php_pdo_sqlite.dll

    And of course this extension in your ext directory.