Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5
These are the steps I had to perform: Install Visual Studio 2005. I was unable to successfully create a new solution platform based on another existing without VS2005 installed. In VS2008 create a new solution platform based on existing platform 'Pocket PC 2003 (ARMV4)'. The new solution platform should the the one you wish to target. We have from our CPU manufacturers received a Windows CE x86 .NET3.5 SDK that we use. Make sure that all project properties of SQLite.Interop.CE.2008 were copied to the new solution platform. On project properties of SQLite.Interop.CE.2008 change machine from 'ARM' to 'X86' in 'Configuration Properties' -> 'Linker' -> 'Command Line'. In sqlite3.c do the following changes, marked with [NEW]: [NEW] #define SQLITE_OS_WINCE 1 #define SQLITE_CORE 1 #define SQLITE_AMALGAMATION 1 #ifndef SQLITE_PRIVATE ... [NEW] #define HAVE_LOCALTIME_S 0 /* ** On recent Windows platforms, the localtime_s() function is available ** as part of the "Secure CRT". It is essentially equivalent to ** localtime_r() available under most POSIX platforms, except that the ** order of the parameters is reversed. ** ... [NEW] struct tm *__cdecl localtime(const time_t *t); /* ** The following routine implements the rough equivalent of localtime_r() ** using whatever operating-system specific localtime facility that ** is available. This routine returns 0 on success and ** non-zero on any kind of error. ** After these changes I was able to compile the project. /Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-13 18:19 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org I just realized that I'm missing a prerequisite for developing for the devices I'm dealing with. They're running a stripped WinCE load that my company didn't create, so I don't have the SDK that I need to compile for it. I'll have to contact the manufacturer in hopes of getting my hands on it. That does look hopeful, though. Did you just have to force those precompiler defines for it to compile properly? Thanks, Eric -Original Message- From: sqlite-users-boun...@sqlite.org [ mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 13 May, 2014 05:07 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 I finally managed to build SQLite using help from the following thread: http://sqlite.1065341.n5.nabble.com/Building-SQLite-on-Windows-Embedded-Compact-7-WEC7-td64722.html /Mattias From: Mattias Kindborg To: General Discussion of SQLite Database Date: 2014-05-12 10:58 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org I have found versions of the download page where ARM wasn't mentioned, e.g. http://system.data.sqlite.org/index.html/artifact/99229e8a9f2b261771735c32de22ae025292c01a . I thought the lack of mentioning ARM meant that x86 was supported. What do you think? /Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 17:45 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org It must have been, considering other software running on these WinCE 6 devices I have are using an older version of SQLite. They're not using .NET CF, though. I can't find an ftp archive (or any archive) of older versions of the System.Data.SQLite libraries. Have you found one, by any chance? -- Eric -Original Message- From: sqlite-users-boun...@sqlite.org [ mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 9 May, 2014 06:03 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Hi Eric. Then I guess it was a conscious decision to drop support for x86 with .NET CF 3.5, becuse I think it has been supported in olver versions of SQLite? Best regards, Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 14:43 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric > On May 9, 2014, at 1:02 AM, "Mattias Kindborg" wrote: > > Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the > download site for System.Data.SQLite
Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5
I finally managed to build SQLite using help from the following thread: http://sqlite.1065341.n5.nabble.com/Building-SQLite-on-Windows-Embedded-Compact-7-WEC7-td64722.html /Mattias From: Mattias Kindborg To: General Discussion of SQLite Database Date: 2014-05-12 10:58 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org I have found versions of the download page where ARM wasn't mentioned, e.g. http://system.data.sqlite.org/index.html/artifact/99229e8a9f2b261771735c32de22ae025292c01a . I thought the lack of mentioning ARM meant that x86 was supported. What do you think? /Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 17:45 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org It must have been, considering other software running on these WinCE 6 devices I have are using an older version of SQLite. They're not using .NET CF, though. I can't find an ftp archive (or any archive) of older versions of the System.Data.SQLite libraries. Have you found one, by any chance? -- Eric -Original Message- From: sqlite-users-boun...@sqlite.org [ mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 9 May, 2014 06:03 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Hi Eric. Then I guess it was a conscious decision to drop support for x86 with .NET CF 3.5, becuse I think it has been supported in olver versions of SQLite? Best regards, Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 14:43 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric > On May 9, 2014, at 1:02 AM, "Mattias Kindborg" wrote: > > Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the > download site for System.Data.SQLite ( > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) it > seems that only ARM is supported. > > Best regards, > Mattias Kindborg > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5
I have found versions of the download page where ARM wasn't mentioned, e.g. http://system.data.sqlite.org/index.html/artifact/99229e8a9f2b261771735c32de22ae025292c01a . I thought the lack of mentioning ARM meant that x86 was supported. What do you think? /Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 17:45 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org It must have been, considering other software running on these WinCE 6 devices I have are using an older version of SQLite. They're not using .NET CF, though. I can't find an ftp archive (or any archive) of older versions of the System.Data.SQLite libraries. Have you found one, by any chance? -- Eric -Original Message- From: sqlite-users-boun...@sqlite.org [ mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 9 May, 2014 06:03 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Hi Eric. Then I guess it was a conscious decision to drop support for x86 with .NET CF 3.5, becuse I think it has been supported in olver versions of SQLite? Best regards, Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 14:43 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric > On May 9, 2014, at 1:02 AM, "Mattias Kindborg" wrote: > > Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the > download site for System.Data.SQLite ( > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) it > seems that only ARM is supported. > > Best regards, > Mattias Kindborg > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5
Hi Eric. Then I guess it was a conscious decision to drop support for x86 with .NET CF 3.5, becuse I think it has been supported in olver versions of SQLite? Best regards, Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-09 14:43 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric > On May 9, 2014, at 1:02 AM, "Mattias Kindborg" wrote: > > Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the > download site for System.Data.SQLite ( > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) it > seems that only ARM is supported. > > Best regards, > Mattias Kindborg > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5
Doesn't SQLite have support for Windows CE x86 with .NET3.5? On the download site for System.Data.SQLite ( http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) it seems that only ARM is supported. Best regards, Mattias Kindborg ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users