>When I was using the VFPOleDB data provider to access VFP data from my application, from VB.NET, I was able to update a data row. So, assuming I was having a SQL like this:
>
>

>SELECT MyTable.Numero,0 AS Enabled FROM MyTable
>

>
>I was then able to do this:
>
>

>toRow("Enabled") = 1
>

>
>where toRow is a data row of one record from the SQL result.
>
>However, with the SQLClient data provider, I obtain a message that says:
>
>"Column 'Enabled' is read only."
>
>How can I workaround that?

Did you look into creating an updatable view in SQL Server 2005 and using it instead of the base table?