System.Data.SQLite

View Ticket
Login
Attach Edit New Ticket Plaintext
2012-01-28
11:37 • Closed ticket [d8491abd0b]: Installer Error plus 2 other changes artifact: 6a5b439105 user: mistachkin
2012-01-27
22:35 • Ticket [d8491abd0b]: 5 changes artifact: e89fe76c25 user: mistachkin
22:30 • Ticket [d8491abd0b]: 1 change artifact: 22adda86b8 user: mistachkin
20:26 • Ticket [d8491abd0b]: 1 change artifact: afaee54658 user: mistachkin
19:39 • Ticket [d8491abd0b]: 1 change artifact: 07a82a785e user: mistachkin
19:10
Merge all VS designer component installer fixes to trunk. Fix for [d8491abd0b]. check-in: 8801443206 user: mistachkin tags: trunk
15:54 • Pending ticket [d8491abd0b]: Installer Error plus 1 other change artifact: 3c64a1dc8f user: mistachkin
15:53
Make the VS designer component installer aware of the WoW64 subsystem on 64-bit Windows. See ticket [d8491abd0b]. check-in: 13e7a22c1e user: mistachkin tags: tkt-d8491abd0b
15:52 • Ticket [d8491abd0b] Installer Error status still Open with 1 other change artifact: a024dbca92 user: mistachkin
15:50 • Ticket [d8491abd0b]: 1 change artifact: 3a7c30fa11 user: mistachkin
15:09 • Ticket [d8491abd0b]: 1 change artifact: cfb6e1620f user: anonymous
14:12 • Ticket [d8491abd0b]: 1 change artifact: 0fd948572f user: mistachkin
14:10 • Ticket [d8491abd0b]: 1 change artifact: 08eaf107ed user: mistachkin
13:58 • Ticket [d8491abd0b]: 4 changes artifact: f46de89396 user: mistachkin
12:17 • Ticket [d8491abd0b]: 4 changes artifact: c31187b8dc user: anonymous
12:09 • New ticket [d8491abd0b]. artifact: 9a3df2daa7 user: anonymous
Ticket Hash: d8491abd0bcb73694388d4d077042c8b0169b871
Title: Installer Error
Status: Closed Type: Code_Defect
Severity: Important Priority: NextRelease
Subsystem: VsDesignerInstaller Resolution: Fixed
Last Modified: 2012-01-28 11:37:20
Version Found In: 1.0.78.0
Description:
sqlite-netFx40-setup-bundle-x64-2010-1.0.78.0

At install the following error occurs -> could not open registry key: HKEY_LOCAL_MACHINE\Software\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx

.NET 4.0 is fully installed and in the opened commandline window the error seems to be at Installer.exe #38

After the Setup in Server-Explorer no SQLite Database Connection could be created.

anonymous added on 2012-01-27 12:17:14 UTC:
Further investigation: It seems that under X64 the Registry path needed is-> HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx

mistachkin added on 2012-01-27 14:10:33 UTC:
As a temporary workaround (for VS 2010), you could do the following steps:

1. Install the 32-bit setup without the option checked to run the VS designer components installer.

2. Open a Visual Studio command prompt.

3. Change to the "System.Data.SQLite\2010\bin" install directory.

4. Using the "corflags" tool (part of the .NET SDK), flag the "Installer.exe" tool as 32-bit only (e.g. "corflags /32BIT+ /Force Installer.exe").

5. Re-sign the "Installer.exe" assembly using a strong name key pair (e.g. sn -Ra Installer.exe System.Data.SQLite.snk). Any SNK file will work here.

6. Run the "Installer.exe" tool using the following command line:

Installer.exe -install true -installFlags AllExceptGAC -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noVs2008 true -whatIf false -confirm true

mistachkin added on 2012-01-27 14:12:31 UTC:
Flagging the Installer.exe tool as 32-bit only may indeed become the official solution to this issue for the next release.

anonymous added on 2012-01-27 15:09:04 UTC:
Same here with Fx35.

mistachkin added on 2012-01-27 15:52:01 UTC:
Temporary workaround for VS 2008:

1. Install the 32-bit setup without the option checked to run the VS designer components installer.

2. Open a Visual Studio command prompt.

3. Change to the "System.Data.SQLite\2008\bin" install directory.

4. Using the "corflags" tool (part of the .NET SDK), flag the "Installer.exe" tool as 32-bit only (e.g. "corflags /32BIT+ /Force Installer.exe").

5. Re-sign the "Installer.exe" assembly using a strong name key pair (e.g. sn -Ra Installer.exe System.Data.SQLite.snk). Any SNK file will work here.

6. Run the "Installer.exe" tool using the following command line:

Installer.exe -install true -installFlags AllExceptGAC -tracePriority Lowest -verbose true -noCompact true -noNetFx40 true -noVs2010 true -whatIf false -confirm true

mistachkin added on 2012-01-27 15:54:38 UTC:
Working on making the installer aware of the WoW64 subsystem, see check-in [13e7a22c1e].

mistachkin added on 2012-01-27 19:39:38 UTC:
Since Visual Studio is currently a 32-bit application, the 64-bit setups will not be able to install the VS designer components because they only physically include the necessary native code for the 64-bit SQLite core, which cannot be loaded into a 32-bit process. That being the case, the workarounds I added above will only work for the 32-bit setups.

mistachkin added on 2012-01-27 22:30:08 UTC:
The fixes for this issue will be in the next release, 1.0.79.0, which will be out sometime tomorrow. Thanks for your patience.

mistachkin added on 2012-01-28 11:37:20 UTC:
Confirmed fixed, pending release.