|
Re: Create data set to MS Access db [message #539621 is a reply to message #539206] |
Fri, 11 June 2010 13:34 |
Eclipse User |
|
|
|
Originally posted by: remkus.wideopenwest.com
I hadn't used the JDBC-ODBC bridge for MS Access, but had used it for
Excel and Text files,so it really does work!
I'm wondering if the space in the UID is causing you problems.
Had you tried using a UID without spaces? Had you tried escaping the space?
On 06/09/2010 08:09 PM, Albert wrote:
> Hello All,
>
> I've been trying to create a data set to an access db. However,
> everytime I try to do this BIRT has shut itself down although I did use
> a test connection and the message said connection successful.
>
> I've followed instruction on setting up JDBC-ODBC connection within the
> data source. I used the instruction from this link:
> http://digiassn.blogspot.com/2008/02/birt-birt-reporting-for -microsoft.html
>
> A little info regarding the access db: it requires a username and
> password for login. I've specified this when setting up the drivers, but
> haven't had any luck. Here's what I've specified in the JDBC driver:
> URL Template: jdbc:odbc:SALeapdb;UID=John Smith;PWD=output
>
> Does any one has a suggestion to resolve the issue?
>
> Thanks,
> Albert
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.03291 seconds