DOCUMENT:Q193347  29-SEP-1998  [vbwin]
TITLE   :PRB: Data Environment and MS Data Shape Provider
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:WINDOWS:6.0
OPER/SYS:WINDOWS
KEYWORDS:

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

 - Microsoft Visual Basic Enterprise Edition for Windows, version 6.0
---------------------------------------------------------------------

SYMPTOMS
========

When attempting to use the Query Designer against the MS Shape Provider in
the Data Environment, the following error message is returned:

   Query Designer encountered a ADODB.Properties error:
   Query Designer encountered a ADODB.Properties error:
   Query Designer encountered a ADODB.Properties error:
   ADO could not find the object in the collection corresponding to the
   name or ordinal reference requested by the application.(11)

Upon clicking OK, a second error message is returned:

   Object Variable or With block variable not set.

STATUS
======

This behavior is by design.

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

The Query Designer cannot be used to build hierarchical queries against the
shape provider. If you want to build a hierarchical query via the DE, you
can use the Query Designer for each separate query, and then use the
property pages on the data environment to specify the relationship between
the queries. The Query Designer is not able to talk directly to the
DataShape provider.

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

1. Create a Standard EXE project in Visual Basic. Form1 is created
   default.

2. Add a data environment.

3. For connection1 properties, set provider to MS Data Shape, and set
   the data source to Nwind (you can just type the dsn name here).

4. Click OK.

5. Add a new command.

6. For Command1 properties select SQL Statement, then click on SQL
   Builder.

7. Note that the Error messages above are returned.

REFERENCES
==========

For more information about the Visual Basic Data Environment or the
MSDataShape OLE DB provider, please refer to your Visual Basic Online
documentation.

Additional query words: kbDSupport kbdse kbVBp600 kbDesigner kbVBp
kbDataEnv
======================================================================
Version           : WINDOWS:6.0
Platform          : WINDOWS
Issue type        : kbprb

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

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 1998.