常用数据库连接字符串结构
1.SQLServer
连接
Provider=SQLOLEDB.1;Password=;Persist Security Info=True;trusted_connection=no;User ID=;Initial Catalog=;Data Source=
2.Orcal连接Provider=OraOLEDB.Oracle;Data Source=;User Id=;Password=;
3.Access连接
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
4.MySql连接
Provider=MySQLProv;Data Source=;User Id=;Password=;
5.Excel连接
Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Persist Security Info=False;Data Source=
6.FoxPro DBF文件连接
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties=dBASE IV;
|