Re: Odbc Call failed

From: Justin Cave <jocave_at_yahoo.com>
Date: 7 Sep 2001 14:41:49 -0700
Message-ID: <233b7a65.0109071341.5aa1afb9@posting.google.com>

ravi197_at_yahoo.com (Ravi Patel) wrote in message news:<91f46d00.0109070943.6a68b1a3_at_posting.google.com>...
> Hi
>
> I have 10 passthrough queries in Access2000 that connects to Oracle
> database.
> I have scheduler setup to run those queries everynight. All queries
> run just fine except one. In that query i get "Odbc call failed"
> error.

Does your query work correctly if you put it directly into SQL*Plus?
Does your query work correctly in Access if you execute the query manually?
Can you turn on ODBC logging before executing the failure to get a better error message? Access is being lame and not reporting the specific cause of the failure.

Nothing looks terribly wrong in your query.

Justin Cave Received on Fri Sep 07 2001 - 16:41:49 CDT