数据库连接字符串大全

日期:2007年8月8日 作者: 查看:[大字体 中字体 小字体]
  •  AS/400 (iSeries)
    •  OLE DB, OleDbConnection (.NET)

      •  IBM Client Access OLE DB provider:
        "PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;USER ID=myUserName;PASSWORD=myPwd"
        Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator
      •  IBM Client Access OLE DB provider:
        "PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;USER ID=myUserName;PASSWORD=myPwd;DEFAULT COLLECTION=MY_LIBRARY;"
        Where MY_SYSTEM_NAME is the name given to the System Connection, and MY_LIBRARY is the name given to the library in iSeries Navigator.
    •  ODBC

      •  IBM Client Access ODBC driver:
        "Driver={Client Access ODBC Driver (32-bit)};System=my_system_name;Uid=myUserName;Pwd=myPwd"
  •  Exchange
    •  OLE DB

      •  Exchange OLE DB provider:
        "ExOLEDB.DataSource"
        Specify store in the connection open command like this: conn.open "http://servername/mypublicstore"

        Check out this article at msdn >> and this one at Addison-Wesley >>
  •  Visual FoxPro
  • 精品推荐

    热点TOP10

    特别推荐