＋设为首页 ＋添加到收藏夹
数据库连接字符串大全
【程序编程相关:在VB.NET里操作文本文件】 很感谢creativepeter(头皮屑)提供的本连接地址（http://www.connectionstrings.com/） 【推荐阅读:汇编中的不同进制的输入与输出操作】 【扩展信息:[初学VB.net]如何通过控件的名称来】 sql server odbc standard security: "driver={sql server};server=aron1;database=pubs;uid=sa;pwd=asdasd;" trusted connection: "driver={sql server};server=aron1;database=pubs;trusted_connection=yes;" prompt for username and password: oconn.properties("prompt") = adpromptalways oconn.open "driver={sql server};server=aron1;database=pubs;" ole db, oledbconnection (.net) standard security: "provider=sqloledb;data source=aron1;initial catalog=pubs;user id=sa;password=asdasd;" trusted connection: "provider=sqloledb;data source=aron1;initial catalog=pubs;integrated security=sspi;" (use servername\instancename as data source to use an specifik sqlserver instance, only sqlserver2000) prompt for username and password: oconn.provider = "sqloledb" oconn.properties("prompt") = adpromptalways oconn.open "data source=aron1;initial catalog=pubs;" connect via an ip address: "provider=sqloledb;data source=190.190.200.100,1433;network library=dbmssocn;initial catalog= pubs;userid=sa;password=asdasd;" (dbmssocn=tcp/ip instead of named pipes, at the end of the data source is the port to use (1433 is the default)) sqlconnection (.net) standard security: "data source=aron1;initial catalog= pubs;userid=sa;password=asdasd;" - or - "server=aron1;database=pubs;userid=sa;password=asdasd;trusted_connection=false" (booth connection strings produces the same result) trusted connection: "data source=aron1;initial catalog=pubs;integrated security=sspi;" - or -< br>"server=aron1;database=pubs;trusted_connection=true;" (booth connection strings produces the same result) (use servername\instancename as data source to use an specifik sqlserver instance, only sqlserver2000) connect via an ip address: "data source=190.190.200.100,1433;network library=dbmssocn;initial catalog= pubs;userid=sa;password=asdasd;" (dbmssocn=tcp/ip instead of named pipes, at the end of the data source is the port to use (1433 is the default)) declare the sqlconnection: c#: using system.data.sqlclient; ... 下一页