hi adir,
first of all thnks for your quick reply.
the procedure is very clear.
but in order to get that jdbc driver in the drop down we have to add the jdbc driver by clicking 'Manage drivers' button.
My question is which drivers i have to add there?
From where i can download those drivers?
im using oracle9i and jave 1.5 for Eclipse BIRT. i cant able to find the drivers which are compatible for the above requirement
1.new datasource ->jdbc datasource ->next
1.1 jdbc driver class: oracle.jdbc.OracleDriver
1.2 jdbc driver url: jdbc:oracle:thin:@<your ip>:1521:<service name>
1.3 set password and user name like in your oracle
2.create new dataset
2.1 direct datasource combo box to datasource you config for oracle in bullet 1 ->next
This is the configuration section, next you can drag and drop any of the tables you got over the report.
is it clear?
karteek@lgs wrote:
hi adir,
can you please say the procedure to connect to an oracle database.
which jdbc driver i have to use?
the syntax for 'Driver url'?
please help me out in this. im trying to connect to an oracle database
