vc2010 mfc 连接DB2数据库

Question

求问VC 2010 mfc 程序 用ADO对象连接DB2数据库 connectstring 到底该怎么写呀
试了网上好几种方式都连接不上

Answer 1

 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;