Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I am developing a C# application with visual studio 2010 and SQLite as my database.

I have added the following references to my project:
SQLite.Net.dll and System.Data.SQLite.dll

I am try to insert data into a table in my database.db using one of the two using directives:
using System.Data.SQLite;
using Finisar.SQLite;

When i use System.Data.SQLite, the following exception is thrown:
SQLite error
no such table: Table1

But when i use Finisar.SQLite, the following exception is thrown:
Unable to load DLL 'coredll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

What could be the problem please.

Any help is really appreciated

Thanks in advance

Regards
Posted
Comments
Prasad Khandekar 6-Apr-13 16:11pm    
As far as System.Data.SQLite is concerned the error is pretty obvious, it says Table1 does not exists. So check whether that table exists in the SQLite database, if not you will have to create it first either programmatically or using one of the SQLite browsers such as (sqlitebrowser.sourceforge.net/ OR http://portableapps.com/apps/development/sqlite_database_browser_portable OR http://sqliteadmin.orbmu2k.de/).

The Finisar SQLLite is a thin wrapper around SQLite C DLL and the error probably indicates that the wrapper was not able to load the Underlying C library. So please check whether the Finisar ADO.NET SQLLite driver is installed properly or not.

Regards.

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