>>>>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?