Sqlserver sqlite access database link string collation

SqlServer: string connection = "server=32.1.1.48; Database = database name; User = sa; Password = sa2008 ";

Access 2007:

//A passwordless connection string

string conStr = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=E://111.accdb;Persist Security Info=False";

　　　 　//A connection string with a password

string conStr = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=E://111.accdb;Jet OleDb:DataBase Password=111";

Access 2003:

//A passwordless connection string

string conStr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=E://111.mdb;Persist Security Info=False";

　　　 　//A connection string with a password

string conStr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=E://111.mdb;Jet OleDb:DataBase Password=111";

Link to access database if the application can not start the workgroup information file missing may be the link string link is not correct

Sqlite:

string conStr = "Data Source=E://111.db;Password=111";

When using SQLite, you need to add a reference to system.data.sqlite. C# will prompt you at runtime that the mixed mode assembly is generated for the "v2.0.50727" version of the runtime

<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0"/>
</startup>