What version of sqlite DLL have to use to support in WPF application to run in windows7 32bit

Question

1.00/5 (2 votes)

See more:

I used x86 SQLite.interop.dll and SQLite3.dll in my application it is running in Windows10, but in windows7 it is crashing with the following error:
Exception Info: System.DllNotFoundException
at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum)
at System.Data.SQLite.SQLite3.StaticIsInitialized()
at System.Data.SQLite.SQLiteLog.Initialize()
at System.Data.SQLite.SQLiteConnection..ctor(System.String, Boolean)
at System.Data.SQLite.SQLiteConnection..ctor(System.String)
at PointOfSale.CursorWait.Logger.IfExists(System.String)
at PointOfSale.CursorWait.Logger.getPath(System.String)
at PointOfSale.CursorWait.Logger..ctor()
at PointOfSale.CursorWait.SQLSelects..ctor()
at PointOfSale.Logon.btnLogin_Click(System.Object, System.Windows.RoutedEventArgs)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
at System.Windows.UIElement.RaiseEvent(System.Windows.RoutedEventArgs)
at System.Windows.Controls.Primitives.ButtonBase.OnClick()
at System.Windows.Controls.Button.OnClick()
at System.Windows.Controls.Primitives.ButtonBase.OnAccessKey(System.Windows.Input.AccessKeyEventArgs)

What I have tried:

I tried with SQLite.dll(x86) and SQLite.interop.dll(x86)

Posted 16-Mar-17 4:16am

Venkat Konda

Updated 16-Mar-17 16:32pm

Add a Solution

Comments

CHill60 16-Mar-17 10:20am

Did you install the dll correctly on your Windows 7 machine?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Accepted Answer · 2017-03-16T16:32:00

When you set the .Net Framework version for the project, Nuget will choose the correct SqLite version for you.

The tricky party is configuring the installer to choose the correct 32bit or 64bit version .

In my apps, I create x64 & x32 folders and "Add as Link" the correct versions of SQLite.Interop.dll from the Nuget package folder into their respective x64/x32 app folders. The installer (OneClick in my case) packages them up and installs them correctly. Yes, even Windows 7 (32bit).