Eclipse Community Forums: BIRT » BIRT JDBC and ODBC

Help

Home

Home » Archived » BIRT » BIRT JDBC and ODBC

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT JDBC and ODBC [message #141554]

Wed, 08 March 2006 14:55

mr. burns

Messages: 402
Registered: July 2009

Senior Member

Hello,

I try to get a JDBC-ODBC connection to work.
What I succesfully could do is creating a datasource:

DriverClass: sun.jdbc.odbc.JdbcOdbcDriver (Sun JDBC-ODBC Bridge Driver)
Database-URL: jdbc:odbc:MyODBC_DSN
Username: TestUser
Password: test

If I click on TestConnection it says me: Connection successful.

But If I do a simple query on a Table:

select * from Item

It gives me an error message within the dataset-wizard-->Result preview: ...
The result set type is not supported ...
(see attachment)

So what does it mean: The result set type is not supported?

Any idea is highly appreciated!

Attachment: odbc.jpg
(Size: 51.26KB, Downloaded 465 times)

Report message to a moderator

Re: BIRT JDBC and ODBC [message #141860 is a reply to message #141554]

Wed, 08 March 2006 20:25

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

> I try to get a JDBC-ODBC connection to work.
> What I succesfully could do is creating a datasource:
>
> DriverClass: sun.jdbc.odbc.JdbcOdbcDriver (Sun JDBC-ODBC Bridge Driver)
> Database-URL: jdbc:odbc:MyODBC_DSN
> Username: TestUser
> Password: test

if you are working with MS SQL Server it's better to use driver from:
http://www.microsoft.com/downloads/details.aspx?familyid=e22 bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en

it published 1/19/2006

my settings:

<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
name="midwood" id="5">
<property
name="odaDriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver </property>

<property
name="odaURL">jdbc:sqlserver://data-server-1:1433;DatabaseName=MedBase</property>

<property name="odaUser">username</property>

</oda-data-source>

Report message to a moderator