Oracle-VB error message

From: <pac3_at_voicenet.com>
Date: Fri, 15 Sep 2000 18:54:51 GMT
Message-ID: <8ptr9j$eev$1@nnrp1.deja.com>

Hi,
I'm having a problem getting Oracle to process the following SQL string through VB.

SELECT * FROM DICT_DBA.ACF WHERE ct_Protocol IN ('29060/676','29060/688','104864/435') AND TRUNC(FIRST_FAIL_DATE) BETWEEN '01/01/2000' AND '09/01/2000' ORDER BY ct_Protocol, FIRST_FAIL_DATE desc

When I run it I get an ODBC error:

22008:[Microsoft][ODBC Driver for Oracle][Oracle]ORA-01843: not a valid month

Is there an accessible Knowledge Base for Oracle on-line? I went to www.oracle.com and found pay help, but nothing like a KB.

My experience lies primarily in SQ server. With the exception of the TRUNC function, this query would run. Can anyone help me with this?

Thanks in advance!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 15 2000 - 13:54:51 CDT