请问如何在VC6中连接DB2数据库
------解决方案--------------------------------------------------------
OLE DB, OleDbConnection (.NET) 微软公司提供的驱动
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=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提供的OLE DB适配器
TCP/IP
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;
Protocol=TCPIP;Port=50000; Uid=myUsername;Pwd=myPassword;
ODBC
标准
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;
Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
------解决方案--------------------------------------------------------
http://www.connectionstringsMicrosoft OLEDB provider for DB2.com/ibm-db2
Microsoft OLEDB provider for DB2
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;
IBM OLE DB Provider for DB2
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword;