Hello, Manuel.
Install TCLSQLite3(http://sqlite.org/tclsqlite-3_2_7.zip) and try the
following script.
It will convert your database into the SQLite3 database.
##################################################
package require sqlite
package require sqlite3
sqlite pcdb pcdatabase
sqlite3 pcdb3 newpcdatabase
# creating tables in new DB:
pcdb eval {select sql from sqlite_master} {
pcdb3 eval $sql
}
pcdb3 close
# filling tables of the new DB:
pcdb eval {attach 'newpcdatabase' as newpcdb}
pcdb eval {select name from sqlite_master where type='table'} {
pcdb eval "insert into newpcdb.'$name' select * from '$name' "
}
pcdb eval {detach newpcdb}
pcdb close
exit
##################################################
But, of course, instead of SQLite3 you may use the old 2.8.16
(http://sqlite.org/tclsqlite-2_8_16.zip).
Bye.
Anton.
----- Original Message -----
From: "Manuel Enache" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, November 07, 2005 5:35 PM
Subject: RE: [sqlite] sqlite 2.0 database
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
