>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