Re: [sqlite] System.Data.SQLite and UNC Paths

2013-12-17 Thread Joe Mistachkin
ed to fix other issues), opening a database on a UNC path requires that the initial backslashes in the file name be doubled, e.g.: mypc\db\Mydb.db -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org ht

[sqlite] System.Data.SQLite version 1.0.90.0 released

2013-12-23 Thread Joe Mistachkin
mailing list (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] Windows Embedded Handheld 6.5

2013-12-30 Thread Joe Mistachkin
bably be easier just to use the System.Data.SQLite binaries for "PocketPC", seen here under "Precompiled Binaries for Windows CE (.NET Compact Framework)": https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki -- Joe Mistachkin _

Re: [sqlite] Problem with SQLiteCommand.Parameters and CurrentCulture

2014-01-03 Thread Joe Mistachkin
Marcin Szotka wrote: > > In my opinion command parameters should use InvariantCulture when > converting types to string. > Support for doing this (via new connection flags) has now been implemented on trunk, here: https://system.data.sqlite.org/index.html/info/f2f08c

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

2014-01-08 Thread Joe Mistachkin
ram with an incorrect > format. > This causes of this error message are covered by the FAQ: https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-01-10 Thread Joe Mistachkin
ion(IsolationLevel > isolationLevel) >at System.Data.SQLite.SQLiteConnection.1/8/2014 3:55 PM > That particular exception being thrown by the BeginDbTransaction method normally means that the underlying connection is no long

Re: [sqlite] [System.Data.SQLite] Load spatialite-extension throughSystem.Data.SQLite

2014-01-14 Thread Joe Mistachkin
s not appear with the previous version of Spatialite. These statements taken together would seem to indicate that the bug is in Spatialite, not System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Fw: System.Data.SQLite.dll

2014-01-16 Thread Joe Mistachkin
ficult to determine without knowing exactly where the source code used to build your DLL comes from. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Error VB 2012 .net Build Error 4.5.1/4.0

2014-01-16 Thread Joe Mistachkin
mmbsuc...@charter.net wrote: > > Any ideas how to get this to work? > Download the version for Visual Studio 2012 and the .NET Framework 4.5 instead. In this case, the file name would be: https://system.data.sqlite.org/downloads/1.0.90.0/sqlite-netFx45-binary-x64- 2012-1.0.90.0.zi

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Joe Mistachkin
er 2012 by > configuring the AppPool to allow 32 bit execution. I don't understand that > either. .dll is located in /Bin folder. > There are x64 builds of System.Data.SQLite that should work in a native 64-bit process on Windows Server. -- Joe Mistachkin __

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-20 Thread Joe Mistachkin
; work with VS. > Having it work with Visual Studio during development and on Windows Server after it has been deployed are two entirely different scenarios. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

2014-01-21 Thread Joe Mistachkin
duce nice results. Other than that, I'm not sure which profiler I would recommend for managed code. -- 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 - System.MissingMethodException was unhandled

2014-01-23 Thread Joe Mistachkin
ure the public key token in use matches the one expected by the application (see above). -- 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 - System.MissingMethodException was unhandled

2014-01-23 Thread Joe Mistachkin
y packages of System.Data.SQLite released recently. As a workaround, you should be able to it build locally using commands similar to: CD /D C:\path\to\sqlite\dotnet\Setup SET NETFX20ONLY=1 CALL build_ce_200x.bat -- Joe Mistachkin _

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-01-30 Thread Joe Mistachkin
y supported workaround for this limitation of Visual Studio is to use the "PreLoadSQLite_BaseDirectory" environment variable (or configuration file setting). Of course, I'm always open to alternative suggestions on how to work around issues like these in a portable and robust way. -- J

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-02-01 Thread Joe Mistachkin
g the code base of the assembly (via automatic detection): https://system.data.sqlite.org/index.html/ci/5ef906e34a Can you please try these changes in your environment and let us know if they work for you? -- Joe Mistachkin ___ sqlite-users mailing li

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

2014-02-03 Thread Joe Mistachkin
y have changed. There has been some fairly major feature work in the last couple releases. -- 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 Preloading and ASP.Net debugging

2014-02-04 Thread Joe Mistachkin
Eric Schultz wrote: > > The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! > Any plan for when the final will be out? > The release is currently scheduled for Monday, February 10th (give or take a day or so). -- Jo

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.91.0 have begun...

2014-02-04 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this coming Friday, February 7th. Thanks. -- Joe Mistachkin ___ sqlite-users ma

Re: [sqlite] Delphi->COM->.NET->System.Data.SQLite->System.Interop.dll not found

2014-02-06 Thread Joe Mistachkin
ding feature that strongly favor the location of the System.Data.SQLite assembly itself. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Errors Compiling Extension percentile.c

2014-02-06 Thread Joe Mistachkin
exe with Visual Studio, I get the following > errors: > I'm not exactly sure what is causing your compilation errors; however, the recent releases of System.Data.SQLite (specifically the SQLite.Interop.dll interop assembly) already include the percentile extension (as well as a couple other

Re: [sqlite] Errors Compiling Extension percentile.c

2014-02-07 Thread Joe Mistachkin
.EnableExtensions(true); connection.LoadExtension("SQLite.Interop.dll", "sqlite3_percentile_init"); -- 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.91.0 released

2014-02-12 Thread Joe Mistachkin
on the SQLite mailing list (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] C# - SQLite - and other things

2014-02-13 Thread Joe Mistachkin
n the Visual Studio IDE): https://nuget.org/api/v2/package/System.Data.SQLite/1.0.91.0 -- 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 documentation

2014-02-13 Thread Joe Mistachkin
trunk/www/faq.wiki And the download page: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki -- 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 documentation

2014-02-13 Thread Joe Mistachkin
uot; tab, click the "Unblock" button, and then click the "Apply" button. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EF6 + System.Data.Sqlite SaveChanges() not working?

2014-02-18 Thread Joe Mistachkin
. > This might be a problem with the configuration file. There was an issue with the NuGet configuration file transforms that is now fixed in package version 1.0.91.1. Could you try the new version and see if that clears the issue you are seeing?

Re: [sqlite] Should System.Data.SQLite.EF6.SQLiteProviderServices be public?

2014-02-23 Thread Joe Mistachkin
en public before (i.e. in the plain System.Data.SQLite.Linq assembly). -- 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 fails to load

2014-02-25 Thread Joe Mistachkin
ata.SQLite assembly (or other assemblies); however, maybe try using the "LoadFrom context" when loading from the network share as well. -- 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 fails to load

2014-02-28 Thread Joe Mistachkin
s > I know exactly what they're going to do, that's why I'm asking. > Using "gacutil" is fine. That's more-or-less what the setup packages do. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issues after upgrade to 3.8.2

2014-03-05 Thread Joe Mistachkin
] as s where s.[SongId] = new.[SongId])," > Thanks for the detailed report. This issue has been fixed on trunk: https://www.sqlite.org/src/info/5bcd0b1ca5 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-10 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this coming Friday, March 14th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Joe Mistachkin
TFX_CORE SQLite3.SetDirectory(/*temp directory type*/2, Windows.Storage.ApplicationData.Current.TemporaryFolder.Path); #endif Can you please try removing the surrounding "#if" from this code and try it again? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-11 Thread Joe Mistachkin
he temporary directory value should work fine. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What does SQLITE_OS_WINRT mean

2014-03-12 Thread Joe Mistachkin
> > What does the macro SQLITE_OS_WINRT mean? > When it is set to non-zero, it means that the SQLite core library is being built specifically for the Windows Runtime (present on Windows 8.x): https://en.wikipedia.org/wiki/Windows_Runtime -- Joe M

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-12 Thread Joe Mistachkin
Stefano Ravagni wrote: > > i encounter problem with datareader hasrows properties... > Do you have some example code that demonstrates the issue? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-12 Thread Joe Mistachkin
that demonstrates how this works, here: https://system.data.sqlite.org/index.html/ci/7fb5c1cd3e?sbs=0 Based on your previous statements, it sounds like you may have expected the return value of the HasRows property to remain constant (i.e. even after reading some or all of

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-13 Thread Joe Mistachkin
use case, when combined with the HasRows property, e.g.: If Dati.HasRows = True Or Dati.StepCount > 0 Then ... code here ... End If This new property will be present in the 1.0.92.0 release, due out next week. -- Joe Mistachkin

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-13 Thread Joe Mistachkin
hasRows = true; // process this row... } else { // no more rows. break; } } while (true); if (hasRows) { // more code her

Re: [sqlite] SQLite exception

2014-03-14 Thread Joe Mistachkin
Rishi Ravindran wrote: > > I am getting an exception when I try to debug > the sqlite-netFx-source-1.0.91.0 source code in VS 2010 on the following > line below... > https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q20 --

Re: [sqlite] System.Data.SQLite Deployment Mystery

2014-03-16 Thread Joe Mistachkin
tp://dependencywalker.com/ ) against the native interop assembly ("SQLite.Interop.dll") on the target machine should reveal if that is the case. If that does turn out to be the case, it can normally be solved by installing one of the packages from: https://support.microsof

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-16 Thread Joe Mistachkin
ty to include the StickyHasRows value, e.g.: "Data Source=:memory:;Flags=StickyHasRows;" Currently, these changes can be seen on the stickyHasRows branch, here: https://system.data.sqlite.org/index.html/timeline?r=stickyHasRows Would this sat

Re: [sqlite] [sqlite-dev] Final preparations for the releaseof System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Joe Mistachkin
Stefano Ravagni wrote: > > If yes, i like this way! When could i try the compiled version for make somes tests? > Here is a temporary set of debug binaries for the .NET Framework 4.0 (or higher): https://system.data.sqlite.org/temporary/System.Data.SQLite-StickyHasRows-59 fcdb.zi

Re: [sqlite] SQLite Interop exception

2014-03-17 Thread Joe Mistachkin
ase" build configuration. By default, that setup is not supported. The simplest workaround is to change the active build configuration in Visual Studio to "ReleaseNativeOnly" and try again. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-user

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Joe Mistachkin
lication binary directory? This is especially important for the "x86" and "x64" directories within the archive. They should be extracted verbatim into the application binary directory. Also, you might need to recompile your application to refer to the new version of System.Data.

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-17 Thread Joe Mistachkin
ously. The next version is scheduled to be released sometime this week, barring any more late-breaking changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [sqlite-dev] Final preparations for the release of System.Data.SQLite v1.0.92.0 have begun...

2014-03-19 Thread Joe Mistachkin
not all x86 contents...is right ? > If you use one of the mixed-mode assemblies, yes. -- 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.92.0 released

2014-03-19 Thread Joe Mistachkin
on the SQLite mailing list (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] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Joe Mistachkin
y directory value should work fine. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Joe Mistachkin
hone 8). > > I have tried your suggestion anyway, but no result. > Can you enable the SQLite error logging mechanism, which may provide more details as to the root cause of the issue? It's described here: https://www.sqlite.org/errlog.

Re: [sqlite] SQLITE_ERROR (SQL logic error or missingdatabase) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

2014-03-27 Thread Joe Mistachkin
rectory should be set prior to the first database connection being opened. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

2014-03-27 Thread Joe Mistachkin
a37-ef048f > f7a7fb_agzj39a4a6zwt\\LocalState" > Sure, that's fine. However, the string must be UTF-16. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
/error log entries are you seeing when you set the temporary directory to the LocalState directory? Does the application have full read/write access to that directory? Are any PRAGMAs being executed prior to the query with the issue? -- Joe Mistachkin __

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
; > No > > Many thanks, > MB > Is the sqlite3_shutdown() function being called at some point? If so, the temporary directory will need to be reset after that point. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in Windows Phone Runtime Component

2014-03-28 Thread Joe Mistachkin
r, it may be possible to get it working with Visual Studio 2013. http://visualstudiogallery.msdn.microsoft.com/cd120b42-30f4-446e-8287-45387a 4f40b7 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Primary Key without DataAnnotation for Windows Runtime

2014-04-01 Thread Joe Mistachkin
erstanding your question correctly. For now, I'll assume you can modify the CREATE TABLE statement itself. In that case, you can make use of the PRIMARY KEY clause on one of the column definitions, such as: CREATE TABLE t1(x TEXT PRIMARY KEY, y TEXT); --

Re: [sqlite] LINQ - SQLite | Compact Framework 3.5?

2014-04-08 Thread Joe Mistachkin
CF. > The official .NET wrapper for SQLite, System.Data.SQLite, does support the .NET Compact Framework, see: https://system.data.sqlite.org/ -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-09 Thread Joe Mistachkin
teCommand object while an active data reader is attached to it. Normally, the Connection property of the SQLiteCommand object should not need to be set. I'm somewhat curious why it needs to be set in this case. -- Joe Mistachkin ___ sqlite-users mai

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
ost the code for the "CloseDati" routine? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-10 Thread Joe Mistachkin
his issue, I'll need to see the code for the "CloseDati" routine. This is necessary because I am unable to reproduce the issue thus far. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-11 Thread Joe Mistachkin
s with > > "Select * from table;" > > But the select doesn't return "1 2" as expected, it returns the FieldCount > which is 2 > > I am accessing SQlite in a powershell script > Could you also please show the PowerShell script that is being used to load

Re: [sqlite] cannot set connection while a datareader is active

2014-04-13 Thread Joe Mistachkin
y, changing the "If" expression should not make any difference; however, I seem to recall that the IsNothing function was typically used for checking the sub-type of a Variant (i.e. and not for checking for null references). Of course, I have not used Visual Basic.NET for quite a long

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
Ralf Jantschek wrote: > >$cn.ConnectionString = "Data Source=\\..." > If you are opening a database on a network share, there must now be four leading backslashes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Database access slowness on specific WinCE devices

2014-04-14 Thread Joe Mistachkin
it exhibits somewhat degraded performance due to block relocations, etc)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Joe Mistachkin
ed with the command you are attempting to set the connection of. Are you 100% sure that the "Dati" data reader is associated with the "objCmd" command? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-14 Thread Joe Mistachkin
t does not show the internal state of the SQLiteCommand object throwing the exception. When the Close() method of the SQLiteDataReader is called, it should end up calling ClearDataReader on the associated SQLiteCommand. In this case, that may not be happening. --

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
t might also exhibit the type of behavior you are seeing. Please try using the four leading backslashes and let us know the outcome. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database access slowness on specific WinCE devices

2014-04-15 Thread Joe Mistachkin
ainst the other devices you have. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-15 Thread Joe Mistachkin
Stefano Ravagni wrote: > > So what have i do? Need to see others setting or state? > It would be useful to try and examine the internal state of the SQLiteCommand and see if the _activeReader member is valid. If it is valid, see if it actually refers to the data reader you are using

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Joe Mistachkin
Ralf wrote: > > I just tried... No change :-( > Have you looked at the contents of the database using the SQLite command line tool for Windows? https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip -- Joe Mistachkin ___ sql

Re: [sqlite] cannot set connection while a datareader is active

2014-04-16 Thread Joe Mistachkin
ll debugging information for them. I recommend adding the "System.Data.SQLite.20XX.csproj" and "SQLite.Interop.20XX.vc[x]proj" projects that correspond to the version of Visual Studio you are using. Then, you'll want to reset the reference to point to the project instead of the bu

Re: [sqlite] What does Installer.exe do in the binary packages?

2014-04-18 Thread Joe Mistachkin
the design-time components for Visual Studio. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Joe Mistachkin
me to narrow down exactly what caused the SQLiteCommand to get into a state where the connection cannot be reset. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-19 Thread Joe Mistachkin
ce this mailing list strips attachments, you could post a link to a ZIP file that can be downloaded. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

2014-04-21 Thread Joe Mistachkin
triction on resetting the underlying connection for a command when data readers are active. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Provider not showing up in .Net Model import wizard

2014-04-24 Thread Joe Mistachkin
appear in the list. > None of the NuGet packages for System.Data.SQLite install the design-time components for Visual Studio, since that would require various machine-wide changes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] Windows Phone 8.1

2014-05-05 Thread Joe Mistachkin
Ryan Finnesey wrote: > > Has anyone confirmed this is something in the works? > It's actively being worked on. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a single file version of System.Data.SQLite?

2014-05-06 Thread Joe Mistachkin
en here: http://msdn.microsoft.com/en-us/library/ky3942xh%28v=vs.110%29.aspx -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite with Entity Framework problem

2014-05-06 Thread Joe Mistachkin
associated entity class? > > The version of SQLite I'm using is 1.0.92.0 and the entity framework is > 6.0.0.0. > Is the version of Entity Framework exactly 6.0.0.0 or is it something like 6.0.0.2? -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Is there a single file version of System.Data.SQLite?

2014-05-07 Thread Joe Mistachkin
tps://system.data.sqlite.org/index.html/artifact?ci=trunk=Doc/Ext ra/Provider/environment.html Largely, it depends on the specifics of your environment, which I'm not really familiar with. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-use

Re: [sqlite] Could not open registry key

2014-05-07 Thread Joe Mistachkin
etup in order to install the System.Data.SQLite assemblies into the GAC and setup the design-time components for Visual Studio. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling System.Data.SQLite for .NET CF 3.5 (VS2008 & WinCE 6) on x86

2014-05-09 Thread Joe Mistachkin
Eric Johnston wrote: > > The question is: How do I compile System.Data.SQLite for .NET CF 3.5 (VS2008) > with a target platform of x86 for the SQLite.Interop.092.dll? > The Windows CE 6.x SDKs that I've seen do not include support for the x86 platform. Are you aware of one that d

Re: [sqlite] Code Error -- Cannot compile Amalgamation with SQLITE_THREADSAFE=0 on WIndows

2014-05-11 Thread Joe Mistachkin
se. Short term, modifying "mutex_w32.c" to include "os_win.h" inside a SQLITE_OS_WIN block instead of the SQLITE_MUTEX_W32 block seems better. Long term, modifying the amalgamation tooling to better handle includes that occur within #ifdef's would be nice. -- Joe Mistachkin _

Re: [sqlite] Release date of Windows Phone 8.1 SQLite

2014-05-22 Thread Joe Mistachkin
Klemen Forstneric wrote: > > is there a release date for the Windows Phone 8.1 version of SQLite (the > one available here: > http://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2a f75d1b) > The current plan is to release it when SQLite 3.8.5 is re

Re: [sqlite] SQLite3 database on windows network drive and unreliable connection

2014-05-27 Thread Joe Mistachkin
Denis Y. Zibarev wrote: > > The problem goes down to winLock() implementation, particularly to winLockFile() ... > I've made some experimental changes on the winLockHandle branch that should address this issue; however, I still need to add some tests to verify the new behavior

Re: [sqlite] System.Data.SQLite failing in Windows 7

2014-06-12 Thread Joe Mistachkin
eased in April of 2010). It might be worthwhile to contact the vendor of the application and gently urge them to upgrade. -- 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 failing in Windows 7

2014-06-13 Thread Joe Mistachkin
Calvert, Jim wrote: > > Is there anybody from the developers of SQLite who can comment on this issue > for me. > I did reply to your original post. Here is a link to the thread: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg84247.html -- Jo

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.93.0 have begun...

2014-06-16 Thread Joe Mistachkin
If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to this coming Friday, June 20th. Thanks. -- Joe Mistachkin ___ sqlite-users mailing

Re: [sqlite] importing CSV with a random empty line at the end

2014-06-16 Thread Joe Mistachkin
Thanks for the report. Fixed on trunk, here: https://www.sqlite.org/src/info/fc918f7d33 -- 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.93.0 released

2014-06-23 Thread Joe Mistachkin
on the SQLite mailing list (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] Building with sqlite in C#

2014-06-29 Thread Joe Mistachkin
o get it copied to the build directory when setting up a project? > The recommended way to handle this is by using the NuGet package, e.g.: https://www.nuget.org/packages/System.Data.SQLite/ -- Joe Mistachkin ___ sqlite-users mailing list sqlit

Re: [sqlite] Basic SQLite/EF6 question

2014-07-04 Thread Joe Mistachkin
-netFx451-setup-bundle-x86-2013 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-04 Thread Joe Mistachkin
ers" sections, e.g.: https://system.data.sqlite.org/index.html/artifact?ci=trunk=testlin q/2010/EF6/App.config=6-12 -AND- https://system.data.sqlite.org/index.html/artifact?ci=trunk=testlin q/2010/EF6/App.config=16-20 Any extraneous entries in either section should be removed. -- Joe Mist

Re: [sqlite] Basic SQLite/EF6 question

2014-07-05 Thread Joe Mistachkin
the install was successful. I > don't know if that is a clue to what the problem might be. > That is expected behavior now that the installer launches VS in "setup" mode to refresh it's internal settings. -- Joe Mistachkin ___ sqlite-u

Re: [sqlite] Basic SQLite/EF6 question

2014-07-07 Thread Joe Mistachkin
tallation. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-10 Thread Joe Mistachkin
sion here (i.e. especially since the components are in completely different assemblies). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Basic SQLite/EF6 question

2014-07-10 Thread Joe Mistachkin
;install" the Entity Framework 6 package (via NuGet) into the target project). I am not aware of any other required steps. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Working with SQLite-Net in Framework 2.0

2014-07-10 Thread Joe Mistachkin
package instead of deploying application locally? Are you actually going to use the Visual Studio designer support? > > Can the two versions co-exist, or will there be problems? > In theory, yes; however, that configuration has *NOT* been te

Re: [sqlite] Working with SQLite-Net in Framework 2.0

2014-07-10 Thread Joe Mistachkin
y Pre-Loading" and "Deployment Guidelines" sections merit special attention. -- 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 - issues

2014-07-17 Thread Joe Mistachkin
st I thought it was the NGQP (since I > upgraded from version 3.7 to 3.8.5), but while trying to break it down, it > appeared the issue was with this fetch method. > Slower for what types of values? This is another issue where the database schema and possibly some C# code demonstratin

<    1   2   3   4   5   6   7   >