setting the DBPROP_MSDAORA_DETERMINEKEYCOLUMNS property of the MS OLEDB provider to False
Posted on 2004-10-23
The program is using MS OLEDB provider and there is a query
select count(*) from table where column1 is null;
This query gives the following error "ORA-00937: not a single-group group function". However this works fine with SQL Plus.
I came to know that if DBPROP_MSDAORA_DETERMINEKEYCOLUMNS parameter of MS OLEDB is set to True, then the pseudo column "rowid" is appending to the select list.... so while executing the query becomes
select count(*).rowid from table where column1 is null;
Hence the error. Now I need to set the parameter
DBPROP_MSDAORA_DETERMINEKEYCOLUMNS to false. How can I do the same?