数据库连接字符串代码大全（收藏）资源-CSDN文库

.NET,Sqlconnection,SQL

server,MySQL,Access

4星 · 超过85%的资源需积分: 10 69 浏览量 2012-03-05 16:20:36 上传评论收藏 159KB DOC 举报

资源推荐

资源详情

资源评论

数据库连接字符串大全(收藏)

兰杉 hp://www.knowsky.com/339545.html 2012-3-1

转自：http://www.connectionstrings.com/

 SQL Server

 ODBC

o Standard Security:

"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

o Trusted connection:

"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

o PRompt for username and passWord:

oConn.Properties("Prompt") = adPromptAlways

oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"

 OLE DB, OleDbConnection (.NET)

o Standard Security:

"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

o Trusted Connection:

"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"





o Prompt for username and password:

oConn.Provider = "sqloledb"

oConn.Properties("Prompt") = adPromptAlways

oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"

o Connect via anipaddress:

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial

Catalog=pubs;User ID=sa;Password=asdasd;"

 !"#!$%&$'('$)'())

*+,,)'(

 SqlConnection (.NET)

o Standard Security:

"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

---.--.

"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"

---/)0')

o Trusted Connection:

"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"

---.--.

"Server=Aron1;Database=pubs;Trusted_Connection=True;"

---/)0')





o Connect via an IP address:

"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User

ID=sa;Password=asdasd;"

 !"#!$%&$'('$)'())

*+,,)'(

o Declare the SqlConnection:

!12

0334!5

4!!"64!5

!3!0"7075

!3 5

839#2

&334!

!:4!"64!

剩余25页未读，继续阅读

内容反馈

tianya9909

2014-05-08

很不错。对于不熟悉的人可以看看

LanShan69

粉丝: 7
资源: 3

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip