C#下如何连接远程DB2数据库,最好有实际的例子参考一下
不知道那个URL如何写,假设数据库名字是DBTEST,所在主机的IP是:192.168.0.151,请问如何连到这个数据库上面?谢谢! --------------------编程问答-------------------- 没人知道吗? --------------------编程问答-------------------- OLE DB, OleDbConnection (.NET) from MicrosoftTCP/IP
Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
APPC
Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
IBM's OLE DB Provider (shipped with IBM DB2 UDB v7 or above)
TCP/IP
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP;Port=50000; Uid=myUsername;Pwd=myPassword;
ODBC
Standard
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
--------------------编程问答-------------------- 你怎么连接本机的数据库就怎么连接远程的数据库,只是把IP地址更改为192.168.0.151就可以了 --------------------编程问答-------------------- 把计算机名改成ip地址即可!!
补充:.NET技术 , C#