System.Data.SQLite: View Ticket

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.