Thank you for your really specific answer, I will go to the IoT forum, insider, etc to make the request.
-----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Howard Kapustein Sent: 28 June 2015 19:08 To: 'General Discussion of SQLite Database' Subject: [sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue SQLite uses CreateFile2 in a Windows store aka UWP application https://msdn.microsoft.com/en-us/library/windows/desktop/hh449422(v=vs.85).aspx When called from a Windows Store app, CreateFile2 is simplified. You can open only files or directories inside the ApplicationData.LocalFolder or Package.InstalledLocation directories. It can't open files in other locations, such as removable media. This is an interesting request, but it's really a limitation of Windows. UWP apps using SQLite can't access databases on removable media until CreateFile2 changes (or an alternative is provided). - Howard This email may contain confidential and privileged information.? Any unauthorized use is prohibited.? If you are not the intended recipient, please contact the? sender by reply email and destroy all copies of the original message. -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of sqlite-users-requ...@mailinglists.sqlite.org Sent: Sunday, June 28, 2015 9:00 AM To: sqlite-users at mailinglists.sqlite.org Subject: sqlite-users Digest, Vol 90, Issue 27 Send sqlite-users mailing list submissions to sqlite-users at 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-request at mailinglists.sqlite.org You can reach the person managing the list at sqlite-users-owner at 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. RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue (Juan Pablo Garc?a Coello) 2. Re: RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue (Scott Doctor) 3. Re: RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue (Juan Pablo Garc?a Coello) ---------------------------------------------------------------------- Message: 1 Date: Sat, 27 Jun 2015 16:37:19 +0000 From: Juan Pablo Garc?a Coello <juanpa...@expediteapps.com> To: "sqlite-users at mailinglists.sqlite.org" <sqlite-users at mailinglists.sqlite.org> Subject: [sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue Message-ID: <414DD1207A7EA3409BAA064DBD728BE038A8A46F at ORD2MBX05C.mex05.mlsrvr.com> Content-Type: text/plain; charset="gb2312" I have tested a SQLite database with the typical, working like a charm: Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.dat"); I wanted to create the database in an external storage, to do that I need to add the following steps: 1.- Add Capability to use removablestorage. 2.- Add file type association in order to have rights to manage that kind of files (The details here: http://expediteapps.com/blog/data-logger-with-windows-10-iot-in-progress/) So then I change the path to the removable storage path like ?E:\db.dat? and it always tells CannotOpen. (I can work with text .dat files without issues.) The SQLite library PCL It arrives to here: SQLiteApiWinRT.cs public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)SQLite3.Open(filename, out internalDbHandle, flags, zvfs); db = new DbHandle(internalDbHandle); return ret; } Where Open is [DllImport("sqlite3", EntryPoint = "sqlite3_open_v2", CallingConvention = CallingConvention.Cdecl)] public static extern Result Open(byte[] filename, out IntPtr db, int flags, IntPtr zvfs); where I am using: SQLite.UAP.2015, Version=3.8.10 And here is where the road ends, any help? I do not know in where the string is converter to storagefile or whatever way is accessing to the file, any clues? NOTE: I have used ??????? ??????? Libraries too, arriving to the same point, so I can assure that is internal, but I do not know how to continue. Thank you! Juan Pablo Garcia Coello Co-Founder & CTO www.expediteapps.com www.expediteapps.com/blog ------------------------------ Message: 2 Date: Sat, 27 Jun 2015 10:10:56 -0700 From: Scott Doctor <sc...@scottdoctor.com> To: General Discussion of SQLite Database <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue Message-ID: <558ED920.4020502 at scottdoctor.com> Content-Type: text/plain; charset=gbk; format=flowed On 6/27/2015 9:37 AM, Juan Pablo Garc?a Coello wrote: > path to the removable storage path like ??E:\db.dat?? and it always tells > CannotOpen. Your email is using charse gb2312 which is a Chinese character set. four of the characters are not mapping to UTF-8 properly. A problem may be that you are passing invalid UTF-8 to SQLite which may be causing the inability to open the file. the invalid characters are 0x3f ox3f which is not a valid UTF-8 sequence. ------------ Scott Doctor scott at scottdoctor.com ------------------ ------------------------------ Message: 3 Date: Sat, 27 Jun 2015 17:27:04 +0000 From: Juan Pablo Garc?a Coello <juanpa...@expediteapps.com> To: General Discussion of SQLite Database <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue Message-ID: <414DD1207A7EA3409BAA064DBD728BE038A8A4A1 at ORD2MBX05C.mex05.mlsrvr.com> Content-Type: text/plain; charset="iso-8859-1" Sorry that where the Spanish quotation it is just E:\db.dat. if there is any strange char it is about the email not the code. I can assure that is not just a newbie issue, it is more complex I think it has to be something with permissions or how internally looks for the file. -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Scott Doctor Sent: 27 June 2015 18:11 To: General Discussion of SQLite Database Subject: Re: [sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue On 6/27/2015 9:37 AM, Juan Pablo Garc?a Coello wrote: > path to the removable storage path like ??E:\db.dat?? and it always tells > CannotOpen. Your email is using charse gb2312 which is a Chinese character set. four of the characters are not mapping to UTF-8 properly. A problem may be that you are passing invalid UTF-8 to SQLite which may be causing the inability to open the file. the invalid characters are 0x3f ox3f which is not a valid UTF-8 sequence. ------------ Scott Doctor scott at scottdoctor.com ------------------ ------------------------------ _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users End of sqlite-users Digest, Vol 90, Issue 27 ******************************************** _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
