I think I have misread your original posting.
Can you upgrade your version of PHP?
I use PHP version 5.2.1.
Running phpinfo() reveals the PDO driver to be:
PECL version: 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.1 2007/01/01 09:36:05
sebastian Exp $
Sqlite Library: 3.3.7undefined
Since you can run sqlite3 against the database without issue,
it appears that the version embedded in PHP is the problem.
Chris Peachment
------------------
On Thu, 10 May 2007 08:46:30 -0400, Brandon Eley wrote:
>Thank you for this information. How would I access the 2.8.x database
>from within PHP? is it even possible?
>The database is created from a shopping cart program, so I can't
>upgrade it, it has to remain the same version (for now).
>Brandon Eley
>[EMAIL PROTECTED]
>On May 9, 2007, at 10:59 PM, Chris Peachment wrote:
>> There was a change of file structure with version 3.x.x
>> and this is described in the documentation under Version 3
>> Overview.
>>
>> You are attempting to use Sqlite3 on a version 2.8.x database
>> and the formats are not compatible.
>>
>>
>> On Wed, 9 May 2007 19:42:06 -0400, Brandon Eley wrote:
>>
>>> I've gone through a few tutorials and can't seem to get this right.
>>> I've had my web host install the PECL extension and the following is
>>> what is in my phpinfo();
>>
>>> sqlite
>>> SQLite support enabled
>>> PECL Module version 1.0.3 $Id: sqlite.c,v 1.62.2.25 2004/07/10
>>> 12:25:33 wez Exp $
>>> SQLite Library 2.8.14
>>> SQLite Encoding iso8859
>>
>>> Directive Local Value Master Value
>>> sqlite.assoc_case 0 0
>>
>>> ***********************************
>>
>>> This is the PHP code I'm using:
>>
>>> <?php
>>> $db = sqlite_open("/home/xxx/data/xxx.db");
>>> ?>
>>
>>> ***********************************
>>
>>> This is the error I'm getting:
>>
>>> Warning: sqlite_open() [function.sqlite-open]: file is encrypted or
>>> is not a database in /home/xxx/public_html/test.php on line 140
>>
>>> ***********************************
>>
>>> What am I doing wrong? I can run queries all day long using the
>>> command line sqlite3 but I can't seem to get PHP to read the stinkin
>>> database!
>>
>>> Any help would be GREATLY appreciated!
>>
>>> Brandon Eley
>>> [EMAIL PROTECTED]
>>
>>
>>
>>
>>
>>
>>
>>
>> ----------------------------------------------------------------------
>> -------
>> To unsubscribe, send email to [EMAIL PROTECTED]
>> ----------------------------------------------------------------------
>> -------
>>
>-----------------------------------------------------------------------------
>To unsubscribe, send email to [EMAIL PROTECTED]
>-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
