| Accessing ODBC data [message #242890] |
Fri, 15 June 2007 07:48  |
Eclipse User |
|
|
|
Originally posted by: luc.dooms.c-cure.be
Hi All,
I have been working with BIRT to report on some of MySQL data and I'm
pretty impressed with the results so far.
Now, I need to include some MS Access data, data I can only access through
ODBC.
Does anybody has a proven method to do this ?
1. I know that sun has a JDBC/ODBC bridge included the JDK.
Is that the way to go?
How do you include this bridge into the BIRT Managed Drivers?
2. I have also tried the hxtt MS Access JDBC drivers.
They do work for small MS Access tables, but fail with the larger ones.
Your documented experiences are welcome !
Cheers,
Luke
|
|
|
| Re: Accessing ODBC data [message #243124 is a reply to message #242890] |
Mon, 18 June 2007 15:28  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Luke,
You can access a ODBC source by entering
sun.jdbc.odbc.JdbcOdbcDriver as the driver class.
The driver url would be something like:
jdbc:odbc:mydb
Jason
Luke wrote:
> Hi All,
>
> I have been working with BIRT to report on some of MySQL data and I'm
> pretty impressed with the results so far.
>
> Now, I need to include some MS Access data, data I can only access
> through ODBC.
>
> Does anybody has a proven method to do this ?
>
> 1. I know that sun has a JDBC/ODBC bridge included the JDK.
> Is that the way to go?
> How do you include this bridge into the BIRT Managed Drivers?
>
> 2. I have also tried the hxtt MS Access JDBC drivers.
> They do work for small MS Access tables, but fail with the larger ones.
>
> Your documented experiences are welcome !
>
> Cheers,
>
> Luke
>
|
|
|
| Re: Accessing ODBC data [message #243258 is a reply to message #243124] |
Tue, 19 June 2007 10:13 |
| Eclipse User |
|
|
|
Originally posted by: luc.dooms.c-cure.be
Hi Jason,
Thanks for your answer.
Still, jdbc:odbc:mydb is simply not in the options of my 'Driver Class'
list.
So I need to include it by using the 'Manage Driver...'.
But I don't know what JAR file to add.
Anybody ?
Luc
Jason Weathersby wrote:
> Luke,
> You can access a ODBC source by entering
> sun.jdbc.odbc.JdbcOdbcDriver as the driver class.
> The driver url would be something like:
> jdbc:odbc:mydb
> Jason
> Luke wrote:
>> Hi All,
>>
>> I have been working with BIRT to report on some of MySQL data and I'm
>> pretty impressed with the results so far.
>>
>> Now, I need to include some MS Access data, data I can only access
>> through ODBC.
>>
>> Does anybody has a proven method to do this ?
>>
>> 1. I know that sun has a JDBC/ODBC bridge included the JDK.
>> Is that the way to go?
>> How do you include this bridge into the BIRT Managed Drivers?
>>
>> 2. I have also tried the hxtt MS Access JDBC drivers.
>> They do work for small MS Access tables, but fail with the larger ones.
>>
>> Your documented experiences are welcome !
>>
>> Cheers,
>>
>> Luke
>>
|
|
|
| Re: Accessing ODBC data [message #243351 is a reply to message #243258] |
Tue, 19 June 2007 16:19 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Luke,
You should be able to type in
sun.jdbc.JdbcOdbcDriver as the driver class. It is not in the drop
down, but you can type it in.
the jdbc:odbc:mydb is the url.
Jason
Luke wrote:
> Hi Jason,
>
> Thanks for your answer.
>
> Still, jdbc:odbc:mydb is simply not in the options of my 'Driver Class'
> list.
> So I need to include it by using the 'Manage Driver...'.
> But I don't know what JAR file to add.
>
> Anybody ?
>
> Luc
>
> Jason Weathersby wrote:
>
>> Luke,
>
>> You can access a ODBC source by entering
>> sun.jdbc.odbc.JdbcOdbcDriver as the driver class.
>> The driver url would be something like:
>> jdbc:odbc:mydb
>
>> Jason
>
>> Luke wrote:
>>> Hi All,
>>>
>>> I have been working with BIRT to report on some of MySQL data and I'm
>>> pretty impressed with the results so far.
>>>
>>> Now, I need to include some MS Access data, data I can only access
>>> through ODBC.
>>>
>>> Does anybody has a proven method to do this ?
>>>
>>> 1. I know that sun has a JDBC/ODBC bridge included the JDK.
>>> Is that the way to go?
>>> How do you include this bridge into the BIRT Managed Drivers?
>>>
>>> 2. I have also tried the hxtt MS Access JDBC drivers.
>>> They do work for small MS Access tables, but fail with the larger ones.
>>>
>>> Your documented experiences are welcome !
>>>
>>> Cheers,
>>>
>>> Luke
>>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03443 seconds
] 
Search
Help
Register
Login
Home
