Sqlserver,sqlite,access Database link string Collation _c language

sqlserver:string connection = "server=32.1.1.48;database= database name; user=sa;password=sa2008";

Access 2007:

A connection string without a password string

constr = "Provider=microsoft.ace.oledb.12.0;data source=e://111.accdb;　　　 　Persist security Info=false ";

Connection string with password string

constr = "Provider=microsoft.ace.oledb.12.0;data source=e://111.accdb;" Jet oledb:database password=111 ";

Access 2003:　

A connection string without a password string

constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e://111.mdb;　　　 　Persist security Info=false ";

Connection string with password string

constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e://111.mdb;" Jet oledb:database password=111 ";

Link Access database If there is a failure to start the application workgroup information file is missing may be link string link incorrect

Sqlite:　　　　

String constr = "Data source=e://111.db;" Password=111 ";

You need to add a reference when using SQLite system.data.sqlite,c# the mixed-mode assembly is prompted at run time for the "v2.0.50727" version of the runtime, and cannot load the assembly in the 4.0 runtime without additional information configured. This issue allows you to add a configuration section to the app.config: Startup

<startup uselegacyv2runtimeactivationpolicy= "true" >
<supportedruntime version= "v4.0"/>
</ Startup>