Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: please help me with connectiong string to SQL Server

  1. #1
    Join Date
    Jan 2008

    Default please help me with connectiong string to SQL Server

    i converted the MondrianMart.mdb into sql server then, i've successfully created an odbc named MondrianSQLServer.
    this is my connection string, please correct it if its wrong because when i try the Jpivot pivot table page (testpage.jsp?query=mondrian) all i got is null value after i drilled down the table, thanks.

    mondrian.test.connectString=Provider=mondrian;Jdbc =jdbc: odbc:MondrianSQLServer;

    in web.xml
    Jdbc=jdbc: odbc:MondrianSQLServer;
    RoleXX='California manager';
    Jdbc=jdbc: odbc:MondrianFoodMart;
    RoleXX='California manager';

    in arrows.jsp, colors.jsp, fouhrier.jsp, mondrian.jsp
    <jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc: odbc:MondrianSQLServer" catalogUri="/WEB-INF/queries/FoodMart.xml">


  2. #2


    Narou please don't cross post in the forums its very annoying
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: 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(

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.