>>>
>>>With Remote Views you don't have any chance other than ODBC. ODBC serves very well for me.
>>>
>>>If you put RV and SPT aside, you can use OLEDB. In VFP6 you'd need ADO then. Starting with VFP8, OLEDB is supported through CursorAdapter.
>>>
>>
>>Cetin,
>>
>>PMFJI,
>>
>>But if you had to create a new app these days with VFP as front end and SQL Server back end, what approach would you recommend: Remote Views with ODBC or CursorAdapter through OLEDB?
>
>CA with OLEDB or ODBC. RVs sound to be a beginner's choice to me. When it's RV/SPT there are things which you can do with one but not with the other. CA and XMLAdapters make it easier to deal with those. Has better support for select,insert,update, delete (direct or stored procs) etc. But I've never been strict on what to use. I use one or the other as I see fit.
>Cetin
Thank you very much for your reply and for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham