Re: [sqlite] Building System.Data.SQLite
I was referencing C:\Program Files (x86)\System.Data.SQLite\2010\bin\System.Data.SQLite.dll is this was the one shown in the VS2010-Project-Add Reference-.NET section. I removed that reference and added a reference to C:\Program Files\System.Data.SQLite\2010\bin\System.Data.SQLite.dll instead. This worked as intended. Why is VS2010 only showing x86 references in .NET section of the Add Reference browser? My project is targetted Any CPU, but I have tried x86 and x64 but neither worked with C:\Program Files (x86)\System.Data.SQLite\2010\bin\System.Data.SQLite.dll Anyway, it works and that is great. :) The old-school dll hell is easier to make sense of than the .NET dll hell. :-P -- Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 14. august 2012 00:19 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite Bernhard Mogens Ege wrote: This doesn't appear to build everything needed as when I install the bundles (x86 and x64), nothing is added to the global assembly cache in C:\windows\assembly\ (did ask the installer to add to the GAC), making every binary using System.Data.SQLite fail. The files are put into C:\Program Files\.. as expected, though, but binaries do not know to look there. Installing the System.Data.SQLite DLLs in the GAC is not normally recommended. Instead, they should probably be installed along side the application binaries (i.e. app-local). Setting a reference to the managed (or mixed-mode) assembly for System.Data.SQLite is normally all that is required to make the applications work as the DLL should then automatically be copied to the build output directory. If you have Visual Studio 2010, then you may want to look into using the official NuGet package for System.Data.SQLite, seen here: http://nuget.org/packages/System.Data.SQLite Also, the Designer adding for VS2010 isn't working properly as it isn't possible to enter a path with a space in it (Illegal sharacters in path.), making the VS addin a no-go. This is a quite annoying error which makes it very difficult for me to modify my sqlite models; close all VS2010, remove sqlite 1.0.82.0, possibly reboot, install 1.0.81.0 incl. VS plugin, start vs2010 and load my project, modify my sqlite model, close vs2010, uninstall 1.0.81.0, possibly reboot, install 1.0.82.0, start and load my project, test, continue programming. Maybe I can just use the Designer.dll from 1.0.81.0 with the rest from 1.0.82.0? That would be worth a try. The designer components are a bit tricky to get working right, even in the best of circumstances. They actually *do* require the setup package be run in order to operate properly. Also, since Visual Studio is always a 32-bit native application, that setup package is the one that must be used. Here is the direct link to the correct package: http://system.data.sqlite.org/downloads/1.0.81.0/sqlite-netFx40-setup-bundle -x86-2010-1.0.81.0.exe -- Joe Mistachkin ___ 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] Building System.Data.SQLite
Regarding the Designer and the must-not-use-space-in-filenames problem, I ended up using the 8.3 filename of the folder having the space in it. (Visual Studio 2010 - Visual~1) The Designer source for 1.0.81.0 seems to be the same as 1.0.82.0 so both would error on this space. The difference most likely is in System.Data.SQLite itself (SQLiteConnection.cs) but while I have looked at the source, I didn't find the actual error. I'll use my workaround for the time being. This is just the GUI in VS2010 acting up. When building my own connection string in my project, I can use spaces in filenames without problems. -- Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 14. august 2012 00:19 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite Bernhard Mogens Ege wrote: This doesn't appear to build everything needed as when I install the bundles (x86 and x64), nothing is added to the global assembly cache in C:\windows\assembly\ (did ask the installer to add to the GAC), making every binary using System.Data.SQLite fail. The files are put into C:\Program Files\.. as expected, though, but binaries do not know to look there. Installing the System.Data.SQLite DLLs in the GAC is not normally recommended. Instead, they should probably be installed along side the application binaries (i.e. app-local). Setting a reference to the managed (or mixed-mode) assembly for System.Data.SQLite is normally all that is required to make the applications work as the DLL should then automatically be copied to the build output directory. If you have Visual Studio 2010, then you may want to look into using the official NuGet package for System.Data.SQLite, seen here: http://nuget.org/packages/System.Data.SQLite Also, the Designer adding for VS2010 isn't working properly as it isn't possible to enter a path with a space in it (Illegal sharacters in path.), making the VS addin a no-go. This is a quite annoying error which makes it very difficult for me to modify my sqlite models; close all VS2010, remove sqlite 1.0.82.0, possibly reboot, install 1.0.81.0 incl. VS plugin, start vs2010 and load my project, modify my sqlite model, close vs2010, uninstall 1.0.81.0, possibly reboot, install 1.0.82.0, start and load my project, test, continue programming. Maybe I can just use the Designer.dll from 1.0.81.0 with the rest from 1.0.82.0? That would be worth a try. The designer components are a bit tricky to get working right, even in the best of circumstances. They actually *do* require the setup package be run in order to operate properly. Also, since Visual Studio is always a 32-bit native application, that setup package is the one that must be used. Here is the direct link to the correct package: http://system.data.sqlite.org/downloads/1.0.81.0/sqlite-netFx40-setup-bundle -x86-2010-1.0.81.0.exe -- Joe Mistachkin ___ 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] Building System.Data.SQLite
The suggested command did create the win32 setup for me, but I'd also like the x64 setup and this replaced: set_Release_x86_2010.bat with set_Release_x64_2010.bat and build again. This however also build the x86 target for some reason and no x64 setup file is produced (bake fails, complaining about missing x64 files). Can I install something that would make the whole build complete without having VS2008? Seems this is the easiest way, short of decoding all the bat files for their meaning. -- Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 10. august 2012 19:01 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite Bernhard Mogens Ege wrote: I have been looking at https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki to build System.Data.SQLite https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki%20to%20b uild%20System.Data.SQLite but when using the manual build, I do not get the setup files built.. The setup packages are created using Inno Setup, an open source tool available here: http://www.jrsoftware.org/ Once that tool is installed, the Setup\bake*.bat tools may be used to build the setup packages for System.Data.SQLite. Various other batch files in that same directory contain the environment variable settings needed by these tools. Then I use the automated build and follow the steps which work fine until step 11: bake_all.bat that complains about: Could not bake setup for Release/x86/2008. The bake_all.bat tool assumes that binaries have been built for all supported platforms and framework versions. When that is not the case, the bake.bat tool may be used instead. However, that tool is a bit more complex because it was not really intended to be called directly from the command line. Here is an example that will build the setup using the .NET 4.0-based setup for x86 (this assumes that the build.bat tool already completed successfully): CD /D %ROOT%\Setup vsSp.bat set_common.bat set_Release_x86_2010.bat bake.bat -- Joe Mistachkin ___ 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] Building System.Data.SQLite
Bernhard Mogens Ege wrote: This however also build the x86 target for some reason and no x64 setup file is produced (bake fails, complaining about missing x64 files). This means that the x64 binaries were not built first using build.bat. You should be able to build binaries for all supported platforms and versions of Visual Studio (as installed on your box) by making use of the build_all.bat tool instead. Can I install something that would make the whole build complete without having VS2008? Seems this is the easiest way, short of decoding all the bat files for their meaning. With the exception of the Visual Studio designer integration components, there is nothing really to install, per se. In fact, it is very highly recommended that the deployment of the System.Data.SQLite DLL and related components be done on an app-local basis, with the GAC being avoided altogether. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Building System.Data.SQLite
But I did use build.bat after using set_Release_x64_2010.bat. This is what is so strange. Build_all.bat fails as it seems vsSp.bat detects that I have VS2008 installed, but this is installed by SQL 2008 R2 and lacks pretty much everything (used for business intelligence design only and has no C#/C++ compiler). I looked closer at build_all.bat and ended up with these commands that created the 2010 Win32/x64 setup files: SET YEARS=2010 Build_all.bat Bake_all.bat This seems to have made the build system skip the VS2008 generation completely and without errors, but I am not certain it is a safe way to do it (seems so, though). Final question: what is the difference between the bundle and non-bundle setup files? I tried viewing the download page but I cannot view it. I only get the About wiki page. I tried Firefox, Opera, Chrome and IE9 and none of them could show the download page. Cheers, Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 13. august 2012 11:51 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite Bernhard Mogens Ege wrote: This however also build the x86 target for some reason and no x64 setup file is produced (bake fails, complaining about missing x64 files). This means that the x64 binaries were not built first using build.bat. You should be able to build binaries for all supported platforms and versions of Visual Studio (as installed on your box) by making use of the build_all.bat tool instead. Can I install something that would make the whole build complete without having VS2008? Seems this is the easiest way, short of decoding all the bat files for their meaning. With the exception of the Visual Studio designer integration components, there is nothing really to install, per se. In fact, it is very highly recommended that the deployment of the System.Data.SQLite DLL and related components be done on an app-local basis, with the GAC being avoided altogether. -- Joe Mistachkin ___ 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] Building System.Data.SQLite
This doesn't appear to build everything needed as when I install the bundles (x86 and x64), nothing is added to the global assembly cache in C:\windows\assembly\ (did ask the installer to add to the GAC), making every binary using System.Data.SQLite fail. The files are put into C:\Program Files\.. as expected, though, but binaries do not know to look there. Also, the Designer adding for VS2010 isn't working properly as it isn't possible to enter a path with a space in it (Illegal sharacters in path.), making the VS addin a no-go. This is a quite annoying error which makes it very difficult for me to modify my sqlite models; close all VS2010, remove sqlite 1.0.82.0, possibly reboot, install 1.0.81.0 incl. VS plugin, start vs2010 and load my project, modify my sqlite model, close vs2010, uninstall 1.0.81.0, possibly reboot, install 1.0.82.0, start and load my project, test, continue programming. Maybe I can just use the Designer.dll from 1.0.81.0 with the rest from 1.0.82.0? That would be worth a try. This is getting a bit difficult for me to solve. :-/ -- Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Bernhard Mogens Ege Sent: 13. august 2012 12:32 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite But I did use build.bat after using set_Release_x64_2010.bat. This is what is so strange. Build_all.bat fails as it seems vsSp.bat detects that I have VS2008 installed, but this is installed by SQL 2008 R2 and lacks pretty much everything (used for business intelligence design only and has no C#/C++ compiler). I looked closer at build_all.bat and ended up with these commands that created the 2010 Win32/x64 setup files: SET YEARS=2010 Build_all.bat Bake_all.bat This seems to have made the build system skip the VS2008 generation completely and without errors, but I am not certain it is a safe way to do it (seems so, though). Final question: what is the difference between the bundle and non-bundle setup files? I tried viewing the download page but I cannot view it. I only get the About wiki page. I tried Firefox, Opera, Chrome and IE9 and none of them could show the download page. Cheers, Bernhard -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: 13. august 2012 11:51 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Building System.Data.SQLite Bernhard Mogens Ege wrote: This however also build the x86 target for some reason and no x64 setup file is produced (bake fails, complaining about missing x64 files). This means that the x64 binaries were not built first using build.bat. You should be able to build binaries for all supported platforms and versions of Visual Studio (as installed on your box) by making use of the build_all.bat tool instead. Can I install something that would make the whole build complete without having VS2008? Seems this is the easiest way, short of decoding all the bat files for their meaning. With the exception of the Visual Studio designer integration components, there is nothing really to install, per se. In fact, it is very highly recommended that the deployment of the System.Data.SQLite DLL and related components be done on an app-local basis, with the GAC being avoided altogether. -- Joe Mistachkin ___ 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] Building System.Data.SQLite
Bernhard Mogens Ege wrote: Build_all.bat fails as it seems vsSp.bat detects that I have VS2008 installed, but this is installed by SQL 2008 R2 and lacks pretty much everything (used for business intelligence design only and has no C#/C++ compiler). Yeah, the Visual Studio detection logic in the batch file tools is somewhat limited. I looked closer at build_all.bat and ended up with these commands that created the 2010 Win32/x64 setup files: SET YEARS=2010 Build_all.bat Bake_all.bat Those commands seem perfectly reasonable to me. In fact, the YEARS environment variable *is* designed to be overridden in such a manner just in case the Visual Studio detection logic will not work correctly on a particular machine. This seems to have made the build system skip the VS2008 generation completely and without errors, but I am not certain it is a safe way to do it (seems so, though). Yes, this should be fine. Final question: what is the difference between the bundle and non-bundle setup files? I tried viewing the download page but I cannot view it. I only get the About wiki page. I tried Firefox, Opera, Chrome and IE9 and none of them could show the download page. The bundle packages contain the mixed-mode assembly, which itself contains both the native and managed code used for interacting with SQLite. The non-bundle packages contain separate native and managed assemblies that are used together to interact with SQLite. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Building System.Data.SQLite
Bernhard Mogens Ege wrote: This doesn't appear to build everything needed as when I install the bundles (x86 and x64), nothing is added to the global assembly cache in C:\windows\assembly\ (did ask the installer to add to the GAC), making every binary using System.Data.SQLite fail. The files are put into C:\Program Files\.. as expected, though, but binaries do not know to look there. Installing the System.Data.SQLite DLLs in the GAC is not normally recommended. Instead, they should probably be installed along side the application binaries (i.e. app-local). Setting a reference to the managed (or mixed-mode) assembly for System.Data.SQLite is normally all that is required to make the applications work as the DLL should then automatically be copied to the build output directory. If you have Visual Studio 2010, then you may want to look into using the official NuGet package for System.Data.SQLite, seen here: http://nuget.org/packages/System.Data.SQLite Also, the Designer adding for VS2010 isn't working properly as it isn't possible to enter a path with a space in it (Illegal sharacters in path.), making the VS addin a no-go. This is a quite annoying error which makes it very difficult for me to modify my sqlite models; close all VS2010, remove sqlite 1.0.82.0, possibly reboot, install 1.0.81.0 incl. VS plugin, start vs2010 and load my project, modify my sqlite model, close vs2010, uninstall 1.0.81.0, possibly reboot, install 1.0.82.0, start and load my project, test, continue programming. Maybe I can just use the Designer.dll from 1.0.81.0 with the rest from 1.0.82.0? That would be worth a try. The designer components are a bit tricky to get working right, even in the best of circumstances. They actually *do* require the setup package be run in order to operate properly. Also, since Visual Studio is always a 32-bit native application, that setup package is the one that must be used. Here is the direct link to the correct package: http://system.data.sqlite.org/downloads/1.0.81.0/sqlite-netFx40-setup-bundle -x86-2010-1.0.81.0.exe -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Building System.Data.SQLite
I have been looking at https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki to build System.Data.SQLite https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki%20to%20b uild%20System.Data.SQLite but when using the manual build, I do not get the setup files built.. Then I use the automated build and follow the steps which work fine until step 11: bake_all.bat that complains about: Could not bake setup for Release/x86/2008. Apparently, the 2008 files aren't built which is reasonable as I do not have VS2008. I have looked at some of the bat files, but I am not sure what the correct path to build Win32/x64 files for VS2010 is (including Designer). Any inside knowledge? -- Bernhard ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Building System.Data.SQLite
Bernhard Mogens Ege wrote: I have been looking at https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki to build System.Data.SQLite https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki%20to%20b uild%20System.Data.SQLite but when using the manual build, I do not get the setup files built.. The setup packages are created using Inno Setup, an open source tool available here: http://www.jrsoftware.org/ Once that tool is installed, the Setup\bake*.bat tools may be used to build the setup packages for System.Data.SQLite. Various other batch files in that same directory contain the environment variable settings needed by these tools. Then I use the automated build and follow the steps which work fine until step 11: bake_all.bat that complains about: Could not bake setup for Release/x86/2008. The bake_all.bat tool assumes that binaries have been built for all supported platforms and framework versions. When that is not the case, the bake.bat tool may be used instead. However, that tool is a bit more complex because it was not really intended to be called directly from the command line. Here is an example that will build the setup using the .NET 4.0-based setup for x86 (this assumes that the build.bat tool already completed successfully): CD /D %ROOT%\Setup vsSp.bat set_common.bat set_Release_x86_2010.bat bake.bat -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
