Isn't it so that sqlite3 can't open certain
old sqlite2 database because of a format
change? At least I seem to remember
something like that. I would try opening
it with version 2.
Rob
----- Original Message -----
From: "Manuel Enache" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, November 07, 2005 3:48 PM
Subject: RE: [sqlite] sqlite 2.0 database
I've tried with sqlite3 and nothing:
<cmd>
C:\sqlite>sqlite3.exe database
SQLite version 3.2.7
Enter ".help" for instructions
sqlite> .databases
Error: file is encrypted or is not a database
sqlite>
</cmd>
--- Clay Dowling <[EMAIL PROTECTED]> wrote:
Try opening it with an sqlite3 client as well. If
neither will open the
file, it's either not an SQLite database, or it's
hopelessly corrupted and
you aren't getting into it.
Clay Dowling
Manuel Enache said:
> I'done like Shawn said and here is the result:
> <cmd>
> C:\sqlite>sqlite.exe database
> Unable to open database "database": file is
encrypted
> or is not a database
> <cmd>
>
> The file is not corupted because is used by a
> "program" and that program is working fine.
>
> That program is using tcl to access the data base:
>
> <code from tcl file>
> sqlite pcdb pcdatabase
> # Construct SQL string for requested search
> ...
> pcdb close
> </code>
>
> From this I drawn the conclusion that the DB is
not
> encrypted. Is this a correct conclusion?
>
> --- "Downey, Shawn" <[EMAIL PROTECTED]> wrote:
>
>> Download sqlite.exe (version 2.8.16 which has no
>> numeric extension) from
>> http://www.sqlite.org/download.html.
>>
>> From the command line attempt to open the
database:
>>
>> sqlite <database>
>>
>> where <database is the name of your sqlite 2.0
>> database file. If the
>> file does not open, it is probably a damaged
file.
>>
>> Shawn M. Downey
>> MPR Associates
>> 10 Maxwell Drive, Suite 204
>> Clifton Park, NY 12065
>> 518-371-3983 x113 (work)
>> 860-508-5015 (cell)
>>
>>
>> -----Original Message-----
>> From: Manuel Enache
[mailto:[EMAIL PROTECTED]
>> Sent: Monday, November 07, 2005 9:06 AM
>> To: sqlite-users@sqlite.org
>> Subject: [sqlite] sqlite 2.0 database
>>
>> I have a sqlite 2.0 DB and I need the data
within.
>>
>> I tried open it with almost all the tools I
finded.
>>
>> All say that: "file is encrypted or is not a
>> database"
>>
>> I'm 90% sure that the DB is not encrypted.
>>
>> It is possible that the may be to old for these
>> tools?
>> What tool should I use to open that DB and export
>> the
>> data?
>>
>> Thanks in advance!
>>
>>
>>
>> __________________________________
>> Yahoo! FareChase: Search multiple travel sites in
>> one click.
>> http://farechase.yahoo.com
>>
>
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in
one click.
> http://farechase.yahoo.com
>
--
Simple Content Management
http://www.ceamus.com
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
