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