Oracle 9i via C++

[mbames]

I am trying to a write a little application that read / write data from 9i.

I have some C++ code that works with Access and SQL Server via ODBC. However when I try and run it on 9i, it then gets upset, giving me the following error:

ORA-00900: invalid SQL statement

although I can quite happily run the statement in SQL*Plus. The statement is as follows:

UPDATE tblRegCode SET rDescription = 'moretime in bed' WHERE rCode = '/'"

This was done using the Oracle in OraHome92 ODBC driver. If I try and use the MS Oracle driver (Microsoft ODBC for Oracle) then I failed to even connect to the database.

Any ideas what I can do? The strangest thing is that the change is applied to the database and then the above error is issued.

Thanks,
Matt

 

[sem]

I double quote at the and just a typo or a part of statement?

Regards, Dima

 

[mbames]

The double quote was a typo - I copied the line from my c++ code:

_bstr_t strSQLChange("UPDATE tblRegCode SET rDescription = 'moretime in bed' WHERE rCode = '/'");

and

_bstr_t strSQLRestore("UPDATE tblRegCode SET rDescription = 'Morning' WHERE rCode = '/'");