jocave_at_yahoo.com (Justin Cave) wrote in message news:<233b7a65.0109071341.5aa1afb9_at_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.
>
> 1) Does your query work correctly if you put it directly into
> SQL*Plus?
> 2) Does your query work correctly in Access if you execute the query
> manually?
> 3) 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
Even this query runs fine at day time. I usually dont get ODBC call
failed error message at day time. Sometimes I do but not often. I
always get it at night time.
Received on Mon Sep 10 2001 - 10:46:56 CDT
