That depends on what you are doing was I said if you want to use OLEDB instead of ODBC then I must use ADO or you can combine both what I said to Allan is that if they use ADO in all of his projects then he is more comfortable using ADO over VFP SQL Commands.

>Alexandre PMFJI.
>
>What is the advantage of using ADO over ODBC in this situation in a VFP App?
>
>Thanks
>
>>Allan if you have the experience with ADO then in my opinion your best bet is ADO VFP works with ado in the same manner that VB so you will not have any problems.
>>
>>>Thanks, In your opinion - which is the best way to go with VFP and SQL Server? We use ADO with all our VB-Access/SQL apps but haven't tried it with VFP-SQL yet.
>>>
>>>Al
>>>
>>>>Allan you can use SQL Server OLEDB provider with VFP 7 if you are using ADO not SQL commands e.g. SQLCONNECT, SQLEXEC etc.. since this commands work over ODBC.
>>>>
>>>>>Hi,
>>>>>
>>>>>We're in the process of converting all of our internal VFP-VFP and VB-Access apps to a SQL Server back-end.
>>>>>
>>>>>With the VFP apps, I've been using an ODBC SQL Server connection - and performing all the inserts, deletes and updates using the SQLEXEC command.
>>>>>
>>>>>I'd like to get my hands on more information on using SQL Server with VFP - so if anyone could point me in the right direction I'd appreciate that.
>>>>>
>>>>>Also, I seem to recall reading here that you can't use the SQL Server OLEDB provider with VFP 7 - is that correct or am I misinformed ?
>>>>>
>>>>>Regards,
>>>>>
>>>>>Al