数据库连接字符串

aizhuao7642

于 2015-11-16 15:09:00 发布

阅读量77

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/xinzheng/p/4968952.html

版权

oracle:ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.5)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myoracle)));User Id=system;Password=00000000;

sql server:Data Source=.;Initial Catalog=hospital;User ID=sa;Password=11

mysql:server=localhost;User Id=root;database=granaryobserve;password=123;SslMode = none;

access:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;User ID=Admin;Jet OLEDB:Database Password=123

基于服务 Data Source=.\SQLEXPRESS;AttachDbFilename=Database.mdf.mdf;Integrated Security=True;User Instance=True

WinCe SqlCe:

connection.ConnectionString = ("Data Source =" 
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) 
                        + ("\\AppDatabase1.sdf;" 
                        + ("Password =" + "\"a@123456\";"))));