Re: [sqlite] memory fault in sqlite3_open_v2()

defined _WIN32_WINNT as 0x500, but not sure is > it correct, and will my application works if it will be launched under > Windows 9X. > This is the correct fix. Also, most modern Windows projects already have the _WIN32_WINNT define set to something (e.g. 0x400, 0

Re: [sqlite] Incompatible versions of SQLite on same system

d only reside in the same directory as the application itself); however, this can be difficult, depending on how the application was written. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Generated SQL from Skip and Take (EntityFramework)

Steffen Mangold wrote: > > "The Skip(n) method is not optimally transformed into SQL. Consider the following > LINQ expression: > If I'm understanding your issue correctly, it should be fixed as of 2011-07-09: https://system.data.sqlite.org/index.html/info/76e929f694

Re: [sqlite] Hi All, How to use System.data.sqlite on both 32-bit and 64-bit system.

> > is there a dll can be used on both system? > Not really. Different native code is required for 32-bit and 64-bit processes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Load a .NET DLL with additional functionsusingload_extension

H K wrote: > > Sorry but the file has a content table but no contents. > Am I doing something wrong with the chm? > Thx > You may need to right-click the file in Windows Explorer, go to "Properties", and then click on "Unblock" in order to make i

Re: [sqlite] SQLite with Vis. Studio C# Entity Framework 4.1

> > I think I want to download and get started. > Great. > > My direct e-mail is j...@xexam.net > CC'd on this message. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FW: SQLite with Vis. Studio C# Entity Framework 4.1

contains the same managed code; however, the contained SQLite core native code has been compiled for x64. https://nuget.org/packages/System.Data.SQLite.MSIL Finally, the last one (above) contains ONLY the managed code and must be used in conjunction with a "SQLite.Interop.dll" for the

Re: [sqlite] Load a .NET DLL with additional functions usingload_extension

H K wrote: > > Is it possible to load these functions with the load_extension function? > Please take a look at the SQLiteFunction help topic in the System.Data.SQLite CHM file, here: http://system.data.sqlite.org/index.html/artifact?filename=Doc/SQLite.NET.ch m=tip -- Joe M

Re: [sqlite] import CSV in ADO.NET

ou could execute the sqlite3.exe file as an external process, passing it the necessary arguments. For more information on the shell, please see: http://www.sqlite.org/sqlite.html -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Managed only / Mono and Linux support

Yves Goergen wrote: > > So, where could I have found that information if not here? > Good point, I'll add that command line to the "Build Procedures" page on the web site. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-us

Re: [sqlite] ADO provider for net 2.0/3.5

wrong place. Is > it possible that you could forward me the files? > The source code is here: https://system.data.sqlite.org/index.html/finfo?name=tools/install/Installer .cs It is also included in the released source code archive; however, the b

Re: [sqlite] Managed only / Mono and Linux support

or 2010 if you want .NET 4.0. 3. Change the current directory to the root of the System.Data.SQLite source code tree. 4. Execute the following command, where [year] is either 2008 or 2010: MSBuild.exe System.Data.SQLite\System.Data.SQLite.[year].csproj /t:Rebuild /p:Configuration=R

Re: [sqlite] ADO provider for net 2.0/3.5.

Studio designer components) as part of build 78 (i.e. the next release). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.77.0 released

(sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Followup: Added Missing error message to past post.

taining the pre-compiled binaries you need. In your case, it sounds like you will want to download the x86 mixed-mode assembly compiled statically against the .NET Framework 3.5, available here: https://system.data.sqlite.org/sqlite-netFx35-static-binary-bundle-W

Re: [sqlite] newer SQLite

's near the bottom of the download page): https://system.data.sqlite.org/sqlite-netFx35-binary-PocketPC-2008-1.0.76.0. zip -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ChangePassword method problem

Reading your code quickly, it seems the problem may be related to the use of single-quotes (') around the passwords in the connection string. Please remove all the single-quotes and try again. -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] Using SQLite on Windows 64bit

omer does not. > > How do I get the interop? > With the "bundle" packages, you do not need it because the native SQLite code is compiled into the System.Data.SQLite.dll assembly itself. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Using SQLite on Windows 64bit

, which contains both the native and managed code required for using SQLite (i.e. it is more suitable for GAC'ing without having to alter the system PATH, etc). -- Joe Mistachkin <j...@mistachkin.com> ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] ChangePassword method problem

Farhan Husain wrote: > > Aah, ok. So, for all the methods that act on the database I should explicitly add > conn.Close() within the using conn scope? > Well, I'm not familiar with your specific project; however, that does not sound like a bad idea. -- Jo

Re: [sqlite] ChangePassword method problem

One thing that could be a potential issue here is that all connections must be closed prior to changing the password on the database [except the connection used for the ChangePassword method call itself]. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] ChangePassword method problem

nreadable using the updated or previous password. > I've added some more unit tests to the test suite to verify that this feature works as documented and I'm not seeing any issues. Could you post some simplified C# code that demonstrates the behavior you are seeing?

Re: [sqlite] ChangePassword method problem

ll the SetPassword method on that connection object (or supply the password as plain-text in the connection string)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite won't work untill Iinstall+uninstallit.

will be present in the: \bin\\\Static directory, where year is 2008 or 2010, platform is Win32 or x64, and config is Release or Debug. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

thing that the installation does, which the uninstall > doesn't undo, that you have to do in order to get System.Data.SQLite > working. The question is what, and how can you do it without having to > run the installation? > The setup attempts to undo everything that it does, including t

Re: [sqlite] System.Data.SQLite Exception with wrong password

error code returned from the native core SQLite library. In the case you mention, the exception is technically correct even though it may seem counterintuitive at first glance. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] Sqlite WPF application (designer view) toolbox greyed out

F project in C# or VB.NET code. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] issue loading SQLite.Interop.dll in different folder

llow the guidelines outlined in the above linked MSDN documentation. However, using the bundled version may be a lot easier in your case, especially since you already have separate directories for 32-bit and 64-bit. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] Problems building/running SQLite test.exe withICU enabled

ssage you are seeing. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.76.0 released

(sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.75.0 released

(sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

Your list does not seem to include the ICU DLLs that I mentioned, including: icuuc48.dll icuin48.dll The necessary ICU files can be obtained from the official web site: http://site.icu-project.org/ -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

.cs:line 131 > Please make sure the necessary ICU DLLs are located in the same directory as the SQLite.Interop.dll OR somewhere along your PATH and the problem should go away. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 thecurrentversion?

Wamiduku wrote: > > Are there any plans to also provide the stable version as a NuGet package? > Yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 the currentversion?

technically 1.0.75.0 beta. The NuGet package is not necessarily going to be the 'preferred' way of distributing the bits in the future; however, it will be one way to get them. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

wise, you'll simply get a BadImageFormatException when the managed process (which will actually start as a 64-bit process) tries to load a 32-bit SQLite.Interop.dll. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling managed-only System.Data.SQLite version 1.0.74.0with MonoDevelop

rivial complexity. For now, MSBuild and Visual Studio are the only fully supported build environments. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error while using provider to import into SQL Server

The issue you are seeing is detailed here: http://www.mail-archive.com/sqlite-users@sqlite.org/msg62336.html It has already been fixed in the source tree and the fix will be in the next release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] TransactionScope ON CONFLICT

ctionScope transaction = new TransactionScope()) { context.Connection.Open(); // try adding this line. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TransactionScope ON CONFLICT

ed. The test case verifies that all 10 rows that should be added are in fact added. It also verifies that the appropriate exception is raised for the PRIMARY KEY constraint violation. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] TransactionScope ON CONFLICT

ng any error will be added to the database. Any rows that fail constraints will not be added. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] TransactionScope ON CONFLICT (oops, missed a step)...

\Release\bin 14. Copy the "SQLite.Interop.dll", "System.Data.SQLite.dll", and "System.Data.SQLite.Linq.dll" files into your application directory. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] TransactionScope ON CONFLICT

ll the binaries should be in the following directory: C:\dev\sqlite\dotnet\bin\2010\Release\bin 12. Copy the "SQLite.Interop.dll", "System.Data.SQLite.dll", and "System.Data.SQLite.Linq.dll" files into your application directory. -- Joe Mistachkin

Re: [sqlite] TransactionScope ON CONFLICT

in Fossil. If you need information on checking out or building the System.Data.SQLite source code, please let me know and I will send complete step-by-step instructions. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite execute query without using of indexes

, reader[0]); } } finally { reader.Close(); } Please note that even the above code will show some overhead associated with using SQLite from managed code; however, it will be less than the original code. -- Joe Mistachkin ___ sq

Re: [sqlite] System.Data.SQLite Release

> > Just wondering when the next release of System.Data.SQLite will be > available. > My current plan is to produce a release before the 15th of September. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] System.Data.SQLite.xml -- documentation for the wrongassembly

t;testlinq" assembly while the > actual documentation for "System.Data.SQLite" is missing. > This issue was recently fixed (Aug 9th) and will be included in the 1.0.75.0 packages when they are released. For details of the fix, see check-in: http://system.data.sqlite.org/inde

Re: [sqlite] Difference between Setups and Precompiled binaries forwindows

fficult to say as it depends on the what your use cases are. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

ell.com/show_bug.cgi?id=636915 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

FoundException: SQLite.Interop.DLL. > I seem to recall that the LD_LIBRARY_PATH may need to be modified to actually look in the bin folder for the application? I could be wrong here because I am not an expert on Mono. -- Joe Mistachkin ___ s

Re: [sqlite] System.Data.Sqlite problem

ame application on 32-bit Windows, it will run as a 32-bit process. A 64-bit process cannot load a 32-bit DLL. Therefore, the "test.exe" program starts as a 64-bit process and then attempts to load the 32-bit "SQLite.Interop.dll", which raises the BadImageFormatException. -

Re: [sqlite] Cannot add interop assembly

> Isn't it odd that I cannot just add it as a ref? > No, it's not odd, it's a pure native DLL. Adding a reference requires the DLL to be a managed assembly. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cannot add interop assembly

"System.Data.SQLite" assembly instead. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handle leak using IIS on windows 7?

. This existing instance of the DbLogger class no longer has a valid connection because it was previously closed (and set to null). 6. Newly created commands will not have a valid connection. 7. Attempting to execute a command without a valid connection will result in the exception you are seeing. -- Joe

Re: [sqlite] Sqlite .net problem error175 in Visual studio 2010

ngs; however, it might be best to temporarily use the legacy version of the System.Data.SQLite assembly if you require the VS designer components (if the VS2010 SP1 issue can be figured out). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite Reserved Words Bug

he project file "SQLite.Interop.2010.vcxproj" is incorrect: $(IntDir)System.Data.SQLite.%(Filename).resources It should read: System.Data.SQLite.%(Filename).resources This issue has been fixed in: http://system.data.sqlite.org/index.html/ci/55f56ce508 Th

Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

I do not see anything obviously wrong with using the same connection to construct two or more LINQ data contexts; however, my knowledge of LINQ and its use of threads is somewhat limited. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users

Re: [sqlite] System.Data.SQLite c#/Linq concurrent reads

ds or just the underlying database connection? The SQLiteDataReader class is not thread-safe and should not be shared between threads. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite version 1.0.74.0 released

(sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

<    2   3   4   5   6   7