Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> From M$ to Linux and VB 6
Undergoing a conversion to Oracle on Linux ( redhat ) and am running
into a baffling problem. During runtime an ADO query
select col1,sum(col2) from table1 group by col1
is generating a runtime error: invalid group by. I've found in SQL Monitor ( Quest freebie ) that the sql string it thinks is going to the server is
select col1,sum(col2),col1.rowid from table1 group by col1
Strangest thing is that the same code running against M$ works fine and
has been
running for 1+ years.
We are having other issues but this is the problem that has been assigned to me.
The application is running on server 2000 on Citrix 1.8 FWIW I'm
experiencing the same
problem running from the IDE on my laptop ( XP ), VB 6 SP 6.
Thanks in advance for any help ! Received on Wed Jun 28 2006 - 14:56:32 CDT
![]() |
![]() |