Q137944: HOWTO: How to Create a Remote Connection or View Programmaticall

Article: Q137944
Product(s): Microsoft FoxPro
Version(s): WINDOWS:2.5,3.0
Operating System(s): 
Keyword(s): kbMDAC250
Last Modified: 22-FEB-2000

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

- Microsoft Visual FoxPro for Windows, version 3.0 
- Microsoft Data Access Components version 2.5 
-------------------------------------------------------------------------------

SUMMARY
=======

This article shows by example how to create remote connections and remote views
programmatically.

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

The following code creates a database in which to store the remote view and
remote connection. The remote connection is created first, and then the remote
view is created by using the remote connection.

The data source used in this example is Sqltest, which is the name of the
corresponding SQL Server ODBC driver that exists in the ODBC driver manager. The
Pubs database comes with Microsoft SQL Server and contains a table called
Sales.

     CLOSE ALL
     SET DEFAULT TO c:\temp
     * A view cannot exist without a database.
     * Create a database to contain view.
     CREATE DATABASE zdb

     * Create a connection for the view to use.
     CREATE CONNECTION zconn DATASOURCE sqltest USERID sa PASSWORD ""

     * Create the view using the remote connection.
     CREATE SQL VIEW zview REMOTE CONNECTION zconn AS select * from ;
        pubs..sales

     * Open the view and browse the resulting data set.
     USE zview
     BROWSE

By default, a view is not updatable. For information about creating an updatable
view, please see the following article in the Microsoft Knowledge Base:

  Q130413 How to Create an Updatable Cursor (View) to Update Table

Additional query words: VFoxWin

======================================================================
Keywords          : kbMDAC250 
Technology        : kbVFPsearch kbAudDeveloper kbMDACSearch kbMDAC250 kbVFP300
Version           : WINDOWS:2.5,3.0
Issue type        : kbhowto

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

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 1986-2002.