[sqlite] SQLite 3 and MS SQL CE Compatibility Issues?

[Richard.Murphy]

My client has an application which uses MS-SQL CE.  My app uses SQLite
3.
 
Does anyone know of any compatibility issues?
 
Thanks,
Richard

RE: [sqlite] Error: file is encrypted or is not a database

[Richard.Murphy]

Thanks, but this application resides on a PDA and my customer is
reporting this issue on several PDA's. No search/replace operations are
being performed at a file level on these devices.

Richard

-Original Message-
From: Will Leshner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 12, 2006 1:26 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Error: file is encrypted or is not a database

On 9/12/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:

> What in the world could have caused this??

Is it possible that you did some kind of global search and replace on
files on your computer and this database file accidently got snagged?


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Error: file is encrypted or is not a database

[Richard.Murphy]

SQLite Version: 2.8.17 (not 3)

I have a database that when I try to open it, either with the 'C'
libraries or with the sqlite.exe command-line utility, gives me the
error "file is encrypted or is not a database".

I opened the data file in a hex editor and noticed that the 48 byte
header string has been changed. The header string, which is supposed to
be "** This file contains an SQLite 2.1 database **" is instead, "**
This file contains an sqlite 2.1 database **".

The difference between the good and bad header is that the "SQL" in
"SQLite" is all lower case. If I change the lower case "sql" to "SQL",
the file opens and all data is intact!  Looking at the source code in
btree.c, line 794, the error returned is SQLITE_NOTADB when the
comparison fails, which is exactly the error that I am seeing reported.

What in the world could have caused this??

Thanks for any insight.

Richard