|
Problem IC67882
|
Status: Closed |
No objects in Server Exporer in Visual Studio 2005 and 2008 when using the DB2 ODBCor JDBC type 2 driver CLI layer. |
| product: |
DB2 CONNECT / DB2CONNCT / 950 - 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: *
* No objects in Server Exporer in Visual Studio 2005 and 2008 *
* when *
* using the DB2 ODBC or JDBC type 2 driver going through 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 v9.5 fix pack 6 *
**************************************************************** |
| 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. Restart Visual Studio. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fix in 9.5 fix pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.04.2010
15.09.2010
15.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
