>>I am trying to insert records into a .net local data table (SQL Compact Edition .sdf File)
>>
>>I am using a cursor adapter since these is no ODBC driver for this.
>>
>>I can open the table just fine but I cannot get an insert to work. Is it possible to insert into an ADO table?
>>
>>This is what is being returned by aerror after the tableupdate()
>>
>> ( 1, 1) N 1435 ( 1435.00000000)
>> ( 1, 2) C "Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value."
>
>
>John,
>AFAIK SQL server CE is not updatable via OLEDB using recordsets (unless opened as table direct). MS would think about an update, I don't know if they did or not. Workarounds would be to use separate insert/update commands or use some .Net wrapper activex that uses .Net managed driver.
>
>Cetin
I'd rather avoid the .net wrapper in this case. (if forced to go that route, I'll just do the update from .net)
How do you open as "table direct"?