Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Workbench and Access DB - how to connect?

  1. #1
    Join Date
    Apr 2008
    Posts
    3

    Default Workbench and Access DB - how to connect?

    Hy Folks...

    i set up the tomcat server, teh mondrian application and now I'm trying to get a connection to the demo DB Access with the workbench but it does not work.

    what do I have to put in teh fields?

    Driver Class Name: jdbcdbc:MondrianFoodMart
    Connection Url: C:\mondrian\demo\access\MondrianFoodMart.mdb

    ??

    Tankx

  2. #2

    Default Workbench and Access DB - how to connect

    Hi JohnDoo,

    The steps to follow:

    1.- Define ODBC connection in your Windows System
    2.- Copy the rt.jar (this file is in /java/jre/lib in your Windows) iin your workbench instalation /lib

    3.- define the connection

    driver Class: sun.jdbc.odbc.Driver
    string url: jdbcdbc:yourOdbcName

    It's all
    Enric Biosca
    Project Director at ICA

  3. #3
    Join Date
    Apr 2008
    Posts
    3

    Default

    Hi,

    thankx for the help, but it doesnt work. I did set up the Java, Tomcat and Mondrian like in the manual written:

    "Under the 'Administrative Tools' menu, click on the 'Data Sources (ODBC)' menu item to open the ODBC Data Source Administrator. Next, create a System DSN called MondrianFoodMart pointing to MONDRIAN_HOME/demo/access/MondrianFoodMart.mdb. (This allows Mondrian to access this data source using the JDBC connect string "jdbcdbc:MondrianFoodMart"."

    Microsoft ODBC Admin:

    Code:
    MondrianFoodmart
    C:\...\MondrianFoodmart.mdb
    So, the webapplication is running fine with mondrian - I can use for example the JPivot test page. Afterwards I installed the workbench, copied the rt.jr in the /lib directory and wrote the following preferences:

    Code:
    Driver Class Name: sun:jdbc:odbc:Driver
    Connection URL: jdbc:odbc:MondrianFoodMart
    It still says: Database connection could not be done...

    Any hints i could miss?

  4. #4
    Join Date
    Apr 2008
    Posts
    3

    Default

    Forget it, my fault, it jaust have to be the right driver and this has to be
    Code:
    sun.jdbc.odbc.JdbcOdbcDriver
    thank you for the help, its working

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.