Click here to Skip to main content
15,886,067 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:

VB
 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
Updated 11-Oct-12 22:58pm
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.
[no name] 12-Oct-12 10:54am    
Is that file in your bin folder or avaiable via your PATH variable?

1 solution

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.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900