各类数据库连接方法汇集

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;
      SqlConnection oSQLConn = new SqlConnection();
      oSQLConn.ConnectionString="my connectionstring";
      oSQLConn.Open();