|
Problem IC68143
|
Status: Closed |
Issue with Visual Studio 2005 and 2008 when using the DB2 ODBC or JDBC type 2 driver CLI layer. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
When using Visual Studio 2005 or Visual Studio 2008, no objects
will be displayed in the Server Explorer for the following
objects: Tables, views, procedures and functions folders
This happens only when using Visual Studio with the ODBC driver
or the JDBC driver type 2 connection. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Issue with Visual Studio 2005 and 2008 when using the DB2 *
* ODBC *
* or JDBC type 2 driver CLI layer. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When using Visual Studio 2005 or Visual Studio 2008, no *
* objects *
* will be displayed in the Server Explorer for the following *
* *
* objects: Tables, views, procedures and functions folders *
* *
* *
* *
* This happens only when using Visual Studio with the ODBC *
* driver *
* or the JDBC driver type 2 connection. *
****************************************************************
* RECOMMENDATION: *
* Please move to fix pack 3 for v9.7 *
**************************************************************** |
| Local Fix: |
To workaround this issue:
Step 1. add the following two key words to your db2cli.ini file
under either [COMMON] or [DSN] section:
RetCatalogAsCurrServer=1
UseSchemaQueries=1
Step 2. Once that is done please restart Visual Studio. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in fix pack 3 in v9.7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.04.2010
23.09.2010
23.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
