Access to Oracle

  • Thread starter Thread starter sunhealth
  • Start date Start date
S

sunhealth

I have a situation where I have an access database connected through
ODBC to an oracle database. We run a group of access queries on the
oracle data. The problem that has come up however, is when we try to
use the date fields. Of course access uses the # symbols and Oracle
does not. Does anyone have a possible workaround for this situation.
Thanks
Sun Health
 
hi sunhealth,

I have no specific knowledge of what you are doing, but when I do it
programmatically in a context of insert commands dinamically built, I
use something like:

OracleDate = "to_date('" & AccessDate & "','mm-dd-yyyy hh24:mi:ss')"

let me know if something along those lines can be somehow to be adapted
to your problem (to_date is an oracle function that may be useful) ...

-t

sunhealth ha scritto:
 
Dear Sun:

The # symbols are to delimit and identify a date literal. They are
appropriate for use in Access Jet only.

If you are having Access run the query, then you can and should use them.
The fact that the data is in Oracle is not pertainent.

If the query is pass-thru to Oracle, then they are not Access queries. They
must be writtent to Oracle standards. If so, then your question should be
directed to where there is expertise in Oracle, not Access and Jet.

Likely then, the first thing is to determine whether the query is pass-thru
or not.

Tom Ellison
 
Back
Top