Re: [sqlite] sqlite 2.0 database

[Anton Kuznetsov]

Yes. That script works with versions 2.8.16 and 3.2.7.

- Original Message - 
From: "Gerry Snyder" <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, November 08, 2005 2:03 AM
Subject: Re: [sqlite] sqlite 2.0 database



Anton Kuznetsov wrote:

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
##


Anton,

Are you sure this works? It looks to me as if it shouldn't.

The first part looks as if it will correctly create the schema in the 
new sqlite3 file newpcdatabase, but the second part then seems to be 
treating the new file as an sqlite 2 file.


Most of my recent comments to this list have been wrong (and I learned a 
lot from the replies), but I just don't see how version 2 and version 3 
files can be attached to the same TCL command [pcdb].


In the TCL/TK script I use for sqlite file manipulation (which does 
work) I needed a fair amount more code than is in your example (and more 
than that to go from V3 -> V2), so if your code really does the job I 
can simplify a lot.


TIA for any comments,

Gerry

--
--
Gerry Snyder
American Iris Society Director, Symposium Chair
in warm, winterless Los Angeles -- USDA zone 9b, Sunset 18-19

Re: [sqlite] sqlite 2.0 database

[R S]

Are you trying to open a file by the nomenclature "-journal" file?


On 11/7/05, Manuel Enache <[EMAIL PROTECTED]> wrote:
>
> 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
>

Re: [sqlite] Quoted identifiers

[by way of Darren Duncan]

You don´t undertand me, maybe my poor english.
I will try to show with examples in the sqlite command line.

create table test("Full Name" varchar(30), "Login" varchar(15), Age integer);
insert into test ("Full Name", "Login", Age) values ("Enrique Esquivel",
"the_kique", 24);
.headers on
select * from test;

SQLite returns:
Full Name|Login|Age
Enrique Esquivel|the_kique|24

But when write:
select "Full Name", "Login", Age from test;

returns:
"Full Name"|"Login"|Age
Enrique Esquivel|the_kique|24

Moreover when quote all fields:
select "Full Name", "Login", "Age" from test;

returns:
"Full Name"|"Login"|"Age"
Enrique Esquivel|the_kique|24

Also:
select [Full Name], [Login], [Age] from test;

SQLite returns wrong:
"Full Name"|"Login"|"Age"
Enrique Esquivel|the_kique|24

The quotes should be used for SQLite only for understand the identifiers, the
fields in result must be unquoted. Try to test with other dbms and anyone has
this behavior.

Re: [sqlite] sqlite 2.0 database

[Gerry Snyder]

Anton Kuznetsov wrote:

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
##


Anton,

Are you sure this works? It looks to me as if it shouldn't.

The first part looks as if it will correctly create the schema in the 
new sqlite3 file newpcdatabase, but the second part then seems to be 
treating the new file as an sqlite 2 file.


Most of my recent comments to this list have been wrong (and I learned a 
lot from the replies), but I just don't see how version 2 and version 3 
files can be attached to the same TCL command [pcdb].


In the TCL/TK script I use for sqlite file manipulation (which does 
work) I needed a fair amount more code than is in your example (and more 
than that to go from V3 -> V2), so if your code really does the job I 
can simplify a lot.


TIA for any comments,

Gerry

--
--
Gerry Snyder
American Iris Society Director, Symposium Chair
in warm, winterless Los Angeles -- USDA zone 9b, Sunset 18-19

Re: [sqlite] sqlite 2.0 database

[Manuel Enache]

Can anyone provide me sqlite 2.0? I've tried with CVS
and I discovered that I don't know how to use CVS to
revert to an older version and I'm not too good at
compiling sources.

Thanks in advance!

--- [EMAIL PROTECTED] wrote:

> Manuel Enache <[EMAIL PROTECTED]> wrote:
> > I'm 100% sure that the file i am trying to access
> is
> > the file that containes the database.
> > 
> > Any ideeas? I don't have any...
> 
> The SQLite database file format changed going from
> version 2.0
> to version 2.1 (a change which occurred in 2001). 
> To read a
> version 2.0 database file, you'll have to download
> the old
> 2.0 source code from CVS, compile it, and run it.
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
> 
> 





__ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

Re: [sqlite] sqlite 2.0 database

[drh]

Manuel Enache <[EMAIL PROTECTED]> wrote:
> I'm 100% sure that the file i am trying to access is
> the file that containes the database.
> 
> Any ideeas? I don't have any...

The SQLite database file format changed going from version 2.0
to version 2.1 (a change which occurred in 2001).  To read a
version 2.0 database file, you'll have to download the old
2.0 source code from CVS, compile it, and run it.
--
D. Richard Hipp <[EMAIL PROTECTED]>

RE: [sqlite] sqlite 2.0 database

[Manuel Enache]

I'm 100% sure that the file i am trying to access is
the file that containes the database.

Any ideeas? I don't have any...

--- "Downey, Shawn" <[EMAIL PROTECTED]> wrote:

> I would double check that the file I am trying to
> open is indeed the same file the Tcl app is
> accessing successfully.  
> 
> 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 10:05 AM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite 2.0 database
> 
> TCL is not my thing... :((
> 
> --- Guillaume MAISON <[EMAIL PROTECTED]> wrote:
> 
> > Manuel Enache a écrit :
> > > I've tried with sqlite3 and nothing:
> > > 
> > > 
> > > 
> > > 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>
> > > 
> > 
> > You said that a tcl application could access the
> DB
> > ?
> > 
> > then, instead of spending too much time seeking
> for
> > a tool that could 
> > open the database, "re invent the wheel" and build
> > yourself, with tcl, a 
> > tool that would export the DB in a format that you
> > could then import.
> > 
> > IMHO, it's the easiest and fastest way...
> > 
> > HTH,
> > 
> > Best regards,
> > 
> > -- 
> > 
> > Guillaume MAISON - [EMAIL PROTECTED]
> > 83, Cours Victor Hugo
> > 47000 AGEN
> > Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
> > e-mail : [EMAIL PROTECTED] - Web :
> > http://nauteus.com
> > 
> > 
> 
> 
> 
>   
> __ 
> Yahoo! FareChase: Search multiple travel sites in
> one click.
> http://farechase.yahoo.com
> 





__ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

Re: [sqlite] Request for comment: Proposed SQLite API changes

[Eduardo]

Sorry for being dense, but I don't understand what you are saying. 
What do you mean by "prepare a transaction"? Transactions are not 
prepared, statements are. sqlite3_prepare is not part of a 
transaction, does not initiate a transaction, and is not affected by 
any ongoing transaction in any way, shape or form. The first call to 
sqlite3_step on a prepared statement initiates the transaction 
(assuming there is no explicitly started transaction in place on the 
database handle). SQLITE_SCHEMA error arises when another process or 
thread changes the schema between sqlite3_prepare (or sqlite3_reset) 
and sqlite3_step.


If your usage pattern is something like

begin transaction
prepare
step
step
...
finalize
commit

then you don't need to worry about SQLITE_SCHEMA under the existing 
engine. The whole issue becomes moot. Of course you are losing one 
of the benefits of prepared statements - time saving due to 
elimination of unnecessary parsing and execution planning.


Igor Tandetnik


Well, i use sqlite without threads, the os where it's used hasn't 
thread support and there is one app with sqlite only, so only one 
process and only one transaction is on the way. That's why i say my 
point of view maybe a bit obfuscated. I only tried to look for other 
ways to avoid SQLITE_SCHEMA errors, re-prepare other threads is a bit 
expensive in cpu cycles, at least for me.


Thanks for your time ;)


-
La diferencia entre la teoria y la practica es que en teoria no hay, 
pero en la practica si 

RE: [sqlite] sqlite 2.0 database

[Downey, Shawn]

I would double check that the file I am trying to open is indeed the same file 
the Tcl app is accessing successfully.  

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 10:05 AM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite 2.0 database

TCL is not my thing... :((

--- Guillaume MAISON <[EMAIL PROTECTED]> wrote:

> Manuel Enache a écrit :
> > I've tried with sqlite3 and nothing:
> > 
> > 
> > 
> > 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>
> > 
> 
> You said that a tcl application could access the DB
> ?
> 
> then, instead of spending too much time seeking for
> a tool that could 
> open the database, "re invent the wheel" and build
> yourself, with tcl, a 
> tool that would export the DB in a format that you
> could then import.
> 
> IMHO, it's the easiest and fastest way...
> 
> HTH,
> 
> Best regards,
> 
> -- 
> 
> Guillaume MAISON - [EMAIL PROTECTED]
> 83, Cours Victor Hugo
> 47000 AGEN
> Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
> e-mail : [EMAIL PROTECTED] - Web :
> http://nauteus.com
> 
> 




__ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Re: [sqlite] sqlite 2.0 database

[Rob Lohman]

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: 
Sent: Monday, November 07, 2005 3:48 PM
Subject: RE: [sqlite] sqlite 2.0 database


I've tried with sqlite3 and nothing:



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>



--- 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:
> 
> C:\sqlite>sqlite.exe database
> Unable to open database "database": file is
encrypted
> or is not a database
> 
>
> 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:
>
> 
> sqlite pcdb pcdatabase
> # Construct SQL string for requested search
> ...
> pcdb close
> 
>
> 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 
>>
>> where > 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

Re: [sqlite] SQLite-Oracle replication

[Robert Simpson]

- Original Message - 
From: "ahmed abdel-haffiez" <[EMAIL PROTECTED]>

To: 
Sent: Monday, November 07, 2005 7:58 AM
Subject: [sqlite] SQLite-Oracle replication



i need to know whether the SQLite supports replication with oracle or
not.  what is the type of replication supported? is it merge?
snapshot...?...? if so, what are the steps i have to follow to do so?


SQLite is a small footprint, multi-platform database engine.  There is no 
interoperability with other database engines built-in.  Such a task is 
beyond the scope of the project.


If you want Oracle replication, you'll have to write the code yourself or 
find someone on the net that has already done it.


Robert

Re[2]: [sqlite] Unsupported SQL feature

[Alexander Kozlovsky]

> > select * from t1 where a >= ALL (select b from t2)
>
> What are these constructs suppose to do?

"""
  QUANTIFIED SUBQUERIES

  A quantified subquery allows several types of tests and
  can use the full set of comparison operators. It has
  the following general format:

  value-1  {=|>|<|>=|<=|<>}  {ALL|ANY|SOME}  (query-1)

  The comparison operator specifies how to compare value-1
  to the single query column value from each subquery
  result row. The ANY, ALL, SOME specifiers give the type
  of match expected. ANY and SOME must match at least one row
  in the subquery. ALL must match all rows in the subquery,
  or the subquery must be empty (produce no rows).
"""

The next two WHERE condition are equivalent:

  total_price > ALL (SELECT total_price FROM items
 WHERE order_num = 1023)

  total_price > (SELECT MAX(total_price) FROM items
 WHERE order_num = 1023)

The next two WHERE condition are equivalent also:

  total_price > ANY (SELECT total_price FROM items
 WHERE order_num = 1023)

  total_price > (SELECT MIN(total_price) FROM items
 WHERE order_num = 1023)

ANY and SOME are synonyms.


The next example show real use-case.

Table: Assemblies
++--+--+
|  AssemblyName  |  PartNumber  |  PartWeight  |
++--+--+
|  Assembly1 |  01  |  100 |
|  Assembly1 |  02  |  150 |
|  Assembly2 |  01  |  120 |
|  ...   |  ... |  ... |

Query: Assemblies with max total weight:

Because SQL doesn't allow nested aggregated functions
MAX(SUM(...)), it is easy for some people
write this query as:

select AssemblyName from Assemblies
group by AssemblyName
having SUM(PartWeight) >= ALL (
 select SUM(PartWeight)
 from T1
 group by AssemblyName
)

Of course, this query may be reformulated as:

select TOP 1 AssemblyName from Assemblies
group by AssemblyName
order by SUM(PartWeight) DESC


>   x  all (select y from t where ...)
> 
> is equivalent to
> 
>   not exists (select y from t where not (x  y) and ...)
> 
> Any and some are synonyms.
> 
>   x  any (select y from t where ...)
> 
> is equivalent to
> 
>   exists (select y from t where x  y and ...)

Nice summary


Best regards,
 Alexandermailto:[EMAIL PROTECTED]

Re: [sqlite] sqlite 2.0 database

[Anton Kuznetsov]

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: 
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:

C:\sqlite>sqlite.exe database
Unable to open database "database": file is encrypted
or is not a database


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:


sqlite pcdb pcdatabase
# Construct SQL string for requested search
...
pcdb close


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 

where 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

Re: [sqlite] sqlite 2.0 database

[Manuel Enache]

TCL is not my thing... :((

--- Guillaume MAISON <[EMAIL PROTECTED]> wrote:

> Manuel Enache a écrit :
> > I've tried with sqlite3 and nothing:
> > 
> > 
> > 
> > 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>
> > 
> 
> You said that a tcl application could access the DB
> ?
> 
> then, instead of spending too much time seeking for
> a tool that could 
> open the database, "re invent the wheel" and build
> yourself, with tcl, a 
> tool that would export the DB in a format that you
> could then import.
> 
> IMHO, it's the easiest and fastest way...
> 
> HTH,
> 
> Best regards,
> 
> -- 
> 
> Guillaume MAISON - [EMAIL PROTECTED]
> 83, Cours Victor Hugo
> 47000 AGEN
> Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
> e-mail : [EMAIL PROTECTED] - Web :
> http://nauteus.com
> 
> 




__ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

[sqlite] SQLite-Oracle replication

[ahmed abdel-haffiez]

hi;

i need to know whether the SQLite supports replication with oracle or not.
what is the type of replication supported? is it merge? snapshot...?...?
if so, what are the steps i have to follow to do so?

thx in advance

---
best regards;

Ahmed Abd-ElHaffiez
Mobile Solution Developer
ww.eSpace.com.eg 

Re: [sqlite] sqlite 2.0 database

[Guillaume MAISON]

Manuel Enache a écrit :

I've tried with sqlite3 and nothing:



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>



You said that a tcl application could access the DB ?

then, instead of spending too much time seeking for a tool that could 
open the database, "re invent the wheel" and build yourself, with tcl, a 
tool that would export the DB in a format that you could then import.


IMHO, it's the easiest and fastest way...

HTH,

Best regards,

--

Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com

RE: [sqlite] sqlite 2.0 database

[Manuel Enache]

I've tried with sqlite3 and nothing:



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>



--- 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:
> > 
> > C:\sqlite>sqlite.exe database
> > Unable to open database "database": file is
> encrypted
> > or is not a database
> > 
> >
> > 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:
> >
> > 
> > sqlite pcdb pcdatabase
> > # Construct SQL string for requested search
> > ...
> > pcdb close
> > 
> >
> > 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 
> >>
> >> where  >> 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

RE: [sqlite] sqlite 2.0 database

[Clay Dowling]

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:
> 
> C:\sqlite>sqlite.exe database
> Unable to open database "database": file is encrypted
> or is not a database
> 
>
> 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:
>
> 
> sqlite pcdb pcdatabase
> # Construct SQL string for requested search
> ...
> pcdb close
> 
>
> 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 
>>
>> where > 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

RE: [sqlite] sqlite 2.0 database

[Manuel Enache]

I'done like Shawn said and here is the result:

C:\sqlite>sqlite.exe database
Unable to open database "database": file is encrypted
or is not a database


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:


sqlite pcdb pcdatabase
# Construct SQL string for requested search
...
pcdb close


>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 
> 
> where  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

RE: [sqlite] sqlite 2.0 database

[Downey, Shawn]

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 

where 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

[sqlite] sqlite 2.0 database

[Manuel Enache]

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

Re: [sqlite] Re: converting a mysql database

[Edwin Knoppert]

If the mysql db is reachable through dsn (ado-providerstring) you can use my 
pbsdbms tool to import tables.


http://www.hellobasic.com




- Original Message - 
From: "Arjen Markus" <[EMAIL PROTECTED]>

To: 
Sent: Monday, November 07, 2005 8:43 AM
Subject: Re: [sqlite] Re: converting a mysql database



Dave Dyer wrote:


I looked into this, and the actual problem is windows returning
a "access denied" error code when trying to recreate the journal
file immediately after deleting it.   I can't find any documentation
that says create might fail for this reason, but filemon (from
systeminternals.com) says the status is "delete pending" in this
situation.  So I think this is a genuine windows glitch, which
might be related to my having a fast, dual-core processor.

In any case, it seems to be possible to paper over the problem
by waiting a few milliseconds and retrying the create.


I have had weird problems in the past on a Windows platform
with the deletion and re-creation of files. I have never
been able to figure out what happened.

I am not familiar with inner workings of SQLite but I can imagine
that this will not be a problem anymore when you use a
transaction instead of individual inserts.

Regards,

Arjen