I have finally resolved the DB2 connection error. The problem was with the OLE DB Provider for IBM DB2. According to Microsoft OLE DB specification, the TABLES Rowset must contain TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE columns. If any provider does not support TABLE_CATALOG or...
Thanks Shaixpeare for your comment. I am new to DB2 and do not know how to turn on ODBC tracing. However I have debugged my code and the result is as follows: When I debug the code the problem does not seem to occur. When I just run the program it occurs. Also the problem does not occur...
I am using ADO to connect to DB2 via an ODBC DSN from an application program written in VC++ 6.0/MFC. I call ADODB::Connection::OpenSchema method to get the list of tables. After that I iterate through the returned TABLES Rowset to retrieve the list of table names and the list of fields in each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.