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
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
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
rom the configuration file?
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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
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:
ection("Data Source=:memory:;");
cnn.Open();
using (SQLiteCommand cmd = new SQLiteCommand(
"SELECT * FROM sqlite_master;", cnn))
{
using (SQLiteDataReader reader = cmd.ExecuteRea
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
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
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
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
.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
___
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
/ 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
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
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.
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
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
. 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
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
rt to try it.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
___
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:
>
>
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
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
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
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
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
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
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
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
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
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
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
he mode for use with System.Data.SQLite is
something that is being considered.
--
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
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
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
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
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
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
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
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
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
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
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
5387
a4f40b7
And for Windows Phone 8.1:
https://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2
af75d1b
--
Joe Mistachkin
ads/1.0.94.0/sqlite-netFx40-setup-bundl
e-x86-2010-1.0.94.0.exe
--
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
download page.
Do you have any other specific suggestions on how to improve the usability
and/or readability of the download page?
--
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
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
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
ries on Windows?
https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6
--
Joe Mistachkin
port. This should now be fixed on trunk.
--
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
.
Are you able to provide an example UTF-8 byte sequence that demonstrates
the problem when passed into the SQLite C API?
--
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
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
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
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
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
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
.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
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
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
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
Michal wrote:
>
> The table does have a Primary Key.
>
Can you share the complete schema of the table involved?
--
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
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
on the SQLite mailing list (sqlite-users at sqlite.org) if you
encounter any problems with this release.
--
Joe Mistachkin
What file system is being used on the drive in question (e.g. FAT, FAT32,
NTFS, etc)?
--
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
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
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
I just updated the documentation with more details, here:
https://system.data.sqlite.org/index.html/ci/4be7ad3120577d30?sbs=0
--
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
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 "
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
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
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
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
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
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
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
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
.
>
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
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
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
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
) 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.
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
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://
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
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
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
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
next Friday, December 20th.
Thanks.
--
Joe Mistachkin
___
sqlite-users mailing
1 - 100 of 659 matches
Mail list logo