[sqlite] [64bits server] The underlying provider failed on Open
Hello, I just try to move my application from a 32 bits server to a 64 bits server. After few tries, I've finally downloaded the 64 bits zip ( sqlite-netFx40-static-binary-bundle-x64-2010-1.0.81.0.zip) and deployed the 2 SQLite dlls. I've come to this error: The underlying provider failed on Open. at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) at System.Data.EntityClient.EntityConnection.Open() at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMerge Option) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) I've even added this to my configuration file: It's still working on my 32 bits machine though. What can I do more? Thanks for your help. - Jean This message and any attachments (the "message") is intended solely for the intended addressees and is confidential. If you receive this message in error,or are not the intended recipient(s), please delete it and any copies from your systems and immediately notify the sender. Any unauthorized view, use that does not comply with its purpose, dissemination or disclosure, either whole or partial, is prohibited. Since the internet cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS (and its subsidiaries) shall not be liable for the message if modified, changed or falsified. Do not print this message unless it is necessary,consider the environment. -- Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur ou s'il ne vous est pas destine, merci de le detruire ainsi que toute copie de votre systeme et d'en avertir immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de ce message qui n'est pas conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer l'integrite de ce message electronique susceptible d'alteration, BNP Paribas (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese ou il aurait ete modifie, deforme ou falsifie. N'imprimez ce message que si necessaire, pensez a l'environnement. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problem with SQLite on client machine under .net framework 4 client profile
Hello, I'm trying to launch our application .exe on a client machine. We've rebuilt the project under .NET framework 4 client profile. I have this error on launch: "The specified store provider cannot be found in the configuration, or is not valid". Do you have an idea of what to do? Everything runs fine on developers' machines. Am I obliged to install the SQLite .NET 4 Win32 setup on every machine that should run the .exe? Thanks and regards, Jean - This message and any attachments (the "message") is intended solely for the intended addressees and is confidential. If you receive this message in error,or are not the intended recipient(s), please delete it and any copies from your systems and immediately notify the sender. Any unauthorized view, use that does not comply with its purpose, dissemination or disclosure, either whole or partial, is prohibited. Since the internet cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS (and its subsidiaries) shall not be liable for the message if modified, changed or falsified. Do not print this message unless it is necessary,consider the environment. -- Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur ou s'il ne vous est pas destine, merci de le detruire ainsi que toute copie de votre systeme et d'en avertir immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de ce message qui n'est pas conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer l'integrite de ce message electronique susceptible d'alteration, BNP Paribas (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese ou il aurait ete modifie, deforme ou falsifie. N'imprimez ce message que si necessaire, pensez a l'environnement. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Réf. : Re: Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How?
I've managed to make it work. What I've done: - Uninstall SQLite provider for VS (both 3.5 and 4.0 versions were installed) - Download dlls for .NET 4.0 - Install SQLite provider for .net 4 and VS2010 sqlite-netFx40-setup-bundle-x86-2010-1.0.81.0.exe - Update my connection string in parent project Thanks for the help. - Jean Internet be...@web.de Envoyé par : sqlite-users-boun...@sqlite.org 08/11/2012 06:01 PM Veuillez répondre à sqlite-users@sqlite.org Pour sqlite-users@sqlite.org cc Objet Re: [sqlite] Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How? Am 10.08.2012 19:14, schrieb jean.nkengto...@externe.bnpparibas.com: > Hello, > > I bet somebody already managed to make this work. Unhappily I can't access > archives. > > Here is my problem: > I'm building a Console Application to load and fill one SQLite DB. > We recently decided to switch the application to framework 4.0, from > framework 3.5. > > I've downloaded and deployed dll 1.0.81.0 on my application (added to > project's references) from there: > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki. > Now on run, I'm stumbling on this error: > Mixed mode assembly is built against version 'v2.0.50727' of the runtime > and cannot be loaded in the 4.0 runtime without additional configuration > information. > To me it looks like the compiler is trying to load the wrong dll, maybe from the GAC. Did you download one of these archives? - sqlite-netFx40-static-binary-bundle-x64-2010-1.0.81.0.zip - sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.81.0.zip Usually I don't use the setup-files as I don't need the Visual Studio integration. You should be fine unzipping the system.data.sqlite.dll that fits your system and throw it into your bin-folder and you should be good to go. > After some copy, replace of dlls, following > http://www.tsjensen.com/blog/post/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx > , I still don't get it to work: > Impossible to load metadata resource specified > > I saw some threads asking to add "useLegacyV2RuntimeActivationPolicy", but > that doesn't work. > Plus, why should I add this, knowing that version 1.0.81.0 is supposed to > be built in v4.0? I've never had to mess around with any hacks, nor should you. If you don't absolutely need the VS-Integration and installed the setup, you could try uninstalling it. Bernd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This message and any attachments (the "message") is intended solely for the intended addressees and is confidential. If you receive this message in error,or are not the intended recipient(s), please delete it and any copies from your systems and immediately notify the sender. Any unauthorized view, use that does not comply with its purpose, dissemination or disclosure, either whole or partial, is prohibited. Since the internet cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS (and its subsidiaries) shall not be liable for the message if modified, changed or falsified. Do not print this message unless it is necessary,consider the environment. -- Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur ou s'il ne vous est pas destine, merci de le detruire ainsi que toute copie de votre systeme et d'en avertir immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de ce message qui n'est pas conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer l'integrite de ce message electronique susceptible d'alteration, BNP Paribas (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese ou il aurait ete modifie, deforme ou falsifie. N'imprimez ce message que si necessaire, pensez a l'environnement. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Make System.Data.SQLite 1.0.81.0 work with .NET 4.0. How?
Hello, I bet somebody already managed to make this work. Unhappily I can't access archives. Here is my problem: I'm building a Console Application to load and fill one SQLite DB. We recently decided to switch the application to framework 4.0, from framework 3.5. I've downloaded and deployed dll 1.0.81.0 on my application (added to project's references) from there: http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki. Now on run, I'm stumbling on this error: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. After some copy, replace of dlls, following http://www.tsjensen.com/blog/post/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions.aspx , I still don't get it to work: Impossible to load metadata resource specified I saw some threads asking to add "useLegacyV2RuntimeActivationPolicy", but that doesn't work. Plus, why should I add this, knowing that version 1.0.81.0 is supposed to be built in v4.0? Could somebody explain and provide instructions to make this work? Thanks and regards, Jean - This message and any attachments (the "message") is intended solely for the intended addressees and is confidential. If you receive this message in error,or are not the intended recipient(s), please delete it and any copies from your systems and immediately notify the sender. Any unauthorized view, use that does not comply with its purpose, dissemination or disclosure, either whole or partial, is prohibited. Since the internet cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS (and its subsidiaries) shall not be liable for the message if modified, changed or falsified. Do not print this message unless it is necessary,consider the environment. -- Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur ou s'il ne vous est pas destine, merci de le detruire ainsi que toute copie de votre systeme et d'en avertir immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de ce message qui n'est pas conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer l'integrite de ce message electronique susceptible d'alteration, BNP Paribas (et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese ou il aurait ete modifie, deforme ou falsifie. N'imprimez ce message que si necessaire, pensez a l'environnement. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users