Re: ORA-00911 error!

From: TurkBear <noone_at_nowhere.com>
Date: Fri, 29 Jun 2001 08:48:26 -0500
Message-ID: <0m1pjtcg464h5l1vnjinknbdnvkihl9orm@4ax.com>

Try to determine what exactly is being sent... Use some scripting ( in asp use response.Write) to see how the string is being translated..the single quote is probably the source of your problem..

"mpowell" <mike.powell_at_transcore.com> 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!
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jun 29 2001 - 08:48:26 CDT