在asp.net中的web程序的设置中我们必须用到web.config来存储数据库连接字.事实上这是个
很好的做法,因为可以省去我们很多的麻烦还可以帮助我们避免不必要的错位,是的很多情况下
我就是这样做.它通过xml来记录这些信息.具体的是在<appsettings>....</appsettings>这个
标记中来记录的.这里请看一个oracle的例子如下:
<appsettings>
<add key="oracleconnectionstring" value="provider=oraoledb.oracle.1; persist security info=false;password=blah;user id=greg;data source=sph;" /> <add key="sqlconnectionstring" value="data source=sql1;initial catalog=id_v; integrated security=sspi;persist security info=false;workstation id=th03d374; packet size=4096"/> <appsettings>
而在你的应用程序中你只要这样写,就可以了,如下:
string conn = configurationsettings.appsettings["oracleconnectionstring"];
oledbconnection myconnection = new oledbconnection(conn);
很轻松是吗?不必每次都输入同样的连接字,也不要记住那些讨厌的信息了,只需要起一个好记的
名字就可以.
好了下面我在来给出其他的一些连接字
mysql的连接字
:
connectionstring = "data source=localhost;" + "database=mysqldatabase;" + "user id=myusername;" + "password=mypassword;" + "command logging=false"; ole db 的 :ibm as/400 ole db 的
' vb.net
dim ooledbconnection as oledb.oledbconnection dim sconnstring as string = _ "provider=ibmda400.datasource.1;" & _ "data source=myas400dbname;" & _ "user id=myusername;" & _ "password=mypassword" ooledbconnection = new oledb.oledbconnection(sconnstring) ooledbconnection.open() oracle ole db 的
' vb.net
dim ooledbconnection as oledb.oledbconnection dim sconnstring as string = _ "provider=oraoledb.oracle;" & _ "data source=myoracledb;" & _ "user id=myusername;" & _ "password=mypassword" ooledbconnection = new oledb.oledbconnection(sconnstring) ooledbconnection.open() sql server ole db 的
' vb.net
dim ooledbconnection as oledb.oledbconnection dim sconnstring as string = _ "provider=sqloledb;" & _ "data source=myservername;" & _ "initial catalog=mydatabasename;" & _ "user id=myusername;" & _ "password=mypassword" ooledbconnection = new oledb.oledbconnection(sconnstring) ooledbconnection.open()
sql server在system.data.sqlclient
sqlconnection osqlconn = new sqlconnection();
osqlconn.connectionstring = "data source=(local);" + "initial catalog=mysqlserverdbname;" + "integrated security=sspi"; osqlconn.open();
1、SQL Server的连接方式
以本地服务器(LocalHost),数据库(Northwind)为例,可以有以下一些连接方式 SqlConnection conn=new SqlConnection( "Server=LocalHost;Integrated Security=SSPI;Database=Northwind"); SqlConnection conn = new SqlConnection("Data Source=LocalHost;Integrated Security=SSPI;Initial Catalog=Northwind;"); SqlConnection conn = new SqlConnection(" Data Source=LocalHost;Initial Catalog=Northwind;Integrated Security=SSPI;Persist Security Info=False;Workstation Id=XURUI;Packet Size=4096; "); SqlConnection myConn = new SqlConnection("Persist Security Info=False;Integrated Security=SSPI;Database=northwind;Server=LocalHost"); SqlConnection conn = new SqlConnection(" Uid=sa;Pwd=***;Initial Catalog=Northwind;Data Source=LocalHost;Connect Timeout=900"); 心得: a.Server 和Database,Data Source和Initial Catalog配对使用的,可以互相替换(见笑) b.Integrated Security 默认值是False,此时需要提供Uid和Pwd,即将以Sql Server 用户身份登陆数据库;如果设置为True,Yes 或 SSPI,这不能出现Uid和Pwd,将以Windows用户省份登陆数据库。强烈推荐用后一种形式,安全性更高。 c.Integrated Security 和Persist Security Info同时出现,后者设置为False,可保证信息安全。 |
数据库常用连接字符串
最新推荐文章于 2021-09-02 16:30:35 发布