DOCUMENT:Q137944  22-FEB-2000  [foxpro]
TITLE   :HOWTO: How to Create a Remote Connection or View Programmaticall
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:2.5,3.0
OPER/SYS:
KEYWORDS:kbMDAC250

======================================================================
-------------------------------------------------------------------------------
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 2000.