ODBC Call Failed -

[angroberto38]

I am triyng to access one Oracle database with Msaccess2003 by ODBC.
When i used one field date type in clause Where, I get Error.
I would like help

It is Code :

Dim wrkODBC As Workspace
Dim conPubs2 As Connection
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "Test", "test", dbUseODBC)
Set conPubs2 = wrkODBC.OpenConnection("Connection2", , True, "ODBC;DRIVER={Microsoft ODBC for ORACLE};SERVER=xxxxx;UID=xxxxx;PWD=xxxxx;DSN=xxxxx")
Set Rpec = conPubs2.OpenRecordset("SELECT * FROM CONTR WHERE [START_DATE] <=#1/1/2006# ",  dbOpenSnapshot)

Angelo Roberto- E_mail deleted - I am from Brazil
Thanks all

[FishVal]

Hi, Angelo.

I guess Oracle SQL has other syntax of date constants. Try to wrap it in single quotes.

SELECT * FROM CONTR WHERE [START_DATE] <='1/1/2006'
 

Regards,
Fish.

P.S. Posting email address is prohibited by the site rules.

[NeoPa]

What are the characteristics of your [Start_Date] field. Your SQL is fine (syntax correct). All SQL engines support #m/d/y# format for dates (Literal DateTimes and Their Delimiters (#)).