>Hi,
>
>I've installed a VFP7 application at a client site that is running Sql2000. Their DBA created view on another Sql2000 that I need access to. I have Two questions:
> - how do you execute a view from VFP7
> - if it's on another server do I use the client tools to gain access to the server and create an ODBC connection to it?
>
>Any idea's would be appreciated.
>
>Steve
Hi,
you can query the view like a table:
SELECT * FROM MyView
There are two different way to access another server:
- to make it linked
---- or-----
- as you write - to make ODBC connection sirectly to that server.
If you have required permition it is not a problem to make ODBC connection to it.
Venelina Jordanova
Outsourcing IT Services Ltd.