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
Al Williams
Anola MB, CANADA