Click here to Skip to main content
12,350,735 members (27,584 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB VB.NET
Hi now i am using sqlite for windows forms but while running the project it is showing the error----Unable to load DLL sqlite3. The specified module could not be found. (Exception from HRESULT: 0x8007007E);

i had added the dll of system.data.sqlite.dll...but it is showing the same error...so please any one help me by giving the perfect answer regarding this problem....thanks in advance

MY connection string:

 Private sql_con As New SQLiteConnection
sql_con = New SQLiteConnection(Data Source=D:\iact\Data_Main.sqlite;Version=3;New=False;Compress=True;)
       sql_con.Open()

Thanks
Pallavi
Posted 11-Oct-12 21:47pm
Edited 11-Oct-12 22:58pm
DaveAuld187K
v2
Comments
DaveAuld 12-Oct-12 4:59am
   
Have you added a reference to the project and an imports to the code.
pallavi Praharaj 12-Oct-12 5:33am
   
Yes i have added the reference and imports to the code
n.podbielski 12-Oct-12 5:45am
   
This dll have many versions for different .net versions, different systems itp.
You probably using wrong one.
Use NuGet to add Sqlite to you project. This manager should take care of this problem.
Wes Aday 12-Oct-12 10:54am
   
Is that file in your bin folder or avaiable via your PATH variable?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

It looks like you have a 64 bit version of windows. You need to compile your application in 32 bit because their are no 64 bit drivers for SqlLiteConnect. Go to your project properties then compile, and make sure the Platform is (x86). If it is already x86 then try just using the data source. I am not very familiar with the SQLight but if you ever change to MySQL I can help you in great depth their.
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 14 Oct 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100