Error when connecting to SQLite using SqlConnection, why?

Question

I'm trying to connect to a local database (a ".db" file in my computer) but I get an error when I try to open the connection.

I'm using Sharp Develop (I can't use the connection wizard of Visual Studio to get the con. String).

    String connectionString = @"Data Source=C:\Users\Adl\Documents\BBDD_Test.db";
    var c = new SqlConnection(connectionString);
    c.Open();

The error :

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What's happening ?

Then you can't use SqlConnection, that's for Sql Server. You need to download System.Data.Sqlite and use that instead — Pikoh
– Pikoh, Commented Jul 4, 2017 at 9:59
Possible duplicate of What is the best way to connect and use a sqlite database from C# — Liam
– Liam, Commented Jul 4, 2017 at 10:03
Its not a sqllite connection "var c = new SqlConnection(connectionString);" — Vinothkk
– Vinothkk, Commented Jul 4, 2017 at 10:06

Wasim · Accepted Answer · 2017-07-04 10:34:53Z

You are using SqlConnection for SQLite database file(.db).

You will have to download an ADO.NET provider for SQLite or just add System.Data.SQLite.dll to your solution. Now you use certain classes of SQLite viz. SQLiteConnection, SQLiteCommand and SQLiteDataAdapter.

String connectionString = @"Data Source=D:\Users\wkhan2\Downloads\chinook\chinook.db";

        System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(connectionString);
        System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand("select * from table");
        cmd.Connection = conn;

        conn.Open();
        cmd.ExecuteScalar();
        System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
        System.Data.DataSet ds = new System.Data.DataSet();

        da.Fill(ds);

The rest is similar to ado.net i.e for binding DataSet.

Well I did not use SharpDevelop rather used visual studio, hope it works

Collectives™ on Stack Overflow

Error when connecting to SQLite using SqlConnection, why?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related