Re: [sqlite] Building System.Data.SQLite

[Bernhard Mogens Ege]

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

[Bernhard Mogens Ege]

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->->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

[Joe Mistachkin]

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

Re: [sqlite] Building System.Data.SQLite

[Joe Mistachkin]

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]

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]

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

[Joe Mistachkin]

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

[Bernhard Mogens Ege]

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

[Joe Mistachkin]

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
>
 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