troubles conecting to a sqlite database

[eluser]zilverdistel[/eluser]
I have the same problem. I got one step further though. On [a]http://www.php.net/manual/en/ref.sqlite.php[/a] I found that you need to install an extension php_sqlite. On my linux box I did apt-get install php5-sqlite, and added the following line in my php.ini:

Code:

extension=php_sqlite.dll

This still didn't work, but at least I got some response from the system now:

Code:

An Error Was Encountered

unable to open database: /www/CodeIgniter_1.6.1/db/MyDB

nevertheless, as I type, I noticed that my 'db' directory was not readable for the webserver, after I fixed it, it seems to work (according to the logfile, befor it ended with Database Driver Class Initialized).

Code:

DEBUG - 2008-03-14 02:18:55 --> Language Class Initialized
DEBUG - 2008-03-14 02:18:55 --> Loader Class Initialized
DEBUG - 2008-03-14 02:18:55 --> Controller Class Initialized
DEBUG - 2008-03-14 02:18:55 --> Database Driver Class Initialized
DEBUG - 2008-03-14 02:18:55 --> Final output sent to browser
DEBUG - 2008-03-14 02:18:55 --> Total execution time: 0.2869

So, I hope this helps for other people. If you want to use sqlite, php must be compiled with support for it, or the php_sqlite (and php_pdo) extension must be installed and configured in your php.ini. For more info, see the above link to the php website.