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


    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!



    Thursday, December 20, 2007 8:15 PM


All replies