>>Does anyone know if the bug described in this KB article has been fixed or not? Any workarounds?
>>
>>
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B275577>
>Jayesh,
>AFAIK, the ODBC driver has not been updated since 6.0. Once the OLE DB provider was available, resources were diverted away from the ODBC driver.
>
>The work around would be to break your remote views up into field lists of less than 65 columns. You could duplicate the key fields in each view and have a different subset of fields to update.
>
>HTH.
Yeah but it is a lot of work. I would rather process on tables directly. The only problem with this approach is when I move the app to SQL Server, I will have to change the code to use remote views again.
Thanks for the reply.
- Jayesh