Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> From M$ to Linux and VB 6

From M$ to Linux and VB 6

From: outerjoin <chris.taylor_at_dcpfi.com>
Date: 28 Jun 2006 12:56:32 -0700
Message-ID: <1151524592.360899.145480@i40g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US