Connecting to a Database that supports ODBC

Hello there
I have a requirement to connect to a propreitary database that supports ODBC only. I have its ODBC driver installed on the Windows server where BIRT runs.
Can you please share any information you have on connecting such databases using BIRT . I looked JDBC-ODBC bridges but was unable to get to the bottom of it -i.e installing and getting the driver et al

Thanks
Saba

Find more posts tagged with

Comments

JasonW

Saba,

Create a new jdbc datasource.

type in
sun.jdbc.odbc.JdbcOdbcDriver for the driver class in the drop down list
for the new datasource and then enter your dburl like:

jdbc:odbc:mydbname

Jason

JasonW

The url is suppose to be like:

jdbc : odbc:dbname

with no spaces.

markdonnel

Hi
I am new to all this so I am not sure if I am just missing something. I am using windows XP and I am trying to set up a data connections in eSpreadsheet. I have tried setting up an ODBC data connection using the advice from Jason ie inputting sun.jdbc.odbc.JdbcOdbcDriver for the driver class in the drop down list. But when I test the connection it tells me the driver can not be found and to check the driver path. I have a JdbcOdbc.dll file under the java folder in the programs directory.

Can any one advise if I am looking in the right path or if I need to do something else to get it to work.

RussW

The sun.jdbc.odbc.JdbcOdbc class is located in the standard sun runtime jar (rt.jar) so it shouldn't have any problem finding it. You may have spelled it wrong or used incorrect capitalization.<br />
In the new data source dialog, select<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Driver: Generic JDBC
Driver Class: sun.jdbc.odbc.JdbcOdbcDriver
Database URL: jdbc:odbc:MyDatabase
</pre>
<br />
The driver class should be in the drop-down list, but cut-and-paste directly from here if necessary.