Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT JDBC and ODBC
BIRT JDBC and ODBC [message #141554] Wed, 08 March 2006 14:55 Go to next message
mr. burns is currently offline 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 154 times)
Re: BIRT JDBC and ODBC [message #141860 is a reply to message #141554] Wed, 08 March 2006 20:25 Go to previous messageGo to next message
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 11:50 Go to previous messageGo to next message
mr. burns is currently offline mr. burns
Messages: 402
Registered: July 2009
Senior Member
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 08:49 Go to previous message
Uwe Hartl is currently offline Uwe Hartl
Messages: 1
Registered: March 2013
Junior Member
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:
  


Current Time: Thu Oct 23 22:03:21 GMT 2014

Powered by FUDForum. Page generated in 0.01624 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software