Hi. 

The Oracle libraries will still need to be installed unfortunately.  On the Java-side, Oracle has a thin client/jdbc driver that doesn't need the Oracle client libraries to be installed.

Roberto


On 4/18/06, Habib Ahmed Qureshi <[EMAIL PROTECTED]> wrote:

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




--
____________________________________________________

Help spread the word on the 2006 Deutsche Marque Concours!
http://www.audiclubna.org/chapters/potomac/cgi-bin/calendar.pl?month=5&view=Event&event_id=57

Reply via email to