>>>>>>I would like to connect to Microsoft SQL server via vfp50?
>>>>>>I have been using power builder 6.5 to connect to Microsoft SQL server, but now I would like to us vfp50 and be able to view and change the data. Does anybody have any ideas?
>>>>>
>>>>>Hi Robert,
>>>>>
>>>>>You need to use SQL Server ODBC Driver to connect to SQL Server Database. Create your data source using this driver through Windows Control Panel/ODBC Data Sources.
>>>>>
>>>>>Nick
>>>>I got it, thanks folks - Where do I keep the VIEWS after I close the
>>>>connection to the server. I do not want these VIEWS on the user's computer.
>>>>Should I delete them, or should I keep them on the server. If I keep
>>>>them on the server, will this slow down the retrieval time?
>>>
>>>Hi Robert,
>>>
>>>I don't quite understand what you mean. What did you create? a remote view or SQL Pass-Through cursor? In both cases if you retrieved some data to the local PCs, the retrieved recordset is gone anyway after you close your view or cursor.
>>>
>>>Nick
>>Hi Nick:
>>I have closed my view and open it again and I can still see the data. I would
>>like this data to go away for good. How do I do that?
>
>If you have a remote view, next time you open it it retrieves the same data from the server. If you don't want this data in the back-end database you need to delete the records in the view and send updates to the back-end. Of course your remote view has to be updatable.
------------
ok - that is what I thought - but, what if I keep the remote views on the
server? Will that work and will that be just as fast? - thanks