Microsoft KB Archive/137944

= HOWTO: How to Create a Remote Connection or View Programmatically =

Article ID: 137944

Article Last Modified on 3/14/2005

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.