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
    Posts
    7

    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.

    in mondrian.properties
    mondrian.test.connectString=Provider=mondrian;Jdbc =jdbc: odbc:MondrianSQLServer;
    JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;Catalog=/WEB-INF/queries/FoodMart.xml;

    in web.xml
    ...
    <context-param>
    <param-name>connectString</param-name>
    <param-value>Provider=mondrian;
    Jdbc=jdbc: odbc:MondrianSQLServer;
    Catalog=/WEB-INF/queries/FoodMart.xml;
    JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;
    RoleXX='California manager';
    </param-value>
    </context-param>
    ...
    <init-param>
    <param-name>connectString</param-name>
    <param-value>Provider=mondrian;
    Jdbc=jdbc: odbc:MondrianFoodMart;
    Catalog=/WEB-INF/queries/FoodMart.xml;
    JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;
    RoleXX='California manager';
    </param-value>
    </init-param>
    ...

    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">

    thx

  2. #2

    Default

    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: 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

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.