System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: a0677309f0a25c357f0445838abba0ef114b716e
Title: Visual Studio 2012 Designer
Status: Closed Type: Incident
Severity: Minor Priority: Medium
Subsystem: VsDesignerInstaller Resolution: Fixed
Last Modified: 2013-01-06 00:17:41
Version Found In: 1.0.83.0
User Comments:
anonymous added on 2012-12-31 00:09:10:
-VS 2012 Premium
-When installing latest version, [sqlite-netFx45-setup-bundle-x86-2012-1.0.83.0.exe], still unable to open a sqlite db in designer. 

Steps:
Server Explorer
Connect to Database
"Change" Data source
SQLite not listed, checked under "other" too.

Install Logs (there were two) seem OK, but there was an entry stating "Visual Studio version not found, skipping"

Installer.exe: #70 @ 2012.12.30T23:50:05.9797225: Installer.ForEachVsVersionRegistry: Visual Studio version not found, skipping...
Installer.exe: #71 @ 2012.12.30T23:50:05.9802219: Installer.Main: subKeysCreated = 1, subKeysDeleted = 1, keyValuesSet = 1, keyValuesDeleted = 0
Installer.exe: #72 @ 2012.12.30T23:50:05.9802219: Installer.Main: filesCreated = 1, filesModified = 2, filesDeleted = 0
Installer.exe: #73 @ 2012.12.30T23:50:05.9802219: Installer.Main: Success.


Other install file did not have that entry:

Installer.exe: #95 @ 2012.12.30T23:50:05.8144699: Installer.ForEachVsVersionRegistry: vsVersion = v11.0
Installer.exe: #96 @ 2012.12.30T23:50:05.8144699: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE", subKeyName = "Software\Wow6432Node\Microsoft\VisualStudio\11.0", writable = False
Installer.exe: #97 @ 2012.12.30T23:50:05.8179683: RegistryHelper.GetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0", name = "InstallDir", defaultValue = <null>
Installer.exe: #98 @ 2012.12.30T23:50:05.8179683: Installer.HaveVsVersion: Visual Studio v11.0 found in directory "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\".
Installer.exe: #99 @ 2012.12.30T23:50:05.8219700: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE", subKeyName = "Software\Wow6432Node\Microsoft\VisualStudio\11.0", writable = False
Installer.exe: #100 @ 2012.12.30T23:50:05.8224718: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0", subKeyName = "DataProviders", writable = True
Installer.exe: #101 @ 2012.12.30T23:50:05.8224718: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders", subKeyName = "{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}"
Installer.exe: #102 @ 2012.12.30T23:50:05.8229726: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = <null>, value = ".NET Framework Data Provider for SQLite"
Installer.exe: #103 @ 2012.12.30T23:50:05.8229726: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = "AssociatedSource", value = "{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c71}"
Installer.exe: #104 @ 2012.12.30T23:50:05.8260045: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = "InvariantName", value = "System.Data.SQLite"
Installer.exe: #105 @ 2012.12.30T23:50:05.8260045: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = "Technology", value = "{77ab9a9d-78b9-4ba7-91ac-873f5338f1d2}"
Installer.exe: #106 @ 2012.12.30T23:50:05.8266482: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = "CodeBase", value = "C:\Program Files (x86)\System.Data.SQLite\2012\bin\SQLite.Designer.dll"
Installer.exe: #107 @ 2012.12.30T23:50:05.8286817: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", name = "FactoryService", value = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9d}"
Installer.exe: #108 @ 2012.12.30T23:50:05.8291798: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataConnectionUIControl"
Installer.exe: #109 @ 2012.12.30T23:50:05.8296798: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataConnectionProperties"
Installer.exe: #110 @ 2012.12.30T23:50:05.8316817: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataConnectionSupport"
Installer.exe: #111 @ 2012.12.30T23:50:05.8316817: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataObjectSupport"
Installer.exe: #112 @ 2012.12.30T23:50:05.8321828: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\11.0\DataProviders\{0ebaab6e-ca80-4b4a-8ddf-cbe6bf058c70}", subKeyName = "SupportedObjects\DataViewSupport"
Installer.exe: #113 @ 2012.12.30T23:50:05.8356828: Installer.Main: subKeysCreated = 12, subKeysDeleted = 1, keyValuesSet = 22, keyValuesDeleted = 0
Installer.exe: #114 @ 2012.12.30T23:50:05.8356828: Installer.Main: filesCreated = 1, filesModified = 1, filesDeleted = 0
Installer.exe: #115 @ 2012.12.30T23:50:05.8361818: Installer.Main: Success.


Version 1.0.82.0 was installed prior to installing 1.0.83.0. I did an uninstall and re-install but did not change outcome.

mistachkin added on 2012-12-31 06:46:39:
Could you please post all the setup logs?

The log files should be located in the %TEMP% directory on the target machine.
They will have names similar to "Setup Log 2012-12-18 #001.txt" and
"Installer.exe.trace.tmp29.log".

mistachkin added on 2012-12-31 07:37:28:
Also, please check for a log file named "dd_vcredist_x86_2012*.log" in the %TEMP% directory as well.

mistachkin added on 2012-12-31 07:58:15:
I'm now able to reproduce the issue here locally.  Apparently, the Wow6432Node sub-key is not used underneath the HKEY_CURRENT_USER pre-defined key, even with 32-bit applications running on a 64-bit operating system.

mistachkin added on 2012-12-31 08:49:53:
Fixed on trunk by check-in [8f6d58c0c4].

mistachkin added on 2012-12-31 09:03:27:
I've attached a corrected 'Installer.exe' file to this ticket.  To fix the issue locally on your machine, please use the following workaround steps:

1. Make sure all existing installs of System.Data.SQLite are uninstalled.

2. Start the setup.

3. Make sure the "Install the assemblies into the global assembly cache."
   task is selected.

4. Make sure the "Install the designer components for Visual Studio 2012."
   task is NOT selected.

5. Complete the setup.

6. After the setup completes successfully, open an "elevated" Administrator command prompt and navigate to the System.Data.SQLite install directory, e.g.:

    CD /D "C:\Program Files (x86)\System.Data.SQLite\2012\bin"

7. Run the following commands, in order:

    Installer.exe -install true -wow64 true -installFlags AllExceptGlobalAssemblyCache -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noNetFx40 true -noVs2005 true -noVs2008 true -noVs2010 true -configVersion 4.0.30319 -whatIf false -confirm true

    Installer.exe -perUser true -install true -wow64 true -installFlags AllExceptGlobalAssemblyCache -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noNetFx40 true -noNetFx45 true -noVs2005 true -noVs2008 true -noVs2010 true -configVersion 4.0.30319 -vsVersionSuffix _Config -whatIf false -confirm true

mistachkin added on 2012-12-31 09:03:52:
If you need to uninstall System.Data.SQLite, use the following commands, in order, BEFORE running the uninstaller:

    Installer.exe -perUser true -install false -wow64 true -installFlags AllExceptGlobalAssemblyCache -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noNetFx40 true -noNetFx45 true -noVs2005 true -noVs2008 true -noVs2010 true -configVersion 4.0.30319 -vsVersionSuffix _Config -whatIf false -confirm true

    Installer.exe -install false -wow64 true -installFlags AllExceptGlobalAssemblyCache -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noNetFx40 true -noVs2005 true -noVs2008 true -noVs2010 true -configVersion 4.0.30319 -whatIf false -confirm true

mistachkin added on 2012-12-31 09:10:06:
I'm planning on re-running the release based on check-in [7b4f7b6d48], which backport the fix for this ticket to the 1.0.83.0 release branch.

mistachkin added on 2012-12-31 14:10:47:
Fixed on release branch by check-in [2a1882382a].  All release files have been rebuilt, re-tested, and re-uploaded.  The setup package for Visual Studio 2012 should now install the design-time components properly.

Attachments: