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

数据库连接字符串大全

来源:Linuxdby.com 作者:Webmaster 时间:2007-06-03 点击: [收藏] [投稿]
  •  Standard
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myDb;Extended Properties=Paradox 5.x;"
    MS kb-article: How to use Paradox data with Access and Jet >>


  •  DSN
    •  ODBC

      •  DSN:
        "DSN=myDsn;Uid=username;Pwd=;"


      •  File DSN:
        "FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"


  •  Firebird
    •  ODBC - IBPhoenix Open Source

    •  .NET - Firebird .Net Data Provider

  •  Excel
    •  ODBC

      •  Standard:
        "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"
        TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
    •  OLE DB

      •  Standard:
        "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
        "HDR=Yes;" indicates that the first row contains columnnames, not data
        "IMEX=1;" tells the driver to always read "intermixed" data columns as text
        TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
  •  Text
  • 更多相关文章
    Power by linux-cn.com 粤ICP备05006655号