数据库连接字符串列表

点击类别，查看相应的连接字符串(本页仅支持IE浏览器):
  •  SQL Server
    •  ODBC


    •  Standard Security（标准的安全模式）:
      "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=myUsername;Pwd=myPassword;"
    •  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;"