新书推介:《语义网技术体系》
作者:瞿裕忠,胡伟,程龚
   XML论坛     W3CHINA.ORG讨论区     计算机科学论坛     SOAChina论坛     Blog     开放翻译计划     新浪微博  
 
  • 首页
  • 登录
  • 注册
  • 软件下载
  • 资料下载
  • 核心成员
  • 帮助
  •   Add to Google

    >> 本版讨论.NET,C#,ASP,VB技术
    [返回] 中文XML论坛 - 专业的XML技术讨论区计算机技术与应用『 Dot NET,C#,ASP,VB 』 → .Net下各种数据库连接大全 查看新帖用户列表

      发表一个新主题  发表一个新投票  回复主题  (订阅本版) 您是本帖的第 12042 个阅读者浏览上一篇主题  刷新本主题   树形显示贴子 浏览下一篇主题
     * 贴子主题: .Net下各种数据库连接大全 举报  打印  推荐  IE收藏夹 
       本主题类别:     
     admin 帅哥哟,离线,有人找我吗?
      
      
      
      威望:9
      头衔:W3China站长
      等级:计算机硕士学位(管理员)
      文章:5255
      积分:18406
      门派:W3CHINA.ORG
      注册:2003/10/5

    姓名:(无权查看)
    城市:(无权查看)
    院校:(无权查看)
    兴趣:
    * XML相关技术
    * 资料收集
    * Ontology Engineering
    * Web架构
    * SW Implementation
    给admin发送一个短消息 把admin加入好友 查看admin的个人资料 搜索admin在『 Dot NET,C#,ASP,VB 』的所有贴子 点击这里发送电邮给admin  访问admin的主页 引用回复这个贴子 回复这个贴子 查看admin的博客楼主
    发贴心情 .Net下各种数据库连接大全


    发信人: minerva (cheng), 信区: DotNET
    标  题: .Net下各种数据库连接大全
    发信站: BBS 水木清华站 (Sun Sep 28 18:55:32 2003), 转信

    2003-1-20  动网先锋
    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;"
    OLEDB, OleDbConnection (.NET)
    Standard Security:
    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Passwor
    d=asdasd;"
    Trusted Connection:
    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Securit
    y=SSPI;"
    (use serverName\instanceName as Data Source to use an specifik SQLServer ins
    tance, 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;User ID=sa;Password=asdasd;"
    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is th
    e port to use (1433 is the default))
    SqlConnection (.NET)
    Standard Security:
    "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
    Trusted Connection:
    "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
    (use serverName\instanceName as Data Source to use an specifik SQLServer ins
    tance, only SQLServer2000)
    Connect via an IP address:
    "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=p
    ubs;User ID=sa;Password=asdasd;"
    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is th
    e port to use (1433 is the default))
    Declare the SqlConnection:
    C#:
    using System.Data.SqlClient;
    SqlConnection oSQLConn = new SqlConnection();
    oSQLConn.ConnectionString="my connectionstring";
    oSQLConn.Open();
    VB.NET:
    Imports System.Data.SqlClient
    Dim oSQLConn As SqlConnection = New SqlConnection()
    oSQLConn.ConnectionString="my connectionstring"
    oSQLConn.Open()
    Data Shape
    MS Data Shape
    "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catal
    og=pubs;User ID=sa;Password=asdasd;"
    Read more
    How to define wich network protocol to use
    Example:
    "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN
    ;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
    Name Network library
    dbnmpntw Win32 Named Pipes
    dbmssocn Win32 Winsock TCP/IP
    dbmsspxn Win32 SPX/IPX
    dbmsvinn Win32 Banyan Vines
    dbmsrpcn Win32 Multi-Protocol (Windows RPC)
    Important note!
    When connecting through the SQLOLEDB provider use the syntax Network Library
    =dbmssocn
    and when connecting through MSDASQL provider use the syntax Network=dbmssocn

    All SqlConnection connectionstring properties
    This table shows all connectionstring properties for the ADO.NET SqlConnecti
    on object. Most of the properties are also used in ADO. All properties and d
    escriptions is from msdn.
    Name Default Description
    Application Name   The name of the application, or '.Net SqlClient Data Prov
    ider' if no application name is provided.
    AttachDBFilename
    -or-
    extended properties
    -or-
    Initial File Name   The name of the primary file, including the full path na
    me, of an attachable database. The database name must be specified with the  
    keyword 'database'.
    Connect Timeout
    -or-
    Connection Timeout 15 The length of time (in seconds) to wait for a connecti
    on to the server before terminating the attempt and generating an error.
    Connection Lifetime 0 When a connection is returned to the pool, its creatio
    n time is compared with the current time, and the connection is destroyed if
    that time span (in seconds) exceeds the value specified by connection lifet
    ime. Useful in clustered configurations to force load balancing between a ru
    nning server and a server just brought on-line.
    Connection Reset 'true' Determines whether the database connection is reset  
    when being removed from the pool. Setting to 'false' avoids making an additi
    onal server round-trip when obtaining a connection, but the programmer must  
    be aware that the connection state is not being reset.
    Current Language   The SQL Server Language record name.
    Data Source
    -or-
    Server
    -or-
    Address
    -or-
    Addr
    -or-
    Network Address   The name or network address of the instance of SQL Server  
    to which to connect.
    Enlist 'true' When true, the pooler automatically enlists the connection in  
    the creation thread's current transaction context.
    Initial Catalog
    -or-
    Database   The name of the database.
    Integrated Security
    -or-
    Trusted_Connection 'false' Whether the connection is to be a secure connecti
    on or not. Recognized values are 'true', 'false', and 'sspi', which is equiv
    alent to 'true'.
    Max Pool Size 100 The maximum number of connections allowed in the pool.
    Min Pool Size 0 The minimum number of connections allowed in the pool.
    Network Library
    -or-
    Net 'dbmssocn' The network library used to establish a connection to an inst
    ance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpc
    n (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmsipcn (Shared M
    emory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).
    The corresponding network DLL must be installed on the system to which you c
    onnect. If you do not specify a network and you use a local server (for exam
    ple, "." or "(local)"), shared memory is used.
    Packet Size 8192 Size in bytes of the network packets used to communicate wi
    th an instance of SQL Server.
    Password
    -or-
    Pwd   The password for the SQL Server account logging on.
    Persist Security Info 'false' When set to 'false', security-sensitive inform
    ation, such as the password, is not returned as part of the connection if th
    e connection is open or has ever been in an open state. Resetting the connec
    tion string resets all connection string values including the password.
    Pooling 'true' When true, the SQLConnection object is drawn from the appropr
    iate pool, or if necessary, is created and added to the appropriate pool.
    User ID   The SQL Server login account.
    Workstation ID the local computer name The name of the workstation connectin
    g to SQL Server.
    Note
    Use ; to separate each property.
    If a name occurs more than once, the value from the last one in the connecti
    onstring will be used.
    If you are building your connectionstring in your app using values from user
    input fields, make sure the user can't change the connectionstring by inser
    ting an additional property with another value within the user value.
    Access
    ODBC
    Standard Security:
    "Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;P
    wd=asdasd;"
    Workgroup:
    "Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\s
    omepath\mydb.mdw;","admin", ""
    OLEDB, OleDbConnection (.NET)
    Standard security:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=adm
    in;Password=asdasd;"
    Workgroup (system database):
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:S
    ystem Database=system.mdw;","admin", ""
    With password:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:D
    atabase Password=MyDbPassword;","admin", ""
    Oracle
    ODBC
    New version:
    "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;P
    wd=asdasd;"
    Old version:
    "Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;
    Uid=myUsername;Pwd=myPassword;"
    OLEDB, OleDbConnection (.NET)
    Standard security:
    "Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
    This one's from Microsoft, the following are from Oracle
    Standard Security:
    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=a
    sdasd;"
    Trusted Connection:
    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
    OracleConnection (.NET)
    Standard:
    "Data Source=Oracle8i;Integrated Security=yes";
    This one works only with Oracle 8i release 3 or later
    Declare the OracleConnection:
    C#:
    using System.Data.OracleClient;
    OracleConnection oOracleConn = new OracleConnection();
    oOracleConn.ConnectionString = "my connectionstring";
    oOracleConn.Open();
    VB.NET:
    Imports System.Data.OracleClient
    Dim oOracleConn As OracleConnection = New OracleConnection()
    oOracleConn.ConnectionString = "my connectionstring"
    oOracleConn.Open()
    Data Shape
    MS Data Shape:
    "Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Da
    ta Source=orac;user id=username;password=mypw"
    MySQL
    ODBC
    Local database:
    "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
    Remote database:
    "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Databas
    e=my-database;Uid=username;Pwd=password;"
    OLEDB, OleDbConnection (.NET)
    Standard:
    "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
    MySqlConnection (.NET)
    EID:
    "Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logg
    ing=false"
    This one is used with eInfoDesigns dbProvider, an add-on to .NET
    Declare the MySqlConnection:
    C#:
    using EID.MySqlClient;
    MySqlConnection oMySqlConn = new MySqlConnection();
    oMySqlConn.ConnectionString = "my connectionstring";
    oMySqlConn.Open();
    VB.NET:
    Imports EID.MySqlClient
    Dim oMySqlConn As MySqlConnection = New MySqlConnection()
    oMySqlConn.ConnectionString = "my connectionstring"
    oMySqlConn.Open()
    IBM DB2
    OLEDB, OleDbConnection (.NET) from ms
    TCP/IP:
    "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.X
    XX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Sch
    ema;User ID=MyUser;Password=MyPW"
    APPC:
    "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote
    ;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;Us
    er ID=MyUser;Password=MyPW"
    Sybase
    ODBC
    Standard:
    "Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
    Intersolv 3.10:
    "Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;
    "
    Informix
    ODBC
    Informix 3.30:
    "Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=
    service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
    Informix-CLI 2.5:
    "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;Uid=userna
    me;Pwd=myPwd"
    DSN
    ODBC
    DSN:
    "DSN=myDsn;Uid=username;Pwd=;"
    File DSN:
    "FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"
    Excel
    ODBC
    Standard:
    "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;Def
    aultDir=c:\mypath;"
    OLE DB
    Standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Proper
    ties=Excel 8.0;HDR=Yes;"
    "HDR=Yes;" indicates that the first row contains columnnames, not data
    DBF / FoxPro
    ODBC
    standard:
    "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
    OLEDB, OleDbConnection (.NET)
    standard:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=
    dBASE IV;User ID=Admin;Password="
    Pervasive
    ODBC
    Standard:
    "Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
    UDL
    UDL
    UDL:
    "File Name=c:\myDataLink.udl;"

    --

    ※ 来源:·BBS 水木清华站 smth.org·[FROM: 210.42.97.154]
    上一篇
    返回上一页
    回到目录
    回到页首
    下一篇


       收藏   分享  
    顶(0)
      




    ----------------------------------------------

    -----------------------------------------------

    第十二章第一节《用ROR创建面向资源的服务》
    第十二章第二节《用Restlet创建面向资源的服务》
    第三章《REST式服务有什么不同》
    InfoQ SOA首席编辑胡键评《RESTful Web Services中文版》
    [InfoQ文章]解答有关REST的十点疑惑

    点击查看用户来源及管理<br>发贴IP:*.*.*.* 2004/11/9 2:26:00
     
     s3group 帅哥哟,离线,有人找我吗?巨蟹座1981-7-5
      
      
      等级:大二(研究C++)
      文章:48
      积分:274
      门派:XML.ORG.CN
      注册:2004/8/15

    姓名:(无权查看)
    城市:(无权查看)
    院校:(无权查看)
    给s3group发送一个短消息 把s3group加入好友 查看s3group的个人资料 搜索s3group在『 Dot NET,C#,ASP,VB 』的所有贴子 引用回复这个贴子 回复这个贴子 查看s3group的博客2
    发贴心情 
    Admin还真是苦于复制与粘贴啊, 希望能多些好东东. 让"中国XML论坛" 名扬天下.

    加油 ~~~~~~~~~

    点击查看用户来源及管理<br>发贴IP:*.*.*.* 2004/12/4 12:40:00
     
     xmzhy 帅哥哟,离线,有人找我吗?狮子座1978-8-18
      
      
      威望:5
      等级:计算机学士学位
      文章:385
      积分:2003
      门派:XML.ORG.CN
      注册:2003/10/22

    姓名:(无权查看)
    城市:(无权查看)
    院校:(无权查看)
    给xmzhy发送一个短消息 把xmzhy加入好友 查看xmzhy的个人资料 搜索xmzhy在『 Dot NET,C#,ASP,VB 』的所有贴子 引用回复这个贴子 回复这个贴子 查看xmzhy的博客3
    发贴心情 
    希望Admin放几个作品给新人学习。
    点击查看用户来源及管理<br>发贴IP:*.*.*.* 2004/12/7 15:34:00
     
     GoogleAdSense狮子座1978-8-18
      
      
      等级:大一新生
      文章:1
      积分:50
      门派:无门无派
      院校:未填写
      注册:2007-01-01
    给Google AdSense发送一个短消息 把Google AdSense加入好友 查看Google AdSense的个人资料 搜索Google AdSense在『 Dot NET,C#,ASP,VB 』的所有贴子 访问Google AdSense的主页 引用回复这个贴子 回复这个贴子 查看Google AdSense的博客广告
    2024/3/28 13:28:40

    本主题贴数3,分页: [1]

    管理选项修改tag | 锁定 | 解锁 | 提升 | 删除 | 移动 | 固顶 | 总固顶 | 奖励 | 惩罚 | 发布公告
    W3C Contributing Supporter! W 3 C h i n a ( since 2003 ) 旗 下 站 点
    苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》
    269.531ms