• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Access through ODA

BScott

Member
Hi list,

We are starting to use the OneWorld ODA ODBC driver to access tables through
various third party tools: Brio, Cognos, MS Access/excel. The manual says
that the ODA driver should 'translate' UDCs, dates, amounts, etc and apply
row security. Most of which it does but it does not translate dates at all
well (e.g. a date last week would come through as 11/11/2100) and doesn't
seem to apply row security. Has anyone else found these problems or any
others with it? Are they fixable?

We are doing this on Xe and Oracle.

cheers
Barry

-----
BARRY SCOTT
Project Golden Dragon (Hong Kong)
t: (+852) 2686 3110
m: (+852) 6076 1905
 

hkdba

Active Member
Hi Barry,

How is the status of your problem? I am having the same problem as you. Any suggestions from you?

Cheers,
Alvin Lam (Hong Kong)
Tel: (852) 3416 5036
Fax: (852) 2904 1694
 
Top