Hi

Can I use DOA component to connect to Oracle9i Lite database.
The documentation does say that application can access the database using ODBC,ADO,JDBC or some other interface built on top of ODBC.

Thanks in advance.

Oracle9i Lite database connectivity... single choice
	y
	n
Votes accepted starting: 01/01/70 12:00 AM You must vote before you can view the results of this poll.

You can access an Oracle Lite database through the Oracle Open Client Adapter (OCA) for ODBC, which is an Oracle interface between Oracle Net and ODBC. When OCA is installed, you can access an ODBC datasource by using a connect string like ODBC:MYDATASOURCE.

Oracle has dropped the OCA (which was included with the Oracle Developer suite). The only replacement that I can find is their Heterogenous Services functionality. But, HS isn't really the same thing as OCA.

OCA allowed for "direct" communication between the application and Olite database via Oracle Net and ODBC.

HS only allows you to connect to non-Oracle9i datasources via the 9i server. The application must first connect to 9i and then link to a non-Oracle datasource.

I'm not sure if this is the correct question to ask but are there any plans to add JDBC or ODBC support to DOA that does not require the OCA?

Direct Oracle Access will only use OCI (the Oracle Call Interface) provided by Oracle Net. If Oracle drops ODBC support via Oracle Net, then Direct Oracle Access will not be able to use it.

Here is what I found during my testing today. This may be helpful to others who are trying to accomplish the same task. We wanted to allow our application which uses DOA to access both a 9i and 9i Lite datasource. 9i Lite would be used when 9i was not available.

DOA works with the OCA only when using the Net8 client (8.0.5 or 6). This works because Net8 had logic built into it that let's it interact with ODBC datasources by converting the OCI calls into ODBC calls via the OCA.

You can install Oracle Lite 8 (version 4.0.1) to get an Oracle Lite database, Net8 (the special version required to interact with the OCA) and the OCA. This configuration should work fine but you will be limited to using Net8 instead of Net9.

I tried to get Net9 to recognize the OCA but it dod not work. So, if we want to use DOA and the OCA we need to stick with Net8. Net8 should be compatible with 9i databases but it is not supported by Oracle any longer unless you have an extended support agreement. The OCA is not supported by Oracle any longer and has not been updated since Oracle 8.0.6.