Re: [sqlite] sqlite built as Multithread

2016-06-08 Thread Joe Mistachkin
e used with native SQLite libraries that need to work with System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can't find PInvoke DLL 'SQLite.Interop.101.dll'.

2016-06-10 Thread Joe Mistachkin
Nigel Walton wrote: > > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > PID:01FD0185 TID:057E0022 testce.EXE > MissingMethodException > Can't find PInvoke DLL 'SQLite.Interop.101.dll'. > Do you have the appropriate MSVC runtime ("MSVCR110.DLL") i

Re: [sqlite] Fwd: System.Data.SQLite support incremental_vacuum

2016-06-09 Thread Joe Mistachkin
must be set to "incremental" first, per: https://www.sqlite.org/pragma.html#pragma_incremental_vacuum -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

2014-10-09 Thread Joe Mistachkin
rom the configuration file? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how set the threading mode with ado.net sqlite provider

2014-10-10 Thread Joe Mistachkin
t currently be set via System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] group_concat query performance

2014-10-13 Thread Joe Mistachkin
t; > 3. "SQLitePerfTest - VB.net which runs slow, 50.000 queries in 5 or 6 minutes; > Are you able to share the query and the schema of the database involved? If you have sample code, that might reveal important details as well. -- Joe Mistachkin

Re: [sqlite] sqlite data source not available

2014-10-14 Thread Joe Mistachkin
ply replace the version numbers (*BOTH* of them) in the URI and get it from there. For example: https://system.data.sqlite.org/downloads/1.0.94.0/sqlite-netFx45-setup-bundl e-x86-2012-1.0.94.0.exe Would become: https://system.data.sqlite.org/downloads/1.0.93.0/sqlite-netFx45-setup-b

Re: [sqlite] group_concat query performance

2014-10-16 Thread Joe Mistachkin
NET) example code as there are a variety of ways to query and process data using it. Is there any chance we could see the code that is using System.Data.SQLite? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:

Re: [sqlite] Fw: Database is locked exceptions

2014-10-30 Thread Joe Mistachkin
ection("Data Source=:memory:;"); cnn.Open(); using (SQLiteCommand cmd = new SQLiteCommand( "SELECT * FROM sqlite_master;", cnn)) { using (SQLiteDataReader reader = cmd.ExecuteRea

Re: [sqlite] Fw: Database is locked exceptions

2014-10-30 Thread Joe Mistachkin
Mike McWhinney > > I thought the SQLite mailing list included traffic that discussed System.Data.SQLite > Yes, it does. This mailing list *IS* the appropriate place to for discussion of System.Data.SQLite. -- Joe Mistachkin ___ sqlite-user

Re: [sqlite] compiling for WP81

2014-11-20 Thread Joe Mistachkin
ild-all-msvc.bat. >>> However, when I initialize with vcvarsphoneall, I end up with >>> > Please try the following commands from a Visual Studio 2013 Command Prompt: SET PLATFORMS=x86 x86_arm SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1

Re: [sqlite] System.Data.SQLite NuGet

2014-11-21 Thread Joe Mistachkin
ot;SQLite interop assembly"), as well as the managed System.Data.SQLite assemblies. The next release of System.Data.SQLite (1.0.95.0) will include SQLite 3.8.7.2 and is currently expected to be ready sometime in the mid-December timeframe, including the NuGet packag

Re: [sqlite] System.Data.SQLite (v1.0.94.0) - Which encryptionalgorithm is used?

2014-11-25 Thread Joe Mistachkin
http://msdn.microsoft.com/en-us/library/windows/desktop/aa386986%28v=vs.85%2 9.aspx The exact algorithm and key strength selected probably depends on the version of Windows being used. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] Win 64 SQLLite 90 - badimageformatexception

2015-01-10 Thread Joe Mistachkin
.dll") when trying to run my application?' https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q12 'Using Native Library Pre-Loading' https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki#nativ eLibraryPreLoading -- Joe Mistachkin ___

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

2015-02-02 Thread Joe Mistachkin
e/www/downloads.wiki Thanks. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-04 Thread Joe Mistachkin
/ 2013. Could you please try your scenario again using a 1.0.95.0 pre-release package? https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqli

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

2015-02-04 Thread Joe Mistachkin
u describe here locally. Can you provide any further clues about your environment or the crash itself that could point us in the right direction (e.g. stack trace, etc)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqli

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-04 Thread Joe Mistachkin
eve that the Entity Framework is trying to use the ADO.NET provider for SQL Server instead of SQLite. Also, could you try updating to the latest NuGet packages as well? They have not been pushed and are only [now] available for download from the site.

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

2015-02-05 Thread Joe Mistachkin
Duncan Hall wrote: > > 'cmd.CommandText = "SELECT name FROM sqlite_master WHERE type='table'" > cmd.CommandText = "SELECT * FROM idx_Locale_Geometry " > Are you able to share the schema for your database? It ma

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-05 Thread Joe Mistachkin
r the configuration file changes to be effective. -- 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 for Pocket PC & RTREE

2015-02-05 Thread Joe Mistachkin
. I suspect the underlying issue may be an alignment fault (or stack overflow) due to bad interaction between the ARM processor architecture and the SpatiaLite extension. Out of curiousity, do you know where to find the loadable module binaries for Windows CE (for SpatiaLite)? -- Jo

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-06 Thread Joe Mistachkin
I think I've figured out a way to solve the "config file issue". I've rebuilt all the pre-release packages, including the NuGet packages. Could you please try your scenario again? -- Joe Mistachkin ___ sqlite-users mailing list sq

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-09 Thread Joe Mistachkin
rt to try it. -- 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 for Pocket PC & RTREE

2015-02-09 Thread Joe Mistachkin
aries are being used? Could you please try to enable native debugging and capture the call stack when the issue occurs? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Repost: Having problems with Entity Framework code first db creation

2015-02-09 Thread Joe Mistachkin
uot;code first" scenarios with the Entity Framework. Some errors we have seen in the past are: https://system.data.sqlite.org/index.html/tktview/f37ca75 and https://system.data.sqlite.org/index.html/tktview/6b5ef4f -- Joe Mistachkin ___

Re: [sqlite] visx for regular old windows

2015-02-11 Thread Joe Mistachkin
I've been told that MSBuild will use it but that VS will not show/"see" it. However, after learning this I didn't verify. Things may improve in VS 2015. Perhaps we can find out from the CTP release? Sent from my iPod > On Feb 11, 2015, at 4:13 PM, E. Timothy Uy wrote: > >

Re: [sqlite] recommended way to attach SQLite.Interop.dll

2015-02-11 Thread Joe Mistachkin
The new NuGet packages use MSBuild integration via a custom targets file to copy the interop DLLs to the "right" place at build-time. Sent from my iPod > On Feb 11, 2015, at 5:38 PM, E. Timothy Uy wrote: > > Hi, when I add the nuget package for System.Data.SQLite, I don't see

Re: [sqlite] [System.Data.SQLite.DLL] Cannot access sqlite database on remote computer

2016-05-26 Thread Joe Mistachkin
m (which was revised 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 mail

[sqlite] NtFlushBuffersFileEx for SQLITE_SYNC_DATAONLY onWindows ?

2015-04-03 Thread Joe Mistachkin
c does not have a performance advantage over a full sync. And the Nt*() interfaces may cause portability problems for things like WinCE. -- Joe Mistachkin

[sqlite] Enhancement Request: sqlite3 shell output mode "insert" include column names

2015-04-07 Thread Joe Mistachkin
Roy Keene wrote: > > The "insert" output mode is very basic, however, and lacks column > names in the output. > Can you try the changes on the "expShell" branch and see if they work for your use case? In order to get column names, you'll need to set the headers to "on". -- Joe Mistachkin

[sqlite] System.Data.Sqlite with EF6 and VS2013 not working with asqlite database file

2015-04-19 Thread Joe Mistachkin
valid primary key could be inferred. This table/view has been > excluded. To use the entity, you will need to review your schema, add the > correct keys, and uncomment it. > If the table actually does have a primary key defined, maybe the EDMX from the other version of Visual Studio is incompatible? -- Joe Mistachkin

[sqlite] Upgraded 1.0.60.0 to 1.0.96.0

2015-04-24 Thread Joe Mistachkin
re they do not get garbage collected by keeping an instance of them associated with another long-lived object (i.e. WinForm) or as a static field somewhere. -- Joe Mistachkin

[sqlite] Upgraded 1.0.60.0 to 1.0.96.0

2015-04-24 Thread Joe Mistachkin
ed, it might be better to either correct or regenerate the auto-generated code. I realize this may be a large undertaking; however, I think it will be quite worthwhile as a great many things have been fixed and improved in System.Data.SQLite in the last several years. -- Joe Mistachkin

[sqlite] Can you enable Recursive Triggers via the connection string?

2015-08-02 Thread Joe Mistachkin
If you are using System.Data.SQLite, then this feature has been added and will be available in version 1.0.98.0, due out this month (August). Sent from my iPhone > On Aug 1, 2015, at 1:47 AM, Mark A. Donohoe > wrote: > > I hope this is the right address to send my questions to. > > I found

[sqlite] SQLite Entity Framework Provider

2015-08-04 Thread Joe Mistachkin
ider that would enable these features? Maybe there is a clear list of the various requirements in ADO.NET providers to support the various EF6 features? -- Joe Mistachkin

[sqlite] Compile Warning from Universal Windows App using Visual Studio 2015

2015-08-04 Thread Joe Mistachkin
Please update to the version updated on 2015-07-31 and try again. Sent from my iPhone > On Aug 4, 2015, at 7:19 PM, Weidong Shen wrote: > > Hi, > > I created a test UWP project using Visual Studio 2015/Windows 10 and added a > reference to "SQLite.UAP.2015, Version=3.8.11.1". When compiling

[sqlite] SQLite crash

2015-08-11 Thread Joe Mistachkin
o hook similar Win32 APIs, with unpredictable results. Does this issue occur when running a build of SQLite on your machine without Cygwin (i.e. built using MSVC)? -- Joe Mistachkin

[sqlite] How to enable shared cache mode?

2015-08-13 Thread Joe Mistachkin
he mode for use with System.Data.SQLite is something that is being considered. -- Joe Mistachkin

[sqlite] How to enable shared cache mode?

2015-08-13 Thread Joe Mistachkin
Simon Davies wrote: > > Shared cache can be specified in URI filenames; do they not work with > System.Data.SQLite? > http://www.sqlite.org/c3ref/open.html#urifilenamesinsqlite3open > Yes, that should work. -- Joe Mistachkin

[sqlite] System.Data.SQLite preRelease branch

2015-08-17 Thread Joe Mistachkin
or a pre-release build, there will be a "Pre-Release Download" link to the far left on the web site navigation panel. Anyhow, the 1.0.98.0 release should be out sometime this week. -- Joe Mistachkin

[sqlite] System.Data.SQLite 1.0.98.0 release

2015-08-19 Thread Joe Mistachkin
If everything goes as planned, it should be out later today (US Pacific Time). Sent from my iPhone > On Aug 19, 2015, at 4:37 AM, Steffen Mangold powerdoo.com> wrote: > > Hi, > > is there any target date when the preRelease branch gets over to a actual > release? > > Is a really hard show

[sqlite] System.Data.SQLite version 1.0.98.0 released

2015-08-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] Open DB from stream to use System.IO.Packaging.Package

2015-08-20 Thread Joe Mistachkin
Steffen Mangold wrote: > > is there a proper way to open a SQLiteConnection from a Stream object? > That is not directly supported. -- Joe Mistachkin

[sqlite] DbFunctions.TruncateTime

2015-08-23 Thread Joe Mistachkin
The LINQ provider for System.Data.SQLite does not provide this function directly; however, it may be possible to use one of the core date-time related SQL functions to do it? https://www.sqlite.org/lang_datefunc.html -- Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.99.0 released

2015-12-09 Thread Joe Mistachkin
on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] Malloc getting segmentation fault in sqlite

2015-12-24 Thread Joe Mistachkin
It's been quite a long while since I used vb6 on a regular basis; however, integrating with native DLLs can be quite tricky for several reasons: 1. It cannot call any native function that does not conform to the "stdcall" calling convention. 2. It has a very Win32-centric way of marshalling

[sqlite] System.Data.SQLite: Incorrect implementation of SQLiteDataReader::GetSchemaTable()

2015-12-31 Thread Joe Mistachkin
always allow null > values. > Unfortunately, changing this method in such a fundamental way would not be backwards compatible. Also, in some cases, it can be quite difficult to determine what the "correct" behavior should be. -- Joe Mistachkin

[sqlite] Do you mean utf8_fprintf on this commit ?

2015-12-31 Thread Joe Mistachkin
Domingo Alvarez Duarte wrote: > > On this commit https://www.sqlite.org/src/info/8cf01fff232d15d3 do you > mean "utf8_fprintf" instead of "utf8_printf" ? > No, I meant to use the existing "utf8_printf" function (and the new "raw_printf" macro). -- Joe Mistachkin

[sqlite] Error with VS2012

2015-02-16 Thread Joe Mistachkin
Looks like version 1.0.84.0? I don't notice any obvious errors; however, it might be better to use the current release (1.0.94.0) or the pre-release of 1.0.95.0 instead. > On Feb 16, 2015, at 3:29 AM, Manoj Sakhare wrote: > > > ___ > sqlite-users

[sqlite] SQLite source for Windows phone 8?

2015-02-20 Thread Joe Mistachkin
5387 a4f40b7 And for Windows Phone 8.1: https://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2 af75d1b -- Joe Mistachkin

[sqlite] Database connection from within Visual Studio 2010

2015-02-23 Thread Joe Mistachkin
ads/1.0.94.0/sqlite-netFx40-setup-bundl e-x86-2010-1.0.94.0.exe -- Joe Mistachkin

[sqlite] Consuming Visual studio extension SDKs in a remote build

2015-02-23 Thread Joe Mistachkin
elf has complete version information and should end up getting installed into a named directory that contains the version number itself within it. That being said, maybe some special setup is required for TFS (which I know almost nothing about). -- Joe Mistachkin

[sqlite] Database connection from within Visual Studio

2015-02-24 Thread Joe Mistachkin
download page. Do you have any other specific suggestions on how to improve the usability and/or readability of the download page? -- Joe Mistachkin

[sqlite] Sqlite with VS2013

2015-02-25 Thread Joe Mistachkin
Please try the 1.0.95.0 pre-release of that same install package. Sent from my iPod > On Feb 25, 2015, at 12:08 AM, Manoj Sakhare wrote: > > Can anyone please guide me to install sqlite desinger capabilities for > VS2013. > > I have installed

[sqlite] Database connection from within Visual Studio

2015-02-26 Thread Joe Mistachkin
Thanks for the suggestions. As soon as the 1.0.95.0 release is out the door, I'll work on refactoring the download page to make it easier to use. -- Joe Mistachkin

[sqlite] Fix for non unix times DATETIME

2015-07-10 Thread Joe Mistachkin
peMapping("DATETIME", DbType.String, true); Please note that you may need to add more mappings if the DateTime type names you need are not always "DATETIME". Also, please let us know if this works for you. -- Joe Mistachkin

[sqlite] System.Data.Sqlite3.dll for OSX

2015-07-10 Thread Joe Mistachkin
ries on Windows? https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6 -- Joe Mistachkin

[sqlite] [PATCH] fix mksqlite3c.tcl --linemacros

2015-07-15 Thread Joe Mistachkin
port. This should now be fixed on trunk. -- Joe Mistachkin

[sqlite] Broken link on System.Data.SQLite homepage

2015-07-22 Thread Joe Mistachkin
Drago, William wrote: > > I'm getting a 404 on the link to sqlite.phxsoftware.com. > Yeah, I'm aware of that. The link is correct; however, the site now appears to be gone. -- Joe Mistachkin

[sqlite] pragma temp_store_directory problem with UTF-8 characters

2015-07-22 Thread Joe Mistachkin
. Are you able to provide an example UTF-8 byte sequence that demonstrates the problem when passed into the SQLite C API? -- Joe Mistachkin

[sqlite] pragma temp_store = 2 ignored in WinRT App

2015-07-22 Thread Joe Mistachkin
Michael Geier wrote: > > I would like to report that "PRAGMA temp_store = 2;" seems to be ignored > in WinRT applications (Windows 8.1 App). > Is there a transaction pending? What does sqlite3_get_autocommit() return? -- Joe Mistachkin

[sqlite] SQLite 3.8.11 don't compile in VS9 for CE6/CE7 RELEASEtarget

2015-07-29 Thread Joe Mistachkin
Christian Nols wrote: > > Commenting > #include > seems to work around it > I've added support for the SQLITE_DISABLE_INTRINSIC define (on trunk). When this is defined for a project, it should prevent that header file from being included. Thanks for the report. -- Joe Mistachkin

[sqlite] ATTACH Problem

2015-07-30 Thread Joe Mistachkin
Chris Parsonson wrote: > > > The first thing I need to do with the second database is ATTACH it > to the first one. This is what I haven't been able to do successfully. > > Have you tried using a SQLiteParameter for the file name for the database to attach? -- Joe Mistachkin

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

2015-07-30 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 Monday, August 3rd. Thanks. -- Joe Mistachkin

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

2015-05-31 Thread Joe Mistachkin
ltFlags_SQLiteConnection" (new to 1.0.97.0) may be used, by setting it to a value of: "LogAll" (without the quotes) The diagnostic output, which should be sent to all registered trace listeners, may prove useful. -- Joe Mistachkin

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

2015-05-31 Thread Joe Mistachkin
es in the BinaryGUID connection string property name is very important, as is matching it up the actual affinity of the column in the target database (i.e. based on the BinaryGUID property value used when the table was originally created). -- Joe Mistachkin

[sqlite] Including PRAGMA statements on connection string

2015-06-09 Thread Joe Mistachkin
.e. connection string properties), not SQL statements. There is not currently a connection string property that directly sets the busy timeout; however, one may be added in the future. Meanwhile, the synchronous property can be set by using the following fragment in the connection string: "Synchronous=Off;" -- Joe Mistachkin

[sqlite] FW: SQLite (1.0.97) access via LAN

2015-06-26 Thread Joe Mistachkin
ompilation with System.Data.SQLite-x64-1.0.97.dll (.NET4) > > // Error message: "unable to open database file" > Are you using a NuGet package? If so, which one? What is the processor architecture of the machine involved? Is there more than one machine? What System.Da

[sqlite] System.Data.SQLite version 1.0.95.0 released

2015-03-02 Thread Joe Mistachkin
on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] System.Data.SQLite and spellfix under VB.net

2015-03-02 Thread Joe Mistachkin
you can load it using the SQLiteConnection.LoadExtension method. Finally, you should be able to follow along with the normal spellfix docs, here: https://www.sqlite.org/spellfix1.html -- Joe Mistachkin

[sqlite] System.Data.SQLite.DLL version 1.0.95.0 Bug

2015-03-02 Thread Joe Mistachkin
Michal wrote: > > The table does have a Primary Key. > Can you share the complete schema of the table involved? -- Joe Mistachkin

[sqlite] System.Data.SQLite.DLL version 1.0.95.0 Bug

2015-03-02 Thread Joe Mistachkin
This issue should be fixed on the "nextRelease" branch, here: https://system.data.sqlite.org/index.html/info/154d609bbe Please let us know if this clears the problem for you. -- Joe Mistachkin

[sqlite] System.Data.SQLite.DLL version 1.0.95.0 Bug

2015-03-03 Thread Joe Mistachkin
Michal wrote: > > Thank you for looking at the issue. I am not sure what to do with > the link supplied below, I think that is way above my skill level. > The fix will be included in the next release of System.Data.SQLite. -- Joe Mistachkin

[sqlite] System.Data.SQLite version 1.0.96.0 released

2015-03-04 Thread Joe Mistachkin
on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread Joe Mistachkin
What file system is being used on the drive in question (e.g. FAT, FAT32, NTFS, etc)? -- Joe Mistachkin

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread Joe Mistachkin
; drives could you tell me why did you suspect about the drive type ? > The FAT and FAT32 file systems have a relatively low limit on the maximum size of a single file. Their limit happens to be right around 4GB. -- Joe Mistachkin

[sqlite] Did A Recent Windows & Update Affect SQLite???

2015-03-31 Thread Joe Mistachkin
ndows Memory Diagnostic tool). Next, I would run a Microsoft Security Essentials "full scan". If all of the above are OK, you might want to see if the application and/or Windows have any more available updates. -- Joe Mistachkin

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

2015-05-12 Thread Joe Mistachkin
pending more testing, here: https://system.data.sqlite.org/index.html/timeline?r=stepNoThreadAbort Could you test these changes in your environment and let us know if they clear the issue? -- Joe Mistachkin

[sqlite] Please explain SQLiteConnection.GetSchema restrictionValues

2015-05-15 Thread Joe Mistachkin
tml/artifact?filename=System.Data.SQLi te/SQLiteConnection.cs=tip=3660-3709 -- Joe Mistachkin

[sqlite] Please explain SQLiteConnection.GetSchema restrictionValues

2015-05-15 Thread Joe Mistachkin
I just updated the documentation with more details, here: https://system.data.sqlite.org/index.html/ci/4be7ad3120577d30?sbs=0 -- Joe Mistachkin

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

2015-05-19 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 Monday, May 25th. Thanks. -- Joe Mistachkin

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

2013-10-20 Thread Joe Mistachkin
ran my app > again and it worked as expected. > The setup bundle modifies the machine-wide configuration file to add the SQLite ADO.NET provider. However, when deploying to any machine that does not require the Visual Studio design-time functionality, add the necessary section to the "

Re: [sqlite] sqlite-users Digest, Vol 70, Issue 21

2013-10-21 Thread Joe Mistachkin
le does install the required Visual C++ runtime libraries automatically. That would explain why things worked correctly after you ran the setup bundle on the target machine. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqli

Re: [sqlite] Mystery why SQLite will not work until System.Data.SQLite has been installed

2013-10-23 Thread Joe Mistachkin
m CC'ing you on this reply just in case you are not consistently getting the list traffic; however, in the future you may wish to check the list archives to be sure that you did not miss a reply (i.e. because it did not end up in your inbox, etc). -- Jo

[sqlite] System.Data.SQLite version 1.0.89.0 released

2013-10-26 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] compiling the non-AMALGAMATION on visual studio

2013-10-28 Thread Joe Mistachkin
Makefile.msc all SPLIT_AMALGAMATION=1 -- 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 v1.0.89 Breaks My App(SQLite.interop.dll)

2013-10-29 Thread Joe Mistachkin
ur target processor architecture and .NET Framework version. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling the non-AMALGAMATION on visual studio

2013-10-30 Thread Joe Mistachkin
David Clark wrote: > > NMAKE : fatal error U1045: spawn failed : No error > Stop. > >From my research, it looks like this error is caused by a 64-bit versus 32-bit issue. What version Windows are you running? Is it 32-bit or 64-bit? Which ActiveTcl distribution file did you i

Re: [sqlite] Could not load file or assembly'System.Data.SQLite.dll 'or one of its dependencies on WindowsXP. Ideas?

2013-11-13 Thread Joe Mistachkin
Andreas Hofmann wrote: > > Anyone know why this is happening? > The system might not have the required Visual C++ Runtime Libraries installed. However, this can be done manually via one of the downloads at the following link: https://support.microsoft.com/kb/2019667 -- Joe M

Re: [sqlite] SQLite ADO.NET for .Net Compact Framework 3.9

2013-11-14 Thread Joe Mistachkin
2008 project into Visual Studio 2012. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite ADO.NET for .Net Compact Framework 3.9

2013-11-15 Thread Joe Mistachkin
. > I've just checked in files that should assist with properly building things for Windows Embedded Compact 2013, here: https://system.data.sqlite.org/index.html/ci/0adcab7b75 Please let us know if these work for you. -- Joe Mistachkin ___ sq

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

2013-11-25 Thread Joe Mistachkin
o be entirely compatible, most notable due to not taking the keyInfo into account. -- 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 version 1.0.89.0 released

2013-11-28 Thread Joe Mistachkin
Jan Slodicka wrote: > > bool exists; > exists = idxs.TryGetValue("Abc", out i);// true => ok > exists = idxs.TryGetValue("abc", out i);// false => BUG > Thanks, fixed on trunk. SQLiteDataReader now uses the built-in StringC

Re: [sqlite] Bug: Namespace System.Data.SQLite.Linq not accessible in Visual Studio 2013 Express

2013-12-01 Thread Joe Mistachkin
Vladimir Bradaska wrote: > > Namespace System.Data.SQLite.Linq not accessible in Visual Studio 2013 > Express > There are no types in the System.Data.SQLite.Linq namespace. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-user

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NET version)

2013-12-02 Thread Joe Mistachkin
) FROM t1; > > (B) How do I make it work for the SQLite System.Data.Sqlite adapter in .NET? > This involves modifying the SQLite.Interop project to include the percentile extension. The next release (1.0.90.0) will now include this extension by default.

Re: [sqlite] SQLite ver: 1.0.89 issue

2013-12-02 Thread Joe Mistachkin
aving an intermittent issue with query results normally indicates a threading issue (e.g. using the same System.Data.SQLite object instance from more than one thread). Is that a possibility in this case? Can you provide any further details related to thi

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

2013-12-02 Thread Joe Mistachkin
n be done by right-clicking the "References" node underneath your project node in the Solution Explorer window and selecting the "Add reference..." option. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] Percentile function in SQLite 3.8.0 (for the .NETversion)

2013-12-02 Thread Joe Mistachkin
oc/trunk/www/news.wiki In this case, it will be sometime around mid-January, perhaps a bit earlier. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite ver: 1.0.89 issue

2013-12-03 Thread Joe Mistachkin
to the possibility of using the wrong database file name. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

2013-12-03 Thread Joe Mistachkin
folder. > I'm not sure; however, the "testce" project in the System.Data.SQLite repository works fine with the standard .NET Compact Framework 2.0. The project file can be seen here: https://system.data.sqlite.org/index.html/artifact?ci=trunk=testce/ testce.20

  1   2   3   4   5   6   7   >