常用几种数据库连接字符串

Microsoft SQL server

windows安全登陆

"Data Source=(local); Initial Catalog=Northwind; Integrated Security=True;"

SQL Server登陆

"Data Source=(local); Initial Catalog=Northwind; UserID=sa; PassWord=111111;"

 

Access

"Provider=Microsoft.jet.oledb.4.0; Data Source=d:\myDB.mdb"

 

Excel

"Provider=Microsoft.jet.oledb.4.0; Data Source=d:\myExcel.xls; Extended Properties=Excel8.0"

posted @ 2010-07-25 13:39  海乐学习  阅读(366)  评论(0)  编辑  收藏  举报