Re: ORA-00911 error!

From: mpowell <mike.powell_at_transcore.com>
Date: Fri, 29 Jun 2001 08:27:46 -0600
Message-ID: <9hi3he$b03$1@news.rt66.com>

Beauty! Thanks!

"Markus Stuhlpfarrer" <mstuhlpfarrer_at_hollomey.com> wrote in message news:3B3C3F01.55D0BA46_at_hollomey.com...
> remove the semicolon (;) at the end of your select statement and try again
:-)
>
>
> mpowell wrote:
>
> > I am using ADO and trying to connect to an Oracle 8i (I think) database.
I
> > seem to connect using my connect string, however, when I submit the
> > following SQL statement I receive an ORA-00911 error. The same query
runs
> > fine using the Oracle ODBC 32Bit Test application.
> >
> > SELECT C.CUSTOMERNO, C.COMPANYNAME FROM A_RCUST C WHERE
ENTITY_CODE='DALLAS'
> > ORDER BY C.CUSTOMERNO;
> >
> > Any ideas? Thanks!
>
Received on Fri Jun 29 2001 - 09:27:46 CDT