how to connect to oracle database?

karteek

how can we connect BIRT to oracle database.

which jdbc driver i have to use?

i have downloaded the ojdbc14.jar for this purpose. but its not working.


can any one please say the procedure and which jdbc driver i have to use.

Virgil Dodson

Hi karteek,<br />
<br />
The ojdbc14.jar should work fine. <br />
<br />
For the design environment:<br />
1. Create a new JDBC Data Source.<br />
2. Press the Manage Drivers button<br />
3. Press the Add button and point at your ojdbc14.jar file.<br />
4. Now you should be able to select your driver from the drop down list.<br />
oracle.jdbc.driver.OracleDriver<br />
5. Enter the correct Oracle server URL, similar to below<br />
jdbc: oracle: thin: @hostname: 1526: orcl<br />
<br />
For deployent, see the link below to place that JDBC driver JAR file in the correct place.<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/deploying-birt-reports/169-placing-jdbc-drivers-for-birt-and-e-spreadsheet-reports/'>Placing JDBC drivers for BIRT and e.Spreadsheet Reports - Tips & Tricks - BIRT Exchange</a>