Re: [sqlite] Seemingly random Access Violation errors

2012-10-04 Thread Joe Mistachkin
Matthew Dumbleton wrote: > > I have tried this change and I'm afraid it hasn't stopped the crashes. > I've further refined the locking semantics for the .NET Compact Framework build here: https://system.data.sqlite.org/index.html/info/ac5f4cc084 I think this should correct the problem,

Re: [sqlite] interesting deadlock.

2012-10-04 Thread Jonathan Engle
Ok, so here's a question (trying an experiment to see if this will work, but throwing it out here as well). What if the source db handle for the backup is opened to use private cache? Will this have any effect at all or is it the cache mode of db2 (using your example below)? On Sep 28, 2012,

Re: [sqlite] Sqlite and SQL Server 2005

2012-10-04 Thread Simon Slavin
On 4 Oct 2012, at 9:11pm, Jorge wrote: > I am new in Sqlite. I would like to know what is the best option to update > data in two directions from Sqlite to SQL Server 2005 There are lots of languages that can talk to both databases. PHP can do it and runs on many platforms. Are you expectin

[sqlite] SQLite version 3.7.14.1

2012-10-04 Thread D. Richard Hipp
SQLite version 3.7.14.1 is now available on the SQLite website http://www.sqlite.org/ Version 3.7.14.1 is a patch release with minimal difference from 3.7.14. The changes in version 3.7.14.1 include a one-line bug fix in the SQLite core (see www.sqlite.org/src/fdiff?v1=22783f4275f&v2=e74f

Re: [sqlite] Sqlite and SQL Server 2005

2012-10-04 Thread Bart Smissaert
What is your coding language? If VB then maybe via ODBC and ADO. RBS On Thu, Oct 4, 2012 at 9:11 PM, Jorge wrote: >> Hello, > I am new in Sqlite. I would like to know what is the best option to update > data in two directions from Sqlite to SQL Server 2005 > > Thx > >> > __

[sqlite] Sqlite and SQL Server 2005

2012-10-04 Thread Jorge
> Hello, I am new in Sqlite. I would like to know what is the best option to update data in two directions from Sqlite to SQL Server 2005 Thx > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit

Re: [sqlite] Bug report: null pointer dereference in SQLite 3.7.14 (SEGFAULT)

2012-10-04 Thread Bart Smissaert
Now that is a proper bug! Makes Excel crash OK here. RBS On 10/3/12, Klaus Keppler wrote: > Hi, > > after upgrading from SQLite 3.7.13 to 3.7.14 our application crashed > with a SEGFAULT located within SQLite. > I boiled down the SQL statement and the tables used, and was able to > reproduce th

Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-04 Thread David Richardson
Yes, that is the problem: How to do this with entity framework?  Entity framework does all the class making from the model (ORM). great tool. But I find it weird that nobody has stumble upon this problem. I cannot find a conclusive answer on this. you know: NO(, It is not possible. because[...]

Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-04 Thread Duquette, William H (318K)
On 10/4/12 8:26 AM, "David Richardson" mailto:daviric...@yahoo.com>> wrote: Yes, I've read about it. I try to implemented it but it did not seem to work. I even read somewhere that you can add this to the connectionstring but no luck with them. I tried all these solutions: http://stackoverflow

Re: [sqlite] Size

2012-10-04 Thread Clemens Ladisch
Alami Omar wrote: > it seems that in a sqlite format 3 file (that i have), the offset > 28 value is not valid(not equal to the file size) Please read the link you were given. This size is in pages. > what i am trying to do, is extract an SQLite Format 3 file from > the hex code of another file [

Re: [sqlite] Seemingly random Access Violation errors

2012-10-04 Thread Matthew Dumbleton
I have tried this change and I'm afraid it hasn't stopped the crashes. Just to confirm though, I copied the code changes to 'UnsafeNativeMethods.cs' into the 1.0.82.0 project by hand as I couldn't see anywhere to download the new source code as a whole. Was this correct or did I miss somethin

Re: [sqlite] Bug report: null pointer dereference in SQLite 3.7.14 (SEGFAULT)

2012-10-04 Thread Richard Hipp
Trouble ticket is here: http://www.sqlite.org/src/info/d02e1406a5 Tnx for the test script. On Wed, Oct 3, 2012 at 2:57 PM, Klaus Keppler wrote: > Hi, > > after upgrading from SQLite 3.7.13 to 3.7.14 our application crashed with > a SEGFAULT located within SQLite. > I boiled down the SQL statem

Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-04 Thread David Richardson
Yes, I've read about it. I try to implemented it but it did not seem to work. I even read somewhere that you can add this to the connectionstring but no luck with them. I tried all these solutions: http://stackoverflow.com/questions/2477872/problem-with-cascade-delete-using-entity-framework-and-

Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-04 Thread Duquette, William H (318K)
On 10/4/12 7:29 AM, "David Richardson" wrote: >I¹m having some sort of >bug with system.data.sqlite. I¹ve been trying for weeks now! I¹ve >installed (System.Data.SQLite 1.0.81.0) and >i¹m using sqlite in combination with Entity Framework 4. Mostly it does >what I >want. The only problem I¹m hav

[sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-04 Thread David Richardson
Hi all, I'm not sure if this mail was received by the community (on sunday the 31st of semptember 2012). I haven't heard anything yet. So I'm sending it again. Regards, David Richardson  - Forwarded Message - From: David Richardson To: "sqlite-users@sqlite.org" Sent: Sunday, Septemb

Re: [sqlite] Size

2012-10-04 Thread Alami Omar
Thank you for your answers Mr.Simon Davies and Mr.Simon Slavin, but it seems that in a sqlite format 3 file (that i have), the offset 28 value is not valid(not equal to the file size) and surely not equal to offset 92 (00 00 00 00), what i am trying to do, is extract an SQLite Format 3 file from t

Re: [sqlite] Size

2012-10-04 Thread Simon Slavin
On 4 Oct 2012, at 2:06pm, Alami Omar wrote: > Hello, does SQLite format files have any size(fie size of the sqlite file) > info on the header ? Thank you. You can find file content information here: http://www.sqlite.org/fileformat.html There's no specific location with the length in bytes, y

Re: [sqlite] Size

2012-10-04 Thread Simon Davies
On 4 October 2012 14:06, Alami Omar wrote: > Hello, does SQLite format files have any size(fie size of the sqlite file) > info on the header ? Thank you. http://www.sqlite.org/fileformat.html#filesize Regards, Simon ___ sqlite-users mailing list sqlite

Re: [sqlite] System.Data.SQLite for Visual Studio 2012

2012-10-04 Thread Steffen Mangold
Joe Mistachkin wrote: > > Yes. The code is currently on trunk. Please see: > > http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Thank you. :) Regards Steffen Mangold ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] System.Data.SQLite for Visual Studio 2012

2012-10-04 Thread Joe Mistachkin
Steffen Mangold wrote: > > is there a new ADO.NET setup version for Visual Studio 2012 planed? > Yes. The code is currently on trunk. Please see: http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki -- Joe Mistachkin ___ sqlite-

[sqlite] System.Data.SQLite for Visual Studio 2012

2012-10-04 Thread Steffen Mangold
Hi, is there a new ADO.NET setup version for Visual Studio 2012 planed? regards steffen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug report: null pointer dereference in SQLite 3.7.14 (SEGFAULT)

2012-10-04 Thread Klaus Keppler
Hi, after upgrading from SQLite 3.7.13 to 3.7.14 our application crashed with a SEGFAULT located within SQLite. I boiled down the SQL statement and the tables used, and was able to reproduce this also with the SQLite standalone binary available at http://www.sqlite.org/sqlite-shell-linux-x86-3

Re: [sqlite] Seemingly random Access Violation errors

2012-10-04 Thread Joe Mistachkin
Matthew Dumbleton wrote: > > Attached is a small project that should recreate the issues I'm having. > Could you try the following change and let us know if it works for you? http://system.data.sqlite.org/index.html/ci/b8212344a0 -- Joe Mistachkin _