What string are you using to connect to your database?
// My sqlite 3 connection string
$db = new PDO('sqlite:stats.sqlite');
// My sqlite 2 connection string
$db = new PDO('sqlite2:test.sqlite');
Also, I had to uncomment an extension from php.ini
(extension=php_pdo_sqlite.dll), but I don't really know how that
translates to a *nix box (since I just mess around with sqlite on a
windows machine with apached installed).
On Wed, Jan 28, 2009 at 2:10 PM, Tony Bibbs <t...@tonybibbs.com> wrote:
> One other note of interest is if I go at the database with sqlite3 from
> command line not only can I get in I can run queries jut fine.
>
> On Wed, Jan 28, 2009 at 12:59 PM, Tony Bibbs <t...@tonybibbs.com> wrote:
>
>> I have a PHP/SQLite issue. I'm on Kubuntu with PHP 5.2.8. PHPInfo()
>> gives:
>>
>> PDO->PDO drivers: sqlite, mysql, sqlite2
>> pdo_sqlite->SQLite Library: 3.4.2
>>
>> Running a very simple query I get an error with the following (via
>> print_r):
>> Array ( [0] => HY000 [1] => 26 [2] => file is encrypted or is not a
>> database )
>>
>> What am I missing here? My hunch is the "sqlite2" in the PDO->PDO Drivers
>> is causing the problem. Thing is Adept shows me I have all sqlite3
>> packages.
>
>
> --
> Tony Bibbs
> Email: t...@tonybibbs.com Phone: 515.554.8046
> Twitter: tonybibbs Skype: tonybibbs
> Web: http://www.tonybibbs.com
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
~Ty
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
