>>>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"?
loCommand.CommandTYpe = 2 && Table
loCommand.CommandText = "TableName" && no SQL - directly the tablename
I don't have an idea how you could do that with CA though. If you would use ADO commands then that would do.
Cetin