OracleLite 10g

[Mark Gorst]

From looking through past postings I see that DOA does not work with (except by force) OracleLite 9i - does it by any chance work with Oracle Lite 10g ??

Anyone tried and worked / failed ?

 

[Marco Kalter]

Access to Oracle Lite requires the "Oracle Client Adapter" for ODBC. This allows an OCI client application like Direct Oracle Access to talk to any ODBC data source. I'm not sure what the status of the "Oracle Client Adapter for ODBC" is though. On the Oracle site it seems to be packaged with Oracle Forms/Reports now, instead of a separate product.

 

[Mark Gorst]

It would appear, that as postings about other versions of OracleLite that Oracle Client Adapter was dropped at 9i, and replaced by MSQL.

Are there any plans to make DOA work with OracleLite ?

 

[Marco Kalter]

Direct Oracle Access works with the Oracle Call Interface (OCI), which is part of Oracle Net. We have no plans for other interfaces, so Oracle Lite can only be used if Oracle provides an OCI interface (such as the Open Client Adapter).