Odbc Call failed

From: Ravi Patel <ravi197_at_yahoo.com>
Date: 7 Sep 2001 10:43:43 -0700
Message-ID: <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 Received on Fri Sep 07 2001 - 12:43:43 CDT