数据库连接字符串大全

日期:2007年8月8日 作者: 查看:[大字体 中字体 小字体]
Read more about connecting to Interbase in this Borland Developer Network article http://community.borland.com/article/0,1410,27152,00.html

  •  IBM DB2
    •  OLE DB, OleDbConnection (.NET) from ms

      •  TCP/IP:
        "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"


      •  APPC:
        "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"


    •  IBM's OLE DB Provider (shipped with IBM DB2 UDB v7 or above)

      •  TCP/IP:
        Provider=IBMDADB2;Database=sample;HOSTNAME=db2host;PROTOCOL=TCPIP;PORT=50000;uid=myUserName;pwd=myPwd;


    •  ODBC

      •  Standard:
        "driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd"


  •  Sybase
  • 精品推荐

    热点TOP10

    特别推荐