Eclipse Community Forums: BIRT » BIRT JDBC and ODBC

Home » Archived » BIRT » BIRT JDBC and ODBC

Wed, 08 March 2006 09:55

Eclipse User

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 522 times)

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

Wed, 08 March 2006 15: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>

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

Thu, 09 March 2006 06:50

Eclipse User

Hello Vladimir,

sorry I did not mention.
I use Navision Attain Native C/SIDE database which comes with a C/ODBC
driver.

Any ideas?

Re: BIRT JDBC and ODBC [message #1022617 is a reply to message #141977]

Fri, 22 March 2013 04:49

Eclipse User

Hello,

I am in the same situation now. Is there a solution to this?

Best regards
Uwe

Previous Topic:	How to set axis tick labels?
Next Topic:	oda.flatfile.InvalidResourceException

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Apr 24 09:51:10 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter