Path: news.easynews.com!easynews!newsfeed.frii.net!news-out.nuthinbutnews.com!propagator2-austin!propagator!feed2.newsfeeds.com!newsfeeds.com!news-in-austin.nuthinbutnews.com!intgwlon.nntp.telstra.net!news-server.bigpond.net.au!not-for-mail
From: "Tony Hunt" <tonster@bigpond.net.au>
Newsgroups: comp.databases.oracle.misc
References: <91f46d00.0109070943.6a68b1a3@posting.google.com>
Subject: Re: Odbc Call failed
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <bzFm7.27575$bY5.155196@news-server.bigpond.net.au>
Date: Sun, 09 Sep 2001 08:16:07 GMT
NNTP-Posting-Host: 203.45.127.17
X-Complaints-To: news@bigpond.net.au
X-Trace: news-server.bigpond.net.au 1000023367 203.45.127.17 (Sun, 09 Sep 2001 18:16:07 EST)
NNTP-Posting-Date: Sun, 09 Sep 2001 18:16:07 EST
Organization: BigPond Internet Services (http://www.bigpond.net.au)
Xref: easynews comp.databases.oracle.misc:68499
X-Received-Date: Sun, 09 Sep 2001 01:15:54 MST (news.easynews.com)

That error is a nightmare because Access spits it out with no explanation!

I've had problems with different (but compatible) versions of drivers for
client & server.  8.1.7 client not good in some cases with 8.0.5 server.

As much as I've used Access I never knew you could call those Oracle SQL
functions.  I always use the AccessVB equivelant, suach as DateValue, CStr &
IIf rather than TRUNC, TO_CHAR & DECODE.

"Ravi Patel" <ravi197@yahoo.com> wrote in message
news:91f46d00.0109070943.6a68b1a3@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.
>
> Here is the SQL syntex for my query:
>
> SELECT m.messageid,
>               mt.stringvalue messagetype,
>               m.completedate kanacompletedate,
>               TRUNC(m.completedate) kanacompleteday,
>               TO_CHAR(m.completedate, 'HH:MI:SS AM') kanacompletehour,
>               LTRIM(TO_CHAR(m.completedate, 'DAY'))
> kanacompleteweekday,
>               m.completedate,
>               TRUNC(m.completedate) completeday,
>               TO_CHAR(m.completedate, 'HH:MI:SS AM') completehour,
>               LTRIM(TO_CHAR(m.completedate, 'DAY')) completeweekday,
>               m.elapsedtime,
>               f.label queuename,
>               d.label deptname,
>               e.emailaddress,
>               DECODE(mav.suggest,-1,'Manual
> Response',DECODE(mav.resptype,6,'Auto Response',2,'Auto Suggest','No
> Response')) response,
>               me.stringvalue messageevent
> FROM kc_message m, kc_messagetype mt, kc_folder f, kc_department d,
> kc_emailaddress e, messageautomationview mav, kc_messageevent me
> WHERE m.type = mt.messagetypeid
> AND m.queueid = f.folderid
> AND f.departmentid = d.departmentid
> AND m.recipientid = e.emailaddressid
> AND m.completeeventid = me.messageeventid
> AND m.messageid = mav.messageid(+)
> AND TRUNC(m.completedate)  >= TRUNC(sysdate-4)
> AND TRUNC(m.completedate) < TRUNC(sysdate)
> ORDER BY m.completedate;
>
>
> Thanks in Advance
>
> Ravi Patel