Re: Oracle Error Using BarTender Tool. ORA-00928. Why?

From: DriftWood <drift_wood_at_my-deja.com>
Date: Wed, 15 Mar 2000 14:34:38 GMT
Message-ID: <8ao71u$lnh$1@nnrp1.deja.com>

Three things.
1)The SQL sent to the driver is 'supposed' to be ODBC grammer (ANSI grammer in places, but with extensions/escapes). The driver is responsible for translating it into valid SQL for the RDBMS (and hopefully optimize it a bit along the way). 2)Try another driver. You are using the Microsoft provided Oracle ODBC driver. Try either the one from Intersolv or from Oracle themselves. 3)Turn on a SQL*Net trace and capture the SQL being sent from the driver to the RDBMS -- this will certainly show you why the RDBMS is complaining about the SQL. The ODBC driver parser isn't correctly handling the SQL it is getting and is, in turn, generating bogus SQL for Oracle.

--
-cheers

DW

---

"It is a kind of good deed to say well; and yet words are not deeds.
-William Shakespeare"

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 08:34:38 CST