[sqlite] windows 2012 server having problems loading sqllite dll

2014-01-08 Thread Jill Taylor
Hi I hope someone has ran across this and can give me some pointers. I have a new windows 2012 server that runs a process that loads the sqllite dll. On my older servers 2008 I have do not have any problem with this. On the older servers we just have the System.Data.SQLLite1.0.66.0 in

Re: [sqlite] windows 2012 server having problems loading sqllite dll

2014-01-08 Thread j . merrill
Your display of the GAC shows the 1.0.66.0 DLL having a different public key token than what is displayed in the error message. .Net is apparently still trying to load the 1.0.66.0 DLL that may be 32-bit, and not the known-64-bit 1.0.90.0 DLL. As a first shot, I'd suggest removing the 1.0.66.0

Re: [sqlite] windows 2012 server having problems loading sqllite dll

2014-01-08 Thread Jill Taylor
Hi I agree the message that it is sending is confusion. The original application was built with the 32 bit one and runs on 2008 servers and earlier servers. We were hoping that we could get it to use the 32 bit one and we did not have to recompile in the 64. Can you force this? Bye Jill

Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-08 Thread Sascha Sertel
The error message from my previous email is what we get from the callback added through SQLITE_CONFIG_LOG. The error code is 28, which is SQLITE_WARNING. There are no other errors or any other non-error output from the callback around this. Note that we are setting the temp directory using the

[sqlite] Recursive query?

2014-01-08 Thread Petite Abeille
Hello, Couldn’t help but notice a brand new branch in SQLite’s repository, the one labeled Start a new experimental branch for support of Oracle-style CONNECT BY syntax.”. http://www.sqlite.org/src/info/4365ddd62d Two reactions: (1) Recursive queries! Yes! Hurray! :D (2) CONNECT BY

Re: [sqlite] Recursive query?

2014-01-08 Thread Richard Hipp
That branch is a sponsored change. We are in communication with the sponsor asking if they will consider WITH RECURSIVE syntax. Their original request specified Oracle10g-compatible CONNECT-BY syntax. It depends on what the sponsor really wants. (We await their reply.) The code will only make

Re: [sqlite] Recursive query?

2014-01-08 Thread Petite Abeille
Aha… I see… well… if that mysterious sponsor is familiar with ‘connect by’ they should have no issue with a recursive ‘with’ clause syntax, which is what Oracle provides now. See Recursive Subquery Factoring” in Oracle’s very own documentation:

Re: [sqlite] Recursive query?

2014-01-08 Thread Richard Hipp
On Wed, Jan 8, 2014 at 2:28 PM, Petite Abeille petite.abei...@gmail.comwrote: Aha… I see… well… if that mysterious sponsor is familiar with ‘connect by’ they should have no issue with a recursive ‘with’ clause syntax, which is what Oracle provides now. The sponsor might have a big pile of

Re: [sqlite] Generating sqlite4.c

2014-01-08 Thread big stone
Will you write a small result of your early experiment ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fstat warning with SQLite 3.8.1 on Android

2014-01-08 Thread Richard Hipp
On Tue, Jan 7, 2014 at 3:55 PM, Sascha Sertel sascha.ser...@gmail.comwrote: Hello, I'm hoping someone has any ideas what to do about the error messages I'm getting from SQLite 3.8.1 when run on Android: Getting warning: cannot fstat db file -- please take note that there is a blank

Re: [sqlite] windows 2012 server having problems loading sqllite dll

2014-01-08 Thread Joe Mistachkin
Jill Taylor wrote: I hope someone has ran across this and can give me some pointers. Is System.Data.SQLite being used in an ASP.NET application? Typically, the setup packages should not be used for server deployments; instead, the System.Data.SQLite binaries should be deployed via XCOPY

[sqlite] Behavior change in group by in 3.8.2 when compared with 3.7.7

2014-01-08 Thread Navaneeth K N
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hello, I am seeing a change in the results returned for a query in SQLIte 3.8.2 version. The query used to return expected results with 3.7.7 and when I updated to 3.8.2, it changed the results. Here is a test case: CREATE TABLE test(name