Sqlite.DLL reference error

Question

1.00/5 (1 vote)

See more:

I'm trying to incorporate Sqlite.dll into one of my projects. Works fine on my system... but problem occurs when I port this application to another system. It says

Could not load file or assembly 'System.Data.Sqlite, Version=1.0.66.0, Culture=Neutral, PublicKeyToken=db937bc2d44ff139' or one of it's dependencies. An attempt was made to load a program with an incorrect format.

I'm targeting the application to run on .Net 3.5 Platform. Please Help!

Thanks in Advance!

Sunny

Posted 25-Feb-13 18:01pm

Sunny_Kumar_

Add a Solution

Comments

Sergey Alexandrovich Kryukov 26-Feb-13 0:13am

Well, do you have required .NET Framework installed in that machine? Do you have SQlite of appropriate version also installed?
—SA

Sunny_Kumar_ 26-Feb-13 0:25am

I'm a novice to SQLite, Is it required to install SQLite on the target machine also, or a DLL reference will do? the Target machine has the latest .Net framework 4.5 installed. But I want the app to target on 3.5 so hat it can run successfully on early legacy systems as well. Please suggest what should I do?

Sergey Alexandrovich Kryukov 26-Feb-13 0:31am

Novice or not, how about just thinking a bit? Reference, essentially, is just a name, usually a strong name. If you fully name, say some version of Microsoft Office, do you think it will run the Word application without installation? :-)
—SA

Sunny_Kumar_ 26-Feb-13 0:44am

true, thanks you so much for the help & your time, I really appreciate. I'm sure I'm gonna sort this out... thanks again :)

Sergey Alexandrovich Kryukov 26-Feb-13 1:00am

You are welcome.
I'm almost sure you will sort it out. For a record, I also put a formal answer, please see.
—SA

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2013-02-25T19:00:00

Solution 1

I would suggest that you require the user to have SQLite of appropriate version to be installed as one of the prerequisites for your software product, as well as the compatible .NET Framework version. In my opinion, this is a preferable option for most cases.

However, you can consider to deploy either of them with your application.

For .NET, please see: http://msdn.microsoft.com/en-us/library/6hbb4k3e%28v=vs.90%29.aspx[^].

For SQLite, you have to study the problem: http://bit.ly/WnY14r[^].

Good luck,

—SA

Posted 25-Feb-13 19:00pm

Sergey Alexandrovich Kryukov

Comments

Sunny_Kumar_ 26-Feb-13 2:29am

It really helped. Thanks !!

Sergey Alexandrovich Kryukov 26-Feb-13 11:44am

My pleasure.
Good luck, call again.
—SA

Sunny_Kumar_ 3-Mar-13 23:54pm

Hello Sir, Can you please help me out with this... I couldn't find any way to PM you hence replying this thread to reach you.

http://www.codeproject.com/Questions/530048/GetplusAllplusStockplusSymbolsplusStock-Market-Wis
I still couldn't find any solution for this problem... I want to sort the stocks list by Country/Markets Please help.

Sergey Alexandrovich Kryukov 4-Mar-13 2:06am

Sorry, I have no idea of this API. I would only advice that you research the situation deeper and ask actual question (use "Improve question"), not just "can anyone help me?"...
—SA