[sqlite] VS2008 design support error
I have been trying to get the system.data.sqlite version 1.0.79 working with Visual Studio 2008 Pro (with SP). Each time I try to use Add Connection to create the database connection string, the system.sqlite.data, I VS2008 is popping up an error dialog: Package Load Failure Package 'System.Data.SQlite Designer Package' has failed to load properly ( GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. I did find the exact same error in the mailing list archive [http://www.mail-archive.com/sqlite-users@sqlite.org/msg67358.html] , but there was no resolution attached just a request for logging. To add to it, I am getting this error message on my system referenced below and a Virtual Machine with a fresh VS2008SP install on Windows 2008. System Details: Windows 7 x64 SP1 Visual Studio 2008 Professional (Version: 9.0.30729.1 SP) Installer: sqlite-netFx35-setup-x86-2008-1.0.79.0.exe Options used from installer: Full installation with Generate native images and Install the designer components for Visual Studio 2008 checked VS2008 Log # Type Description GUID Hr Source Time 121 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:24.424 122 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:24.463 123 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:24.465 124 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:24.470 125 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:24.478 126 Warning Appid denied the loading of package {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio 2012/02/10 15:20:24.478 127 Entering function CVsPackageInfo::HrInstantiatePackage {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio 2012/02/10 15:20:26.519 128 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:26.521 129 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:26.523 130 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:26.524 131 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:26.538 132 Warning CheckPackageSignature failed; invalid Package Load Key {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio Appid Stub 2012/02/10 15:20:26.539 133 Warning Appid denied the loading of package {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} Microsoft Visual Studio 2012/02/10 15:20:26.540 Trevor Burns ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Trevor Burns wrote: Package Load Failure Package 'System.Data.SQlite Designer Package' has failed to load properly ( GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. If this is indeed a package load key failure, one potential workaround would be to install the Visual Studio 2008 SDK, which would then allow all packages to load. Meanwhile, I'll look into getting a new package load key assigned for the package. Please note that this issue does *NOT* exist for Visual Studio 2010 as it no longer requires a proper package load key. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Trevor Burns wrote: Package Load Failure Package 'System.Data.SQlite Designer Package' has failed to load properly ( GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. The underlying issue (package load key mismatch) should now be fixed, see: http://system.data.sqlite.org/index.html/ci/67caeebd79?sbs=0 Please note that this issue does *NOT* exist for Visual Studio 2010 (and later) as it no longer requires a proper package load key. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Joe After getting the update on the changes I downloaded the installer from the website (the publish dates match today). When I used the installer, the same error message occurred. So I downloaded the VS2008 SDK 1.1, installed, and the add connection screen is working. Thanks for your help. Trevor -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Friday, February 10, 2012 2:47 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] VS2008 design support error Trevor Burns wrote: Package Load Failure Package 'System.Data.SQlite Designer Package' has failed to load properly ( GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. The underlying issue (package load key mismatch) should now be fixed, see: http://system.data.sqlite.org/index.html/ci/67caeebd79?sbs=0 Please note that this issue does *NOT* exist for Visual Studio 2010 (and later) as it no longer requires a proper package load key. -- 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] VS2008 design support error
Just installed .NET3.5 32bit bundle v1.0.79.0 (on a 64bit Win7 machine). When I open VS2008 - go to Server Explorer - Add Connection - Select 'System...SQLite ... provider' I get the following error: --- Microsoft Visual Studio --- Package Load FailurePackage 'System.Data.SQLite Designer Package' has failed to load properly ( GUID = {DCBE6C8D-0E57-4099-A183-98FF74C64D9C} ). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. --- Yes No --- It still lets me enter the connection string but, and 'Test Connection' is successful, but then when I click 'OK' to save the new connection I get the same error again followed by: --- Microsoft Visual Studio --- An unexpected error occurred in the .NET Framework Data Provider for SQLite. Please contact the provider vendor to resolve this problem. --- OK --- Any help would be appliciated. Thanks, - Levi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Levi Haskell wrote: When I open VS2008 - go to Server Explorer - Add Connection - Select 'System...SQLite ... provider' I get the following error: Without more details it's tough to guess what the precise problem is (as package load failures are fairly generic and can be caused by a variety of issues). One thought: Did you select the option (during the setup) to place the assemblies into the GAC? -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
I tried it both ways, even tried putting SQLite.Designer.dll into GAC (which as I now understand is not required). Still the same result. Interestingly it works fine with VS2010 on the same machine. Is there a log file I can look up somewhere on the disk where I can get more specific error from? Thanks, - Levi From: sql...@mistachkin.com To: sqlite-users@sqlite.org Date: Mon, 30 Jan 2012 09:51:27 -0800 Subject: Re: [sqlite] VS2008 design support error Levi Haskell wrote: When I open VS2008 - go to Server Explorer - Add Connection - Select 'System...SQLite ... provider' I get the following error: Without more details it's tough to guess what the precise problem is (as package load failures are fairly generic and can be caused by a variety of issues). One thought: Did you select the option (during the setup) to place the assemblies into the GAC? -- 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] VS2008 design support error
On 30 Jan 2012, at 6:04pm, Levi Haskell wrote: Interestingly it works fine with VS2010 on the same machine. Is there a log file I can look up somewhere on the disk where I can get more specific error from? You might want to ask this on a forum about VS2010. There's apparently nothing wrong with the SQLite element. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Levi Haskell wrote: Is there a log file I can look up somewhere on the disk where I can get more specific error from? Yes, logging can be enabled as described in: http://blogs.msdn.com/b/dr._ex/archive/2006/12/14/debugging-package-load-fai lures.aspx -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VS2008 design support error
Simon Slavin wrote: You might want to ask this on a forum about VS2010. There's apparently nothing wrong with the SQLite element. The designer components are part of System.Data.SQLite and are currently supported by me. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users