Hi,
I want to connect to oracle 9i and 10g. But instead of using oracle client I want to connect using the OLEDB to Oracle avoiding the step of installation of oracle-client, since this db connectivity is being done in the desktop client and installing oracle client every where is problematic.
I am only using IBATIS Data Access and not maps.
Right now my dao.config has:
<database>
<provider name="Oracle9i" />
<dataSource name="${database}" connectionString="Data Source=${datasource};User ID=${userid}; Password=${password}" />
</database>
In providers.config:
<provider name="Oracle9i" enabled="true" default="true" assemblyName="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"…
What would be the correct value in the doa.config for data source if I want to use OLEDB?
Thanks in advance.
---
Habib Ahmed
