Thanks Chris! I'm using .Net 4.6 (VS 2017), which I don't think works with System.Data.SQLite yet, so I downgraded to .net 4.5.2. Seems to be working fine.
Please tell me about your classes. I'm using EF6. -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of sqlite-users-requ...@mailinglists.sqlite.org Sent: Friday, June 23, 2017 8:00 AM To: sqlite-users@mailinglists.sqlite.org Subject: sqlite-users Digest, Vol 114, Issue 23 Send sqlite-users mailing list submissions to sqlite-users@mailinglists.sqlite.org To subscribe or unsubscribe via the World Wide Web, visit http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users or, via email, send a message with subject or body 'help' to sqlite-users-requ...@mailinglists.sqlite.org You can reach the person managing the list at sqlite-users-ow...@mailinglists.sqlite.org When replying, please edit your Subject line so it is more specific than "Re: Contents of sqlite-users digest..." Today's Topics: 1. 3 fixes for 3.19.3 (Danny Couture) 2. Could not load file or assembly error (Paul J. McMillan, Sr.) 3. User Authentication Extension is broken in 3.19 branch (Thien, Christoph) 4. Re: UTF8-BOM not disregarded in CSV import (Clemens Ladisch) 5. Re: Could not load file or assembly error (Chris Locke) ---------------------------------------------------------------------- Message: 1 Date: Thu, 22 Jun 2017 13:30:46 -0400 From: Danny Couture <couture.da...@gmail.com> To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] 3 fixes for 3.19.3 Message-ID: <CAMBrY1EtGe6-SVQbnLV=p=ekkpk14kjkghhzix7kzpkhun4...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I’d like to submit 2 compilation fixes https://github.com/dcou/sqlite/commit/be48df67c63d8db221c2ae3ac3b49b93760460e7.patch https://github.com/dcou/sqlite/commit/3f8d8d9b743e247bba15dd2b82b5dc26ac915a44.patch and one regression fix for 3.19.3 https://github.com/dcou/sqlite/commit/c93d35b54213049c86be76b8d0e74948fecfbf4b.patch Thanks Danny ------------------------------ Message: 2 Date: Thu, 22 Jun 2017 13:50:42 -0400 From: "Paul J. McMillan, Sr." <pjm0...@gmail.com> To: <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] Could not load file or assembly error Message-ID: <009601d2eb80$122c7390$36855ab0$@gmail.com> Content-Type: text/plain; charset="us-ascii" Hi, I'm new to SQLite. I want to use it in my C# application. I downloaded the tool SQLite/SQL Server Compact Toolbox. Under Data Connections, I keep getting the error message in red: "Could not load file or assembly 'SQLiteScripting". Does anyone have an idea of why I'm getting this error? Thanks Paul McMillan ------------------------------ Message: 3 Date: Fri, 23 Jun 2017 06:34:40 +0000 From: "Thien, Christoph" <christoph.th...@bruker.com> To: "sqlite-users@mailinglists.sqlite.org" <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] User Authentication Extension is broken in 3.19 branch Message-ID: <a04201891d744c5ca2dd835ee4eb2659@bruexc102.brumgt.local> Content-Type: text/plain; charset="us-ascii" Hi all, we are compiling and using the User Authentication extension (Windows, MSVC10 and MSVC14, x86 and amd64). Problem: In 3.19 branch one can access a database without authentication. Example: When using sqlite 3.12 series (e.g. 3.12.2) everything works like expected. One can do: sqlite3.exe db .user add admin pwd 1 .user login admin pwd create table mytable (col1 int); insert into mytable values (1); .quit Starting again sqlite3.exe db select * from mytable; Error: user not authenticated This error message is expected. In 3.19 branch (3.19.2 and 3.19.3) you get this: sqlite3.exe db select * from mytable; 1 Access without authentication. Is this a regression? The user authentication extension source code did not change so far. Best regards, Christoph Thien Bruker Optik GmbH ------------------------------ Message: 4 Date: Fri, 23 Jun 2017 09:25:50 +0200 From: Clemens Ladisch <clem...@ladisch.de> To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] UTF8-BOM not disregarded in CSV import Message-ID: <1fe8cb2c-b012-13f1-d8ab-7b26c4df4...@ladisch.de> Content-Type: text/plain; charset=utf-8 Mahmoud Al-Qudsi wrote: > with `.import ……`, SQLite3 includes a BOM (UTF-8) as part of the first > column of the first record. The Unicode Standard 9.0 says in section 3.10: | When represented in UTF-8, the byte order mark turns into the byte | sequence <EF BB BF>. Its usage at the beginning of a UTF-8 data stream | is neither required nor recommended by the Unicode Standard, so you should not use it. Treating this character as a zero width no-break space, and keeping it, is a correct interpretation of the file. > IMHO, this is of particular importance since the latest versions of MS > Excel default to “UTF-8 CSV” which includes a BOM. That's wrong: | When converting between different encoding schemes, extreme care must | be taken in handling any initial byte order marks. For example, if one | converted a UTF-16 byte serialization with an initial byte order mark | to a UTF-8 byte serialization, thereby converting the byte order mark | to <EF BB BF> in the UTF-8 form, the <EF BB BF> would now be ambiguous | as to its status as a byte order mark (from its source) or as an | initial zero width no-break space. If the UTF-8 byte serialization | were then converted to UTF-16BE and the initial <EF BB BF> were | converted to <FE FF>, the interpretation of the U+FEFF character would | have been modified by the conversion. This would be nonconformant | behavior according to conformance clause C7, because the change | between byte serializations would have resulted in modification of the | interpretation of the text. This is one reason why the use of the | initial byte sequence <EF BB BF> as a signature on UTF-8 byte | sequences is not recommended by the Unicode Standard. And Google Docs also thinks it would be a good idea to act against this recommendation: <https://productforums.google.com/forum/#!topic/docs/p_jCTwzuIqk> > Would anyone be opposed to a patch to SQLite that disregarded a BOM > when found during a csv import operation? Well, being wrong doesn't mean that Microsoft or Google will change their behaviour ... Regards, Clemens ------------------------------ Message: 5 Date: Fri, 23 Jun 2017 10:13:43 +0100 From: Chris Locke <sql...@chrisjlocke.co.uk> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Could not load file or assembly error Message-ID: <cadaml0jnvodd8dbz0f3dxx+stapsyqxljgj5df-yym0ws67...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I'd recommend the system.data.sqite.dll wrapper http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki This is a .Net component which works very well with SQLite databases.There are a plethora of downloads, which can seem daunting. Depending on your .Net flavour you're working with (I assume 4.5.1) I recommend the ' *sqlite-netFx451-binary-Win32-2013-1.0.105.2.zip*' download. If you're new to SQLite, I've written a number of SQLite classes which can be useful building a DB application... a wrapper around the wrapper, so to speak..... ;) Thanks, Chris On Thu, Jun 22, 2017 at 6:50 PM, Paul J. McMillan, Sr. <pjm0...@gmail.com> wrote: > Hi, > > > > I'm new to SQLite. I want to use it in my C# application. I > downloaded the tool SQLite/SQL Server Compact Toolbox. Under Data > Connections, I keep getting the error message in red: "Could not load > file or assembly 'SQLiteScripting". Does anyone have an idea of why > I'm getting this error? > > > > Thanks > > Paul McMillan > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ------------------------------ Subject: Digest Footer _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ------------------------------ End of sqlite-users Digest, Vol 114, Issue 23 ********************************************* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
