Microsoft KB Archive/217186

= FIX: Default Schema Rowsets Do Not Return NULL Columns =

Article ID: 217186

Article Last Modified on 4/22/2003

-

APPLIES TO

 Microsoft OLE DB 2.7, when used with:  Microsoft Visual C++ 6.0 Enterprise Edition

 Microsoft Visual C++ 6.0 Professional Edition

 Microsoft Visual C++ 6.0 Standard Edition 

-

<div class="notice_section">

This article was previously published under Q217186

<div class="symptoms_section">

SYMPTOMS
When you retrieve a schema rowset from an OLE DB provider created using the ATL OLE DB Provider Wizard, the TABLE_CATALOG and TABLE_SCHEMA columns return a status of DBSTATUS_S_OK and a zero length DBTYPE_WSTR value. According to the OLE DB specification 2.0. If a provider does not support the IDBInfo interface (and a default ATL OLE DB Provider Wizard generated OLE DB provider does not), then the provider must return DBSTATUS_S_ISNULL for all TABLE_CATALOG and TABLE_SCHEMA columns in schema rowsets.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3. For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed

<div class="moreinformation_section">

MORE INFORMATION
The following information is taken from the OLE DB Programmer's Reference, Appendix B Schema Rowsets.

"If a provider returns non-NULL CATALOG or SCHEMA column values in schema rowsets, it must support IDBInfo to describe how a fully qualified name is assembled. A provider that does not support IDBInfo must return NULL values for CATALOG and SCHEMA columns in all schema rowsets."

Since an ATL OLE DB Provider Wizard generated OLE DB provider does not support the IDBInfo interface, it does not follow the OLE DB specification when it returns zero length strings in the TABLE_CATALOG and TABLE_SCHEMA schema rowset columns.

You can test a particular ATL OLE DB Provider as seen below, by using the RowsetViewer tool that ships with the Microsoft Data Access SDK 2.0.


 * 1) Open RowsetViewer.
 * 2) Point to Select File and click Full Connect.
 * 3) Select your ATL OLE DB Provider Wizard generated OLE DB provider in the Provider drop down menu and click OK.
 * 4) Point to Select Session and click IDBSchemaRowset and GetRowset.
 * 5) Select DBSCHEMA_TABLES and click OK.
 * 6) Double-click the single returned row and check the status flags for the TABLE_CATALOG and TABLE_SCHEMA columns.

If the status flags are set to DBSTATUS_S_ISNULL, the Provider is displaying the correct behavior. If the status flags are set to DBSTATUS_S_OK, the Provider is not following the OLE DB 2.0 specification.

<div class="references_section">