Re: SQL Command Not Properly Ended (ORA-00933)

In Access Pass through you are still using the Jet engine, and ODBC.ODBC will interface with sqlnet. Sqlplus interfaces with sqlnet directly. Just as experiment try tracing ODBC calls (enable them using the ODBC applet in control panel) and you will see how your statement gets translated by the ODBC driver. Usually a pass through window forces you to use correct Oracle syntax. It is quite possible behavior at the Microsoft side has changed between versions (Acces 95 uses ODBC 2.5, Access 97 ODBC 3.0). In 2.5 Oracle syntax has to be correct including the semi-colon.

Thanks,

Sybrand Bakker

Kevin P. Fleming wrote:

> Well, your first problem is that Oracle uses single-quotes for string
> literals, not double quotes...
>
> As to why it works in the Access Pass-Through window with the double quotes
> but no semicolon, I have no idea.
>
> steve_dennis_at_my-dejanews.com wrote in message
> <6rkkda$9tu$1_at_nnrp1.dejanews.com>...
> >I get the error message in the subject line (ORA-00933) when I type the
> >following query in SQL*PLUS or MS Access SQL Pass-Through window:
> >
> >SELECT * FROM DW_PROD.MEMBER_HISTORY AS A
> >WHERE A.SUBSCRIBER_ID = "0094100006";
> >
> >But not if I have no WHERE clause. The query works without a WHERE CLAUSE
> in
> >the Access Pass-Through window if I omit the semi-colon; I must use the
> >semi-colon in SQL*PLUS. Why must I terminate the SQL statement differently
> >depending on the statement?
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Aug 22 1998 - 03:44:36 CDT