Linux中国 Linux中国门户站!
设为主页 设为主页
收藏本站 收藏本站
 
当前位置 :首页 ->数据库应用 ->其他数据库 ->正文

数据库连接字符串大全

来源:Linuxdby.com 作者:Webmaster 时间:2007-06-03 点击: [收藏] [投稿]


  •  OLE DB

    •  Standard:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited"""
      "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;"


    •  OLE DB, OleDbConnection (.NET)

      •  standard:
        "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="


  •  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
  •  Visual FoxPro
  • 更多相关文章
    Power by linux-cn.com 粤ICP备05006655号