VB6,C#连Sql server,Mysql,sqlite,access等数据库的连接字符串

概述(1), VB6 连 Sql Server Provider=SQLOLEDB.1;Password=Pwd;Persist Security Info=True;User ID=UserName;Initial Catalog=DataBase_Name;Data Source=IP_Address (2), C#连 Sql Server            1,Windows验证      

(1),VB6 连 sql Server

ProvIDer=sqlolEDB.1;Password=Pwd;Persist Security Info=True;User ID=Username;Initial Catalog=DataBase_name;Data Source=IP_Address

(2),C#连 sql Server

1,windows验证 Common.ConnString = @"Initial Catalog=数据库名;Data Source=电脑名或IP地址;Integrated Security=sspI";

2,sql混合验证Common.ConnString = @"server=电脑名或IP地址;database=数据库名;uID=用户名;password=密码";

(3),C#连MysqL

MysqLHelper.ConnString = string.Format(@"server={0};database={1};userID={2};password={3}"
,txtServer.Text,txtDBname.Text,txtUID.Text,txtPwd.Text);

(4),C#连sqlite

string.Format(@"Data Source={0}",ConnsqlliteDbPath); //ConnsqlliteDbPath 为 **.db文件的具体路径

(5),C#连access

string sDB_Path = Application.StartupPath.Replace(@"\bin\DeBUG","") + @"\Data\#test.mdb";
//Jonsetool.AccessHelper.ConnString = @"ProvIDer=Microsoft.Jet.olEDB.4.0;Data Source=" + sDB_Path + @";Persist Security Info=false;User ID=admin;Password=";
Jonsetool.AccessHelper.ConnString = @"ProvIDer=Microsoft.Jet.olEDB.4.0;Data Source=" + sDB_Path + @";";

------------------------------------------------------------------------------------------------------

总结

以上是内存溢出为你收集整理的VB6,C#连Sql server,Mysql,sqlite,access等数据库的连接字符串全部内容，希望文章能够帮你解决VB6,C#连Sql server,Mysql,sqlite,access等数据库的连接字符串所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。