PRB: Intellidrop Causes Multiple Logins with Remote View

 Last reviewed: October 29, 1996
Article ID: Q157524
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, version 5.0

SYMPTOMS

Each time you drag and drop a field from a Remote View to a Form or Report, the server Login dialog box is invoked.

CAUSE

The server login information for the remote view is not cached; it is dynamically retrieved as needed.

WORKAROUND

If the Remote View is based on datasource, issue the USE command to open the Remote View first. Then when you drag and drop fields, Intellidrop can get the information from the opened view.

-or-

Create the Remote View based on a Connection instead of a datasource. Then when you drag and drop fields, Intellidrop can get the login information from the connection and does not prompt for the server login again.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a database.

  2. Create a Remote View in the database.

  3. Create a form.

  4. Add the previously created Remote View to the DataEnvironment of the new form.

  5. Drag a field from the Remote View in the DataEnvironment to the form.

  6. Drag another field to the form.

When the first field is dragged to the form, the server login dialog box appears. When the second field is dragged on to the form, the server login dialog box comes up again.

KBCategory: kbprg kbprb
KBSubcategory: FxprgClientsvr FxprgTable
Additional reference words: 5.00 kbdse VFoxWin



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.

Last reviewed: October 29, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.