>Folks,
>
>I have an application using a VFP connection and remote view into a SQL Server PRODSERVER database "HarnData".
>
>I need to provide a TEST version of this application using a VFP connection and remote view into a SQL Server TESTSERVER database "HarnData".
>
>Both the HarnData structures are identical except for data contents.
>
>How do I make the application use the remote view into PRODSERVER data or TESTSERVER data?
>
>NOTE: I have tried using two databases. One uses a connection and remote view into the PRODSERVER database and the other uses a connection and remote view (of the same name) into the TESTSERVER database. When the app runs, it makes no difference which database is opened and which connection is established, the remote view always is showing the PRODSERVER data.
>
>I appreciate your help.
>
>Bob

No need for two databases, just modify the connection parameters of the connection that the remote views use. You want to do that at startup, before using any remote views.

Check DbSetProp and DbGetProp for connections.

Carlos Alloatti