MDAC SQL

[akutty]

Hi All,

I have got a strange proble,i execut ethe following query through Toad or SQLplus

select count(*) from tableA

it works fine
but if i execute the same from Visial basic DLL i throws up the verror
ORA-00937: not a single-group group function

is it a problemwith oledb provider or MDAC 2.7?

regards
anil

 

[fredericofonseca]

try stating a single field instead of the (*). There is something about this within the SQL Standards.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[akutty]

the problem is resolved now, the problem was with the oracle database cursor settings.. dba team changes and its working fine now. it was a strange error and took lot of time to resolve..

regards
Anil