数据库连接字符串大全

日期：2007年8月8日作者：查看:[大字体中字体小字体]

Note
Use ; to separate each property.
If a name occurs more than once, the value from the last one in the connection string will be used.
If you are building your connection string in your app using values from user input fields, make sure the user can't change the connection string by inserting an additional property with another value within the user value.

SQL Server 2005

SQL Native Client ODBC Driver
- Standard security:
  
  "Driver={SQL Native Client};Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;"
- Trusted connection:
  
  "Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
  
  Equivalents
  Integrated Security=SSPI equals Trusted_Connection=yes
- Prompt for username and password:
  
  oConn.Properties("Prompt") = adPromptAlways
  oConn.Open "Driver={SQL Native Client};Server=Aron1;DataBase=pubs;"
- Enabling MARS (multiple active result sets):
  
  "Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;MARS_Connection=yes"
  
  Equivalents
  MultipleActiveResultSets=true equals MARS_Connection=yes
  
  Using MARS with SQL Native Client, by Chris Lee >>
- Encrypt data sent over network:
  
  "Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;Encrypt=yes"
- Attach a database file on connect to a local SQL Server EXPress instance:
- 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] 下一页
- 数据库连接字符串大全相关文章：
- ·春节新年新春对联大全
- ·香港三级片名单大全 (包括演员名单)
- ·经典歇后语大全
- ·感人情书大全-情书经典
- ·路由器安全设置详解
- ·英语格言大全
- ·古代情诗：伤感浪漫悲伤情诗大全
- ·CPU型号大全总结
- ·幻世录2魔神战争完全物品列表 - 游戏攻略
- ·男女生英文名大全-给自己起个好名字
- 数据库连接字符串大全相关软件
- ·瑞星杀毒软件 2007 V19.32.12 完全免费版
- ·火影忍者-忍术全开
- ·Kaspersky(卡巴斯基) KIS 安全套装 V6.0.2.621 MP2 简体中文正式免激活版
- ·中国法律法规大全(电子版) V3.3
- ·生活宝典系列之——家常美食菜谱大全(完整版) V3.0.3
- ·全能音频转换通 V1.2
- ·全能格式转换(Konvertor) V3.45.1 汉化版
- ·魔法门英雄无敌3全集
- ·《暗黑破坏神2毁灭之王》v1.11地图全开工具EasyMap_v11
- ·《仙剑奇侠传2》全过程存档
- 特别声明：本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作
- 者.文章版权归文章原始作者所有.对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转
- 载的文章有版权问题请联系编辑人员,我们尽快予以更正. 转载请注明来源：http://www.hackhome.com

数据库连接字符串大全

精品推荐

热点TOP10

特别推荐