DOCUMENT:Q217183  07-MAY-2001  [visualc]
TITLE   :FIX: GetPropertyInfo Not Returning Correct Values for Default Ca
PRODUCT :Microsoft C Compiler
PROD/VER:WINDOWS:6.0,6.0 SP3; winnt:6.0
OPER/SYS:
KEYWORDS:kbservicepack kbDatabase kbProvider kbVC600bug kbATL300bug kbVS600sp2bug kbVS600sp3fix

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual C++, 32-bit Enterprise Edition, version 6.0 
 - Microsoft Visual C++, 32-bit Professional Edition, version 6.0 
 - Microsoft Visual C++, 32-bit Learning Edition, version 6.0 
 - Microsoft Visual Studio, Enterprise Edition versions 6.0, 6.0 SP3 
-------------------------------------------------------------------------------

SYMPTOMS
========

After creating an OLE DB Provider with the ATL Wizard in Visual C++ 6.0, the
IDBProperties::GetPropertyInfo returns all of the DATASOURCEINFO properties
rather than the initialization properties; also, the GUID returned in the
DBPROPINFOSET structure is DBPROPSET_DBINITALL.

CAUSE
=====

This problem is caused by a bug in IDBPropertiesImpl::GetPropertyInfo(),
implemented in the ATL OLE DB header file Atldb.h.

RESOLUTION
==========

Install Visual Studio Service Pack 3 to get a corrected version of Atldb.h.

STATUS
======

Microsoft has confirmed this to be a bug in the Microsoft products 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:

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

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

MORE INFORMATION
================

According to the OLE DB documentation:

   If cPropertyIDSets is zero, the provider ignores rgPropertyIDSets. When
   called on the enumerator, the provider returns information about all
   properties in the Initialization property group. When called on the data
   source object, if the data source object has not been initialized, the
   provider returns information about all properties in the Initialization
   property group.

   Also regarding the GUID returned in DBPROPINFOSET and the special GUIDs like
   DBPROPSET_DBINITALL:

   These GUIDs are not returned in the guidPropertySet element of the
   DBPROPINFOSET structures returned in rgPropertyInfoSets. Instead, the GUID of
   the property set to which the property belongs is returned.

Steps to Reproduce Behavior
---------------------------

1. Create a new ATL COM project using the ATL COM AppWizard, and accept all
   default settings.

2. From the Insert menu, click New ATL Object.

3. Select Data Access in the left pane, then Provider in the list of objects.

4. Give the object a name.

5. Save and compile the project.

6. Debug the project and when asked for an executable, specify ITest.exe from
   the MS Data Access SDK (MSDASDK). If you need to install the MSDASDK, it can
   be found on CD 2 of Visual C++ or Visual Studio, under the DASDK directory.

7. Once ITest is running, right-click Win32[oledb Providers] and select
   CoCreateInstance.

8. Double-click the Value column of the first row to activate a drop down list
   of providers.

9. Select your provider from the list.

10. Select the ICW menu and then Execute.

11. Right-click your provider in the Object window and select IDBProperties and
   then GetPropertInfo from the sub-menu.

12. Ensure that cPropertyIDSets is set to 0 (zero).

13. Allocate memory for pcPropertyInfoSets by right-clicking the Value column
   and selecting AllocateMemory from the context menu.

14. Ensure prgPropertInfoSets and ppDescBuffer have memory allocated; you should
   see &NULL rather than NULL.

15. Select the ICW menu and then Execute.

16. Look at the results in the Output window.

RESULTS: You will get back all of the DATASOURCEINFO properties rather than the
initialization properties; also, the GUID returned in the DBPROPINFOSET
structure is DBPROPSET_DBINITALL.

Additional query words:

======================================================================
Keywords          : kbservicepack kbDatabase kbProvider kbVC600bug kbATL300bug kbVS600sp2bug kbVS600sp3fix kbGrpDSVCDB kbVS600SP1bug 
Technology        : kbVCsearch kbVSsearch kbAudDeveloper kbVC600 kbVC32bitSearch kbVS600SP3 kbVS600 kbVS600Search
Version           : WINDOWS:6.0,6.0 SP3; winnt:6.0
Issue type        : kbbug
Solution Type     : kbfix

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2001.