Re: [sqlite] I consider this a bug. Anyone else?

2012-06-26 Thread Joe Mistachkin
as long as you have the necessary tools (e.g. a Windows [virtual] machine with the .NET Framework installed): https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] Bug: incorrect forward declaration ofsqlite3_win32_sleep

2012-06-18 Thread Joe Mistachkin
structure where the sqlite3_sleep function cannot be called for one reason or another (e.g. there is no VFS yet). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug: incorrect forward declaration of sqlite3_win32_sleep

2012-06-18 Thread Joe Mistachkin
The previous check-in should have cleared the compilation error you reported (?); however, I've made another change which should produce the desired effects: https://www.sqlite.org/src/info/21266c68af -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] sqlite-3.7.13 fails to build with gcc2-.95.3

2012-06-18 Thread Joe Mistachkin
scottmc wrote: > > The build of sqlite-3.7.13 fails to build with gcc2-.95.3 on a recent > Haiku nightly build, near line 2650 of shell.c probably from this > change: > Could you try using the code in the "compiler-compat" branch and see if the problem c

Re: [sqlite] Bug: incorrect forward declaration of sqlite3_win32_sleep

2012-06-18 Thread Joe Mistachkin
Roger Binns wrote: > > There should not be an extern since SQLITE_API will be appropriately > defined. And if SQLITE_API is set to static as is my case then there is a > compilation failure. > Could you try using the code in the "compiler-compat" branch and see if the

Re: [sqlite] Fwd: [SpatiaLite-Users] using spatialite on C# VS2008 SP1, Windows7 64 bit

2012-06-13 Thread Joe Mistachkin
ly, the sqlite3_malloc() and sqlite3_free() functions should be used instead. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: [SpatiaLite-Users] using spatialite on C# VS2008 SP1, Windows7 64 bit

2012-06-13 Thread Joe Mistachkin
Mitch Shin wrote: > > The specific error is "Attempted to read or write protected memory. > This is often an indication that other memory is corrupt." > > I am using VS2008 SP1, .net Framework 3.5 SP1, Windows7 64bit. > What versions of System.Data.SQLite and Spati

[sqlite] System.Data.SQLite version 1.0.81.0 released

2012-05-27 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] Bug: SQLiteDataAdapter.FillSchema doesn't work with multiresult queries

2012-05-25 Thread Joe Mistachkin
Thanks for the report. This issue is being worked on here: https://system.data.sqlite.org/index.html/info/3aa50d8413 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] ADO.NET Provider, targeting any cpu

2012-05-24 Thread Joe Mistachkin
e the directory where the "System.Data.SQLite.dll" file is located. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ADO.NET Provider, targeting any cpu

2012-05-23 Thread Joe Mistachkin
e is built into the mixed-mode assembly itself. The FAQ also contains some useful information on mixed-mode assemblies: https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-use

Re: [sqlite] ADO.NET Provider, targeting any cpu

2012-05-23 Thread Joe Mistachkin
; environment variable prior to loading and/or using the System.Data.SQLite 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 and pooling problem

2012-05-02 Thread Joe Mistachkin
The fixes for this issue have now been merged to trunk along with an appropriate test case that can reproduce the issue. https://system.data.sqlite.org/index.html/ci/ae1f4354e4?sbs=0 -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

2012-05-02 Thread Joe Mistachkin
Using Reflector, I can see the resources: https://system.data.sqlite.org/temporary/linq_resources.png What is the exception you are seeing when the BuildTempSchema method is called? -- Joe Mistachkin ___ sqlite-users mailing list sqlite

Re: [sqlite] Missing SQL_CONSTRAINTS resource in System.Data.SQLite.Linq since v1.0.79.0

2012-05-02 Thread Joe Mistachkin
?sbs=0 Any additional information you could provide on this would be useful? For example, which build of System.Data.SQLite are you using? Is the assembly in the GAC? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.or

Re: [sqlite] System.Data.SQLite and pooling problem

2012-05-01 Thread Joe Mistachkin
Greg Carter wrote: > > I tried out the changes on the tkt-996d13cd87 branch and our application > runs fine with pooling on, at least for the test case that I was using to > reproduce it within our app. > Thanks! > Do you have a test case you would be willing to share?

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

2012-05-01 Thread Joe Mistachkin
has some information on how to use this class, including for the static RegisterFunction method used to actually add the custom functions to the database connection. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-30 Thread Joe Mistachkin
n visual studio. > Yeah, this is actually an issue with Visual Studio itself. The reason that the files are in a targets file is because it ends up being included by several C# project files, including the one for the .NET Compact Framework. -- Joe Mistachkin

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-30 Thread Joe Mistachkin
eConnectionHandle object, which ends up calling SQLiteConnectionHandle.ReleaseHandle, which calls SQLiteBase.CloseConnection (i.e. this has the potential to pull the rug out from under the SQLiteBase.ResetConnection method in the other thread). -- Joe Mistachkin

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-30 Thread Joe Mistachkin
Joe Mistachkin wrote: > > Alexander Spence wrote: > > > > What is the purpose of these locks when Sqlite itself has been compiled as ThreadSafe? > > > > I'm not sure what the original intent of that lock was; however, after reviewing the code, > that lock does n

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-30 Thread Joe Mistachkin
sure what the original intent of that lock was; however, after reviewing the code, that lock does not seem to serve a useful purpose. My plan now is to remove it for the next release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-29 Thread Joe Mistachkin
e invalid; however, I've still been unable to cause it to fail with an access violation. It would be great if you could come up with a clean reproduction for this issue so that we can verify it's actually fixed. -- Joe Mistachkin ___ sqlite-users mailin

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-29 Thread Joe Mistachkin
elease 1.0.80.0 and the latest code in trunk on both 32-bit and 64-bit Windows 7. Here is my test case: https://system.data.sqlite.org/index.html/artifact?ci=tip=Tests/tkt -996d13cd87.eagle If you (or anybody else) could share some C# code that reproduces the issue, that would indeed be very h

Re: [sqlite] System.Data.SQLite and pooling problem

2012-04-28 Thread Joe Mistachkin
he exception happening consistently or on intermittently? -- 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 and pooling problem

2012-04-27 Thread Joe Mistachkin
9 of SQLite3.cs). > Are you seeing an ObjectDisposedException or an AccessViolationException? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Installation

2012-04-24 Thread Joe Mistachkin
MJWestkamper wrote: > > I downloaded and installed the SQLite x64 version for .NET 4.0 > Visual Studio is a 32-bit only application. The 32-bit mixed-mode (bundle) setup package for the .NET Framework 4.0 must be used in order to have the design-time components installed during the setup. It

Re: [sqlite] Concat in Visual Studio 2010 designer

2012-04-24 Thread Joe Mistachkin
myself. > The VS design-time components for System.Data.SQLite were originally written to integrate with Visual Studio 2005/2008. I've made them work with Visual Studio 2010; however, as far as I know they were never "feature complete" and they may not fully expose all the SQLite functionali

Re: [sqlite] to joe mistachkin - Ticket 4bbf851fa5

2012-04-12 Thread Joe Mistachkin
R- // you can use Sysinternals DebugView tool to see it when the application is // not running inside the debugger). // System.Diagnostics.Trace.Listeners.Add(new ConsoleTraceListener()); using (SQLiteConnection connection = new SQLiteConnection( "Data Source=somefile.db;Flags=LogAll;")) { connect

Re: [sqlite] SQLite Exception 14

2012-04-12 Thread Joe Mistachkin
, the SQLiteConnection class does not have an "Insert" method. My guess is that you are using a different data access library from the "standard" System.Data.SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] Searching for system.data.sqlite version 1.0.74.0

2012-04-10 Thread Joe Mistachkin
e by clicking the "ZIP archive" link (near the top of the page). > > The x64 Version is needed. > I'm guessing that you want the mixed-mode assembly for the .NET Framework 3.5. Here is the link: https://system.data.sqlite.org/downloads/1.0.74.0/sqlite-netFx35-binary

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-06 Thread Joe Mistachkin
nk/www/faq.wiki Other than that, having a good understanding of Visual Studio, interop with native code, and multi-language solutions is also very useful. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-06 Thread Joe Mistachkin
method and because of that, i try to recompile with > SQLITE_DEFAULT_FOREIGN_KEYS. > It looks like you'll need to make sure you have the "SQLITE_DEFAULT_FOREIGN_KEYS=1" set in your preprocess defines (i.e. you cannot just define it with no value). -- Joe Mistachkin

Re: [sqlite] Integer Truncation Issue

2012-04-06 Thread Joe Mistachkin
the declared types in the table schema to map the values to .NET Framework types. Therefore, if you want double values, you should use DOUBLE. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

2012-04-05 Thread Joe Mistachkin
less the application executable has been flagged as "32-bit only", which is quite rare). The "SQLite.Interop.dll" file must be located in the application binary directory or along the PATH and the processor architecture must be appropri

Re: [sqlite] System.Data.SQLite DLL pre-load bug

2012-04-02 Thread Joe Mistachkin
us throws an exception and dies. > Just to clarify, the native library pre-loading code itself does not throw any exceptions itself. Most likely, the exception you are seeing is a direct result of the OS loader being unable to locate the native interop assembly because it is not being copied by the p

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

2012-04-01 Thread Joe Mistachkin
} } static void Main(string[] args) { BackupAndGetData(); } } } -- 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.80.0 released

2012-03-31 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] System.Data.SQLite

2012-03-31 Thread Joe Mistachkin
ions "DebugNativeOnly" and/or "ReleaseNativeOnly" defined in your solution (i.e. otherwise the interop project will always default to linking with the .netmodule). -- 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

2012-03-30 Thread Joe Mistachkin
MSVC runtime dynamically. Other than that, they should be identical. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

2012-03-30 Thread Joe Mistachkin
generated by the DbCommandBuilder class without changing the underlying database schema. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Concurrency violation: the UpdateCommand affected 0 of the expected 1 records

2012-03-26 Thread Joe Mistachkin
Used() > Those exceptions indicate that the connection has been closed somehow. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Update from 3.6.23.1 to 3.7.10 : sqlite3_open16 error

2012-03-16 Thread Joe Mistachkin
like 0x0400) in the preprocessor settings for your project should work around the issue. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] xcopy deployment using System.Data.SQLite for Windows x86, x64, and Mono/Unix?

2012-03-14 Thread Joe Mistachkin
de (see the "Mono" section): http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki Please let me know if you have any specific questions not addressed on one of these pages. -- Joe Mistachkin ___ sqlite-users mailing list s

Re: [sqlite] xcopy deployment using System.Data.SQLite for Windows x86, x64, and Mono/Unix?

2012-03-08 Thread Joe Mistachkin
information: http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WinRT (WAS: Status)

2012-03-02 Thread Joe Mistachkin
Steven Nesbit wrote: > > What is the status of this effort? We actually need to have the > platform determined at runtime since we need to run on WinRT, > Android and iOS. > I'm not really following you here... Those are completely different platforms. --

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-24 Thread Joe Mistachkin
when it's available. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-22 Thread Joe Mistachkin
. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Joe Mistachkin
64-bit machine (since purely managed applications always run with the native processor architecture of the machine). Having said that, the best practice would be to always deploy the necessary assemblies (both native and managed) in the application directory itself. --

Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.

2012-02-21 Thread Joe Mistachkin
ailable locally in the same location as when it was built. That assumption is invalid in this case; however, in the more general case of projects being developed with SharpDevelop, that might be OK. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Joe Mistachkin
he target processor since the mixed-mode assembly does contain native code) and optionally "System.Data.SQLite.Linq.dll" (if you use the LINQ support). Also, if and only if you use the separate managed and native assemblies, you would need to include "SQLite.Intero

Re: [sqlite] Reference error

2012-02-21 Thread Joe Mistachkin
David Horne wrote: > > The only thing I haven't checked is the contents of the GAC for the > possible stray that you mention. Can you tell me how to do this? > Open a Visual Studio 2010 Command Prompt and type: gacutil /l System.Data.SQLite -- Jo

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-20 Thread Joe Mistachkin
will be checked by default. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reference error

2012-02-20 Thread Joe Mistachkin
ain it in this case because it appeared at first glance that you were using the DLL with the right processor architecture for your operating system. The only other explanation I can readily think of is that you are somehow setting a reference to the wrong System.Data.SQLite assembly in your project.

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
Electric Eddy wrote: > > This then popped up an error message dialogue box stating: > > Invalid core file image runtime version. > You'll want to copy the "Installer.exe" file to your installation directory first (where the "SQLite.Designer.dll"

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
64 true -installFlags All -tracePriority Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008 true -noVs2010 true -whatIf false -confirm true All of that needs to be on one line. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Joe Mistachkin
ork with Visual Studio 2005 or the actual project files and build system to work with Visual Studio 2005? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reference error

2012-02-20 Thread Joe Mistachkin
0.79.0 - and > installed it without difficulty on a 64 bit Windows 7 PC. > Can you run this tool on the installed System.Data.SQLite.dll and see if it complains about any missing dependencies? http://www.dependencywalker.com/ -- Joe Mistachkin __

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-19 Thread Joe Mistachkin
That might be a valid option; however, even if you use the "Express" edition, which is the only free option, you still have to install it and that can be quite challenging. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.or

Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-19 Thread Joe Mistachkin
e public interface)? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.

2012-02-19 Thread Joe Mistachkin
n class. The path you are seeing is from the machine used to build the released binaries. > > The code is essentially below. The GetSchema generates the error. > The correct argument to pass to GetSchema in this case is "MetaDataCollections" (wi

Re: [sqlite] BUG REPORT using refreshschema on SQLiteCommandBuilder

2012-02-19 Thread Joe Mistachkin
. refreshschema.aspx In your example you use: SQLiteCommand cmd1 = builder.GetInsertCommand(); And then you call: builder.RefreshSchema(); Which disposes of the command you previously grabbed. This is by design, per the MSDN specification. -- Joe Mistachkin

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread Joe Mistachkin
sed almost 7 years ago and is now obsolete, having been completely displaced by Visual Studio 2008, which is almost 100% forward compatible with it. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread Joe Mistachkin
should work for cloning: http://system.data.sqlite.org/index.html/doc/trunk/www/source.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-17 Thread Joe Mistachkin
are using as that will allow all packages to load. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DB-Provider converts utc to local time during select, why??

2012-02-16 Thread Joe Mistachkin
Have you tried setting the (relatively new) DateTimeKind property in the connection string to Utc? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ADO.NET SQLite provider multi-threading question

2012-02-15 Thread Joe Mistachkin
; however, in the future, it may not. For example, we may need to use thread-local storage or some other mechanisms in the future that rely more strongly on the thread identity inside the implementation. -- Joe Mistachkin ___ sqlite-users mailing list sql

Re: [sqlite] ADO.NET SQLite provider multi-threading question

2012-02-15 Thread Joe Mistachkin
eally should follow the documentation and create the objects in the thread they are going to be used in. Please don't share the objects between threads. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] how can I make SQLite work on Mono multiplatform project?

2012-02-13 Thread Joe Mistachkin
Please see: http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Commit method not available

2012-02-12 Thread Joe Mistachkin
Kyle Cashion wrote: > > What am I missing? > You'll want to capture the return value of the SQLiteConnection.BeginTransaction method (which is the actual transaction) and then use the Commit and/or Rollback methods of that [SQLiteTransaction] object. -- Joe M

Re: [sqlite] VS2008 design support error

2012-02-10 Thread Joe Mistachkin
caeebd79?sbs=0 Please note that this issue does *NOT* exist for Visual Studio 2010 (and later) as it no longer requires a proper package load key. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VS2008 design support error

2012-02-10 Thread Joe Mistachkin
uld then allow all packages to load. Meanwhile, I'll look into getting a new package load key assigned for the package. Please note that this issue does *NOT* exist for Visual Studio 2010 as it no longer requires a proper package load key. -- Joe Mistachkin _

Re: [sqlite] SQLite .NET exception with parallel reading connections

2012-02-07 Thread Joe Mistachkin
That issue was fixed prior to release 1.0.77.0, here: http://system.data.sqlite.org/index.html/info/13a3981ec0 If possible, I recommend using the latest released version, 1.0.79.0. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite and EF and Generate DB from Model

2012-02-04 Thread Joe Mistachkin
inistrator privileges (i.e. in order to be able to write to a directory underneath "Program Files"). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]

2012-02-03 Thread Joe Mistachkin
rade-offs; however, that is why we provide support for both. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite via ADO.NET provider: Insufficient parameters supplied to the command

2012-02-03 Thread Joe Mistachkin
SQLiteParameter { ParameterName = "4", Value = 4 }); -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error 21 on Open (C#)

2012-02-03 Thread Joe Mistachkin
ely harmless and has been disabled in the most recent version of System.Data.SQLite. Also, it has nothing to do with not being able to open the database. RE: http://system.data.sqlite.org/index.html/info/3fc172d1be -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Saving tables from Visual Studio designer

2012-02-03 Thread Joe Mistachkin
I'll look into this issue later today; however, the Visual Studio Designer components are not feature complete and this functionality may simply be missing. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] FTS malformed MATCH expression: [( "a*" OR b*)]

2012-02-03 Thread Joe Mistachkin
of the following files and recompiling the SQLite.Interop project: /SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008) /SQLite.Interop/props/sqlite3.props (for VC++ 2010) Where is the root of the source tree for System.Data.SQLite. -- Joe Mistachkin

Re: [sqlite] Delegates with linq

2012-02-02 Thread Joe Mistachkin
Therefore, the solution here is to make sure that the first overload (the one with IEnumerable) is used when using the System.Data.SQLite LINQ provider. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Visual Studio 2010

2012-01-31 Thread Joe Mistachkin
you started: http://sqlite.phxsoftware.com/forums/p/76/266.aspx -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delegates with linq

2012-01-31 Thread Joe Mistachkin
since the underlying storage is of the "Id" column is text, it could be related to case sensitivity. Also, did you get the results you expect with a previous version of System.Data.SQLite? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] VS2008 design support error

2012-01-30 Thread Joe Mistachkin
Simon Slavin wrote: > > You might want to ask this on a forum about VS2010. There's apparently > nothing wrong with the SQLite element. > The designer components are part of System.Data.SQLite and are currently supported by me. -- Jo

Re: [sqlite] VS2008 design support error

2012-01-30 Thread Joe Mistachkin
Levi Haskell wrote: > > Is there a log file I can look up somewhere on the disk where I can > get more specific error from? > Yes, logging can be enabled as described in: http://blogs.msdn.com/b/dr._ex/archive/2006/12/14/debugging-package-load-fai lures.aspx -- Jo

Re: [sqlite] VS2008 design support error

2012-01-30 Thread Joe Mistachkin
eneric and can be caused by a variety of issues). One thought: Did you select the option (during the setup) to place the assemblies into the GAC? -- 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.79.0 released

2012-01-28 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] error installing (design support) for v1.0.78.0

2012-01-27 Thread Joe Mistachkin
s well. It has been fixed in the source tree and will be part of the next release (1.0.79.0), which will be out sometime tomorrow. Ticket is here (with workaround): http://system.data.sqlite.org/index.html/info/d8491abd0b -- Joe Mistachkin ___ sqlite-use

[sqlite] System.Data.SQLite version 1.0.78.0 released

2012-01-27 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.net download file

2012-01-27 Thread Joe Mistachkin
rosoft Corporation. All rights reserved. > Yeah, that version of gacutil clearly belongs to the .NET Framework 3.5 (based on the version number displayed in your message). You'll want to use the gacutil binary located in this directory: "C:\Program Files\Microsoft SDKs\Windows\v7.1\

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

2012-01-26 Thread Joe Mistachkin
th in the name of the module. Does this make > sense? Thanks, Joe > In order to see which managed assemblies a .NET-based application will require, you'll need to use the ILDASM tool from the .NET SDK: http://msdn.microsoft.com/en-us/library/f7dy01k1%28v=vs.80%29.as

Re: [sqlite] FirstOrDefault crashes using linq

2012-01-25 Thread Joe Mistachkin
://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.as px -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FirstOrDefault crashes using linq

2012-01-25 Thread Joe Mistachkin
Truls Haaland wrote: > > I am using the latest official version (1.0.77.0) on Windows7 with .NET 4.0. > > The full error message (including stack trace) is: > Would it be possible to see the generated SQL statement (from inside the Prepare method) that is causing the exc

Re: [sqlite] 3.7.10 build failure on OS X 10.4: ld: Undefined symbols:_OSAtomicCompareAndSwapPtrBarrier

2012-01-21 Thread Joe Mistachkin
(void * volatile *)&_sqliteZone_); + OSMemoryBarrier(); +#endif }while(!_sqliteZone_); if( !success ){ /* somebody registered a zone first */ malloc_destroy_zone(newzone); } -- Joe Mistachkin ___ sqlite-users mail

Re: [sqlite] Library run-time error

2012-01-20 Thread Joe Mistachkin
Please make sure the _WIN32_WINNT macro is defined in all your projects then (and for all build configurations). -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Library run-time error

2012-01-20 Thread Joe Mistachkin
ASURADA wrote: > > _WIN32_WINNT was defined by 0x0501 already. > It must be defined in the project that you are using to actually compile the SQLite source code (i.e. not just the project that uses the SQLite code, unless they are in fact the same project). -- Joe M

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

2012-01-19 Thread Joe Mistachkin
for SQLite into files named "SQLite.Interop.dll" and "System.Data.SQLite.dll" (mixed-mode assembly), depending on the build configuration. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net download file

2012-01-19 Thread Joe Mistachkin
entions as support for .net. > Which help file mentions this? Also, I'm not sure what is meant by "support for .net". I can only assume this refers to the managed (or mixed-mode) System.Data.SQLite assembly. -- Joe Mistachkin ___ sqlite-

Re: [sqlite] Library run-time error

2012-01-19 Thread Joe Mistachkin
ASURADA wrote: > > What's the problem. How to fix this problem. > (I use Visual C++ 2005 on Windows 7 x64) > In your project, please define the _WIN32_WINNT macro to 0x500 and try again. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] [sqlite-dev] System.Data.SQLite development

2012-01-18 Thread Joe Mistachkin
hat is a bug in Visual Studio itself. However, it only impacts browsing the source code from the IDE; building the projects works fine from the IDE or the command line via MSBuild. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http:

Re: [sqlite] memory fault in sqlite3_open_v2()

2012-01-18 Thread Joe Mistachkin
e Unicode APIs to be available and they will not be available unless the _WIN32_WINNT macro is properly defined. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] installation for .NET use

2012-01-18 Thread Joe Mistachkin
nd processor architecture (e.g. 32-bit/x86 or 64-bit/x64) you wish to use it with. Also, the version of "gacutil" (which is from the .NET SDK) used must be compatible with the .NET Framework you wish to use. -- Joe Mistachkin ___ sqlite-users mai

<    1   2   3   4   5   6   7   >