>Can you delete a SQL Server record with the recordset Delete?
>I am using VFP6 and ADO 2.1 and SQL 7 with SP1.
>When I try the RecordSet.Delete(1)
>I get an error message "OLE IDispatch exception code 0 from ADODB.Recordset: The operation requested by the application is not supported by the provider..."
Try the ODBC provider MSDASQL. Or a regular ODBC DSN as your connection string. I've gotten the same error messages when using the native SQL provider. Now what is the (1) for? I don't see any reference on ADO where the Delete method would accept any parameters.