Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Ms Access Error

  1. #1

    Default Ms Access Error

    Hi everybody,

    I'm quite new to Pentaho, and not really "computer expert", but my boss give me this job about Pentaho.
    So, I've some questions:

    does Pentaho Reporting Wizard support MS Access Database (I think the answer is yes)?

    If it is so, do I have to put the Jdbc driver for MS Access in the WIZARD_ROOT\lib\jdbc directory?

    And if it is so, WHERE can I find the driver for MS Access? I tried to search on the net, but I'm a bit confused because there are so many links..

    can anybody help me?

    I'm using PEntaho Reporting Wizard 1.7.0 and I set the JNDI connection like this:

    JNDI name=BC
    driver=sun.jdbc.odbc.JdbcOdbcDriver
    connect string=jdbcdbc:BC

    but actually I wrote the driver "sun.jdbc.odbc.JdbcOdbcDriver" manually because it wasn't in those listed...

    By the way, Pentaho Reporting returns me that "Connection was Successful" when I test the connection, and it also allow me to build the query;
    the problem is when I push the Next button: it says:
    "Error:[Microsoft][Driver ODBC Microsoft Access]Optional feature not implemented

    so...where is the problem??

    Thanks a lot

    Monica

  2. #2

    Default

    JDBCODBC is the way to go cause there isn't a JDBC driver for access, but it is the devils database as far as reporting goes so you have been warned!!

    As to your error, I've got no idea
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3

    Default

    MS Access is definitely the problem. A quick Google search for the error you're getting surfaces all kinds of problems using Access over the JDBC/ODBC bridge, like this one: http://saloon.javaranch.com/cgi-bin/...c&f=3&t=005230

    In that case, they had to map Access "long" to BigDecimal.

    If there's no really compelling reason to use Access, I'd recommend going with a non-desktop-caliber database -- there are several in open source, including MySQL, PostgreSQL, and Hypersonic/H2, all of which have real JDBC drivers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.