Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

I get error message during connection process #399

Closed
relbraun opened this issue Jun 21, 2017 · 24 comments
Closed

I get error message during connection process #399

relbraun opened this issue Jun 21, 2017 · 24 comments

Comments

@relbraun
Copy link

I followed the instructions how to install and connect to sqlite and I receiving an error message
image

Steps to reproduce

Further technical details

Toolbox version: 4.7

Database engine: (SQlite)

Visual Studio 2017
@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

1: Did you follow the guide here? https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider

2: Please show the result from the About dialog in the Toolbox

3: please share your app.config/web.config and packages.config files (or even better, a repro project)

@relbraun
Copy link
Author

relbraun commented Jun 21, 2017 •
edited
Loading

  1. I followed that guide except the version of the sqlite-netFx46-setup-bundle-x86-2015-1.0.105.1.exe file that I didn't find the exact version and I installed newer one.
  2. Sorry but where can I find the About dialog in the Toolbox
  3. App.config:
package.config:

image

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

You need to marke the config file contents as code

@relbraun
Copy link
Author 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
  </startup>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v13.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite.EF6" />
      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
    <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>
  </system.data>
</configuration>

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

Your DbProviderFacories section does not look like in the wiki post.

And also share packages.config and About from the Toolbox as well, please

@relbraun
Copy link
Author 

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="EntityFramework" version="6.0.0" targetFramework="net452" />
  <package id="Geckofx45" version="45.0.31" targetFramework="net452" />
  <package id="System.Data.SQLite" version="1.0.105.0" targetFramework="net452" />
  <package id="System.Data.SQLite.Core" version="1.0.105.0" targetFramework="net452" />
  <package id="System.Data.SQLite.EF6" version="1.0.105.0" targetFramework="net452" />
  <package id="System.Data.SQLite.Linq" version="1.0.105.0" targetFramework="net452" />
</packages>

Where can I find the About from the Toolbox?

Thank u for your patience

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

In the SQLite Toolbox, click the blue question mark icon - and take a screenshot

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017 •
edited
Loading

You should install the 105.2 SQLite packages, if you have installed the 105.2 tools! https://www.nuget.org/packages/System.Data.SQLite/
(see the sample packages.config in my wiki post)

@relbraun
Copy link
Author

image

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

SQLite EF6 DbProvider in GAC - NO!

So you did not install sqlite-netFx46-setup-bundle-x86-2015-1.0.105.2.exe properly (or restart VS after install - I have added this to the wiki post)

@relbraun
Copy link
Author

It is very odd, I have installed it now and restart the vs and it still tells me it is not installed

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

Restart PC??

@relbraun
Copy link
Author

nothing

@relbraun
Copy link
Author

Do you have any idea why SQLite EF6 DbProvider in GAC - NO?

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 21, 2017

Because it is not installed and registered in machine.config in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config folder

@relbraun
Copy link
Author

how can I do it?

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 22, 2017

Run the installer as Admin?

@relbraun
Copy link
Author

I did it and nothing

@ErikEJ
Copy link
Owner

ErikEJ commented Jun 22, 2017

I am unable to help you further, sorry, other than you trying on another PC...

@ErikEJ ErikEJ closed this as completed Jun 22, 2017
@relbraun
Copy link
Author

relbraun commented Jun 22, 2017 •
edited
Loading

@ErikEJ Thank u for your goodwill and efforts.

@ramkris06
Copy link

Getting this error while installing DDEX provider . Any help on how to resolve it ?

C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0>installer.exe Installer.exe: #1 @ 2018.04.14T02:43:32.4203848: Assembly: "Installer, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" Installer.exe: #2 @ 2018.04.14T02:43:32.4258851: LogFileName: "C:\Users\pkrish6\AppData\Local\Temp\Installer.exe.trace.tmp31D8.log" Installer.exe: #3 @ 2018.04.14T02:43:32.4263852: RegistryLogFileName: Installer.exe: #4 @ 2018.04.14T02:43:32.4268853: Directory: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0" Installer.exe: #5 @ 2018.04.14T02:43:32.4268853: CoreFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.dll" Installer.exe: #6 @ 2018.04.14T02:43:32.4278855: LinqFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.Linq.dll" Installer.exe: #7 @ 2018.04.14T02:43:32.4278855: Ef6FileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.EF6.dll" Installer.exe: #8 @ 2018.04.14T02:43:32.4283856: DesignerFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\SQLite.Designer.dll" Installer.exe: #9 @ 2018.04.14T02:43:32.4288854: RegistryVersion: Installer.exe: #10 @ 2018.04.14T02:43:32.4288854: ConfigVersion: Installer.exe: #11 @ 2018.04.14T02:43:32.4298852: VsVersionSuffix: Installer.exe: #12 @ 2018.04.14T02:43:32.4298852: DebugFormat: "#{0:000} @ {1}: {2}" Installer.exe: #13 @ 2018.04.14T02:43:32.4303853: TraceFormat: "#{0:000} @ {1}: {2}" Installer.exe: #14 @ 2018.04.14T02:43:32.4318866: InstallFlags: Default Installer.exe: #15 @ 2018.04.14T02:43:32.4323867: ProviderFlags: Default Installer.exe: #16 @ 2018.04.14T02:43:32.4328858: DebugPriority: Default Installer.exe: #17 @ 2018.04.14T02:43:32.4333859: TracePriority: Default Installer.exe: #18 @ 2018.04.14T02:43:32.4333859: PerUser: False Installer.exe: #19 @ 2018.04.14T02:43:32.4338863: Install: True Installer.exe: #20 @ 2018.04.14T02:43:32.4343857: Wow64: False Installer.exe: #21 @ 2018.04.14T02:43:32.4348854: NoRuntimeVersion: False Installer.exe: #22 @ 2018.04.14T02:43:32.4353859: NoDesktop: False Installer.exe: #23 @ 2018.04.14T02:43:32.4353859: NoCompact: False Installer.exe: #24 @ 2018.04.14T02:43:32.4358870: NoNetFx20: False Installer.exe: #25 @ 2018.04.14T02:43:32.4363854: NoNetFx35: False Installer.exe: #26 @ 2018.04.14T02:43:32.4369035: NoNetFx40: False Installer.exe: #27 @ 2018.04.14T02:43:32.4369035: NoNetFx45: False Installer.exe: #28 @ 2018.04.14T02:43:32.4374085: NoNetFx451: False Installer.exe: #29 @ 2018.04.14T02:43:32.4379083: NoNetFx452: False Installer.exe: #30 @ 2018.04.14T02:43:32.4384084: NoNetFx46: False Installer.exe: #31 @ 2018.04.14T02:43:32.4389085: NoNetFx461: False Installer.exe: #32 @ 2018.04.14T02:43:32.4389085: NoNetFx462: False Installer.exe: #33 @ 2018.04.14T02:43:32.4394086: NoNetFx47: False Installer.exe: #34 @ 2018.04.14T02:43:32.4399087: NoNetFx471: False Installer.exe: #35 @ 2018.04.14T02:43:32.4414086: NoVs2005: False Installer.exe: #36 @ 2018.04.14T02:43:32.4414086: NoVs2008: False Installer.exe: #37 @ 2018.04.14T02:43:32.4419083: NoVs2010: False Installer.exe: #38 @ 2018.04.14T02:43:32.4424081: NoVs2012: False Installer.exe: #39 @ 2018.04.14T02:43:32.4429082: NoVs2013: False Installer.exe: #40 @ 2018.04.14T02:43:32.4429082: NoVs2015: False Installer.exe: #41 @ 2018.04.14T02:43:32.4434083: NoVs2017: False Installer.exe: #42 @ 2018.04.14T02:43:32.4439084: NoTrace: False Installer.exe: #43 @ 2018.04.14T02:43:32.4439084: NoConsole: False Installer.exe: #44 @ 2018.04.14T02:43:32.4444081: NoLog: False Installer.exe: #45 @ 2018.04.14T02:43:32.4449082: ThrowOnMissing: True Installer.exe: #46 @ 2018.04.14T02:43:32.4454083: WhatIf: True Installer.exe: #47 @ 2018.04.14T02:43:32.4454083: Debug: False Installer.exe: #48 @ 2018.04.14T02:43:32.4459084: Verbose: False Installer.exe: #49 @ 2018.04.14T02:43:32.4464085: Confirm: False Installer.exe: #50 @ 2018.04.14T02:43:32.4469082: AssemblyTitle: "System.Data.SQLite Designer Installer" Installer.exe: #51 @ 2018.04.14T02:43:32.4469082: AssemblyConfiguration: "Release" Installer.exe: #52 @ 2018.04.14T02:43:32.4479084: IsSystemEf6AssemblyAvailable: False Installer.exe: #53 @ 2018.04.14T02:43:32.4484085: IsSystemEf6AssemblyGlobal: False Installer.exe: #54 @ 2018.04.14T02:43:32.4484085: IsLinqSupported: True Installer.exe: #55 @ 2018.04.14T02:43:32.4494087: IsEf6Supported: False Installer.exe: #56 @ 2018.04.14T02:43:32.4494087: IsEf6AssemblyGlobal: False Installer.exe: #57 @ 2018.04.14T02:43:32.4504085: UseEf6Provider: False Installer.exe: #58 @ 2018.04.14T02:43:32.4514087: GetCoreAssemblyName: "System.Data.SQLite, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" Installer.exe: #59 @ 2018.04.14T02:43:32.4519088: GetLinqAssemblyName: "System.Data.SQLite.Linq, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" Installer.exe: #60 @ 2018.04.14T02:43:32.4524082: GetEf6AssemblyName: Installer.exe: #61 @ 2018.04.14T02:43:32.4529083: GetDesignerAssemblyName: "SQLite.Designer, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" Installer.exe: #62 @ 2018.04.14T02:43:32.4534084: GetInvariantName: "System.Data.SQLite" Installer.exe: #63 @ 2018.04.14T02:43:32.4539085: GetConfigInvariantName: "System.Data.SQLite" Installer.exe: #64 @ 2018.04.14T02:43:32.4544086: GetProviderInvariantName: "System.Data.SQLite" Installer.exe: #65 @ 2018.04.14T02:43:32.4554081: GetFactoryTypeName: "System.Data.SQLite.SQLiteFactory" Installer.exe: #66 @ 2018.04.14T02:43:32.4559092: GetProviderAssemblyName: "System.Data.SQLite, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" Installer.exe: #67 @ 2018.04.14T02:43:32.4574084: Configuration.Process: No actual changes will be made to this system because "what-if" mode is enabled. Installer.exe: #68 @ 2018.04.14T02:43:32.4584086: TraceOps.ShowMessage: Cannot continue, the "confirm" option is not enabled. Installer.exe: #69 @ 2018.04.14T02:43:34.8889346: TraceOps.ShowMessage: User choice of OK. Installer.exe: #70 @ 2018.04.14T02:43:34.8899352: Installer.Main: Failure.

@ErikEJ
Copy link
Owner

ErikEJ commented Apr 14, 2018

Did you look at the log file? C:\Users\pkrish6\AppData\Local\Temp\Installer.exe.trace.tmp31D8.log

Please ask at system.data.sqlite

@ramkris06
Copy link

Same data in log file . No other new information. Tried installing again.

Installer.exe: #1 @ 2018.04.14T14:28:31.0876210: Assembly: "Installer, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #2 @ 2018.04.14T14:28:31.0916181: LogFileName: "C:\Users\pkrish6\AppData\Local\Temp\Installer.exe.trace.tmp512E.log"
Installer.exe: #3 @ 2018.04.14T14:28:31.0916181: RegistryLogFileName:
Installer.exe: #4 @ 2018.04.14T14:28:31.0926194: Directory: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0"
Installer.exe: #5 @ 2018.04.14T14:28:31.0926194: CoreFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.dll"
Installer.exe: #6 @ 2018.04.14T14:28:31.0926194: LinqFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.Linq.dll"
Installer.exe: #7 @ 2018.04.14T14:28:31.0926194: Ef6FileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\System.Data.SQLite.EF6.dll"
Installer.exe: #8 @ 2018.04.14T14:28:31.0926194: DesignerFileName: "C:\Dev\sqlite-4-6-binary\sqlite-netFx46-binary-x64-2015-1.0.108.0\SQLite.Designer.dll"
Installer.exe: #9 @ 2018.04.14T14:28:31.0926194: RegistryVersion:
Installer.exe: #10 @ 2018.04.14T14:28:31.0926194: ConfigVersion:
Installer.exe: #11 @ 2018.04.14T14:28:31.0936185: VsVersionSuffix:
Installer.exe: #12 @ 2018.04.14T14:28:31.0936185: DebugFormat: "#{0:000} @ {1}: {2}"
Installer.exe: #13 @ 2018.04.14T14:28:31.0936185: TraceFormat: "#{0:000} @ {1}: {2}"
Installer.exe: #14 @ 2018.04.14T14:28:31.0936185: InstallFlags: Default
Installer.exe: #15 @ 2018.04.14T14:28:31.0936185: ProviderFlags: Default
Installer.exe: #16 @ 2018.04.14T14:28:31.0936185: DebugPriority: Default
Installer.exe: #17 @ 2018.04.14T14:28:31.0936185: TracePriority: Default
Installer.exe: #18 @ 2018.04.14T14:28:31.0936185: PerUser: False
Installer.exe: #19 @ 2018.04.14T14:28:31.0936185: Install: True
Installer.exe: #20 @ 2018.04.14T14:28:31.0936185: Wow64: False
Installer.exe: #21 @ 2018.04.14T14:28:31.0936185: NoRuntimeVersion: False
Installer.exe: #22 @ 2018.04.14T14:28:31.0946187: NoDesktop: False
Installer.exe: #23 @ 2018.04.14T14:28:31.0946187: NoCompact: False
Installer.exe: #24 @ 2018.04.14T14:28:31.0946187: NoNetFx20: False
Installer.exe: #25 @ 2018.04.14T14:28:31.0946187: NoNetFx35: False
Installer.exe: #26 @ 2018.04.14T14:28:31.0956192: NoNetFx40: False
Installer.exe: #27 @ 2018.04.14T14:28:31.0956192: NoNetFx45: False
Installer.exe: #28 @ 2018.04.14T14:28:31.0966190: NoNetFx451: False
Installer.exe: #29 @ 2018.04.14T14:28:31.0966190: NoNetFx452: False
Installer.exe: #30 @ 2018.04.14T14:28:31.0976192: NoNetFx46: False
Installer.exe: #31 @ 2018.04.14T14:28:31.1006201: NoNetFx461: False
Installer.exe: #32 @ 2018.04.14T14:28:31.1006201: NoNetFx462: False
Installer.exe: #33 @ 2018.04.14T14:28:31.1016199: NoNetFx47: False
Installer.exe: #34 @ 2018.04.14T14:28:31.1016199: NoNetFx471: False
Installer.exe: #35 @ 2018.04.14T14:28:31.1026197: NoVs2005: False
Installer.exe: #36 @ 2018.04.14T14:28:31.1026197: NoVs2008: False
Installer.exe: #37 @ 2018.04.14T14:28:31.1026197: NoVs2010: False
Installer.exe: #38 @ 2018.04.14T14:28:31.1036199: NoVs2012: False
Installer.exe: #39 @ 2018.04.14T14:28:31.1036199: NoVs2013: False
Installer.exe: #40 @ 2018.04.14T14:28:31.1046197: NoVs2015: False
Installer.exe: #41 @ 2018.04.14T14:28:31.1046197: NoVs2017: False
Installer.exe: #42 @ 2018.04.14T14:28:31.1056195: NoTrace: False
Installer.exe: #43 @ 2018.04.14T14:28:31.1056195: NoConsole: False
Installer.exe: #44 @ 2018.04.14T14:28:31.1066194: NoLog: False
Installer.exe: #45 @ 2018.04.14T14:28:31.1066194: ThrowOnMissing: True
Installer.exe: #46 @ 2018.04.14T14:28:31.1066194: WhatIf: True
Installer.exe: #47 @ 2018.04.14T14:28:31.1076195: Debug: False
Installer.exe: #48 @ 2018.04.14T14:28:31.1076195: Verbose: False
Installer.exe: #49 @ 2018.04.14T14:28:31.1086190: Confirm: False
Installer.exe: #50 @ 2018.04.14T14:28:31.1106197: AssemblyTitle: "System.Data.SQLite Designer Installer"
Installer.exe: #51 @ 2018.04.14T14:28:31.1106197: AssemblyConfiguration: "Release"
Installer.exe: #52 @ 2018.04.14T14:28:31.1116199: IsSystemEf6AssemblyAvailable: False
Installer.exe: #53 @ 2018.04.14T14:28:31.1116199: IsSystemEf6AssemblyGlobal: False
Installer.exe: #54 @ 2018.04.14T14:28:31.1126204: IsLinqSupported: True
Installer.exe: #55 @ 2018.04.14T14:28:31.1136199: IsEf6Supported: False
Installer.exe: #56 @ 2018.04.14T14:28:31.1136199: IsEf6AssemblyGlobal: False
Installer.exe: #57 @ 2018.04.14T14:28:31.1146201: UseEf6Provider: False
Installer.exe: #58 @ 2018.04.14T14:28:31.1156220: GetCoreAssemblyName: "System.Data.SQLite, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #59 @ 2018.04.14T14:28:31.1156220: GetLinqAssemblyName: "System.Data.SQLite.Linq, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #60 @ 2018.04.14T14:28:31.1166193: GetEf6AssemblyName:
Installer.exe: #61 @ 2018.04.14T14:28:31.1166193: GetDesignerAssemblyName: "SQLite.Designer, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #62 @ 2018.04.14T14:28:31.1176213: GetInvariantName: "System.Data.SQLite"
Installer.exe: #63 @ 2018.04.14T14:28:31.1186197: GetConfigInvariantName: "System.Data.SQLite"
Installer.exe: #64 @ 2018.04.14T14:28:31.1206208: GetProviderInvariantName: "System.Data.SQLite"
Installer.exe: #65 @ 2018.04.14T14:28:31.1216199: GetFactoryTypeName: "System.Data.SQLite.SQLiteFactory"
Installer.exe: #66 @ 2018.04.14T14:28:31.1226197: GetProviderAssemblyName: "System.Data.SQLite, Version=1.0.108.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #67 @ 2018.04.14T14:28:31.1246204: Configuration.Process: No actual changes will be made to this system because "what-if" mode is enabled.
Installer.exe: #68 @ 2018.04.14T14:28:31.1256199: TraceOps.ShowMessage: Cannot continue, the "confirm" option is not enabled.
Installer.exe: #69 @ 2018.04.14T14:28:38.0351868: TraceOps.ShowMessage: User choice of OK.
Installer.exe: #70 @ 2018.04.14T14:28:38.0351868: Installer.Main: Failure.

@ErikEJ
Copy link
Owner

ErikEJ commented Apr 14, 2018

I cannot assist, suggest you ask at system.data.sqlite.org

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ErikEJ @relbraun @ramkris06