Hi

I am working with Oracle 7.5.  I am trying to pass a date field  with an SQL
statement, via ODBC,  using the Oracle formatting.

I thought all I needed to do was add the dbSQLPassThrough to my execute but
it fails.
I don't get any error.  It just tries to re-connect to the database even
thou it is already connected.

Here is my code.

Set myDB = OpenDatabase("oracle test db", False, False, "odbc;UID=***;
PWD=***;database=test")

MyExcString1 = "Insert Into [TABLE_NAME]( Date_of_Test) Values (to_date{'" &
mskDate.Text & "', 'mm/dd/yyyy'});"

myDB.Execute MyExcString1, dbSQLPassThrough

 if I have dbSQLPassThrough set at this point it tries to reconnect
 if I remove it then Jet fails at the"to_date" format.

Any help out there?

Brian

We do this all the time and the only thing I can see as a difference between
what you have noted and what we have working is:

1)  The oracle connect string we have "ODBC;DSN=test;UID=***;PWD=***"
2)  The insert statement  "to_date( " instead of "to_date{"