none
Using command builder to update oracle 9i db. RRS feed

  • Question

  • Hi there,

     

    Our product has to work with MSSQL and ORACLE, so we use oledb to avoid the hassel.

    For updating, we are using command builder, for MSSQL, it's not a problem. But, for Oracle, we are getting

    error:

    System.Data Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

    We have primary key on the table, but still having problem.

     

    I read a lot of threads, could not find a solution to it. Do we have a solution with command builder? or we have to build command ourself.

     

    Thanks a lot!

     

    George.

    Thursday, December 20, 2007 8:15 PM

Answers

All replies