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"
你要用客户端配置工具,指定服务器主机名或者IP地址,然后指定端口,还有数据库名,数据库本地别名。 之后才可以用命令行窗口访问:connect to "数据库名" user "用户名" using " 密码" 你还是先安装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"
之后才可以用命令行窗口访问:connect to "数据库名" user "用户名" using " 密码"
你还是先安装DB2完整客户端吧,最好带客户端配置向导的那个
http://www.connectionstrings.com
再问一下,db2客户端怎么连到服务器啊,用什么命令?
没用过db2,一头雾水...