KB137944 - HOWTO: How to Create a Remote Connection or View Programmatically

Article ID: 137944

Article Last Modified on 3/14/2005

Microsoft Visual FoxPro 3.0 Standard Edition
Microsoft Data Access Components 2.5

This article was previously published under Q137944

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:

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

Additional query words: VFoxWin

Keywords: kbhowto KB137944