SQLite 2.0 and C#

Tomas

Hi, I have one old database type of SQLite 2.0 and I need export data but I 've got no idea how to do it. Visual studio do not (or i did not find it) have a libary that can work with this type of database. Does anybody have a idea to solve this problem? thx

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted answer
Friend,

Mail me the DBFile i will let you know weather its working or not

send the file in mail : [email protected]
0
Kirtan Patel17y ago
Friend,

its Very Hard to Find Version of SQl Lite Database

and We Cant Connect it Using .net Still If data Is important for you then Access it using One Utility

bu it has no data Inside the file you Provided Except One Table(Clanky) with No Data

just Table Structure is There

Utility to Open That Data base is

Download Utility

and Friend,

Please mark "Do you like this answer" :)

0
Tomas17y ago
Thx Kirtan, I have installed "ADO.NET 2.0 Provider for SQLite", I try to connect..

DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");
            using (DbConnection cnn = fact.CreateConnection())
            {
                cnn.ConnectionString = "Data Source=poradca.sdb";
                cnn.Open();
            }

and result is an exception:
"File opened that is not a database file, file is encrypted or is not a database"
but file is good

And file is type sqlite 2.0

thx
0
Kirtan Patel17y ago
Here is SQLite connector for .net that will add new name-space in your Visual Studio

Download SQLite Connector.net

that is

System.Data.SQLite;

then you can fill the DataSet From the Database and Write All DataSet Tables Rows to Some other Database

:)

if my answer Helped you check "Do you like this answer" please :)

0