vc中如何通过ADO访问DB2数据库？（急，在线）

Question

如何配置连接字符串？我都要Crazy了。

Answer 1

hr = m_pConnection->Open("Data Source=smsdb;UID=db2admin;PWD=db2admin;","","",adModeUnknown);

Answer 2

ADO好像不支持DB2，只能用ODBC或OLE DB

Answer 3

http://www.codeproject.com/database/alxbase.asp

Answer 4

If you are using a TCP/IP connection:strConnect = _T("Provider=DB2OLEDB;Network Transport Library=TCPIP;"
        "Network Address=130.120.110.001;"
        "Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;"
        "Default Schema=MySchema;User ID=MyUsername;Password=MyPassword;");If you are using APPC connection:strConnect = _T("Provider=DB2OLEDB;APPC Local LU Alias=MyLocalLUAlias;"
        "APPC Remote LU Alias=MyRemoteLUAlias;Initial Catalog=MyCatalog;"
        "Package Collection=MyPackageCollection;Default Schema=MySchema;"
        "User ID=MyUsername;Password=MyPassword;");