Federico Balbi wrote:
> Hi,
> i just need to send from VC++ an INSERT statement to MyODBC like:
>
> SQLExecDirect(hstmt, "INSERT INTO tt VALUES (1,'Joe')");
>
> no params.. just a simple string with an INSERT statement..
>
> why do I get the following error?
>
> [Microsoft][ODBC Driver Manager] Invalid cursor state
>
> I have to use straight C code (no C++) and no CRecords...
> Somebody can tell me why ODBC cannot send this to the server??
>
Federico,
1. send complete trace
2. try SQLPrepare + SQLExecute
3. what was the error code again
Peter Harvey