Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Solution to connection problem with SQL Server 2005 by Sanjukta Samom, iCreate

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Aug 2008

    Default Solution to connection problem with SQL Server 2005 by Sanjukta Samom, iCreate

    Solution by SANJUKTA SAMON, iCreate Softwares:

    To connect the SQL server database with an instance name, incorporate the below in the web.xml file,

    <!-- Connection String For SQL Server -->
    <param-value>Provider=Mondrian;Jdbc=jdbc:sqlserver://\saba_devl_vyasa_bizscore;jdbc.instanceN ame=ads;jdbc.username=sa;jdbc.password=Welcome1;Jd iver;Catalog=/WEB-INF/schema/bizscore.xml;</param-value>

    The ads in the above string needs to be changed with the required instance name. The back-slash before the database name is very important. A forward slash will cause the connection to fail invoking unknown host exception.

  2. #2
    Join Date
    Aug 2008

    Default ygiriyap, iCreate Software

    The below string a tested connection string to connect from mondrian to mssql 2005.
    This tells how to provide a connection string having host,port,instanceName,databaseName and DataSourceChangeListener.

    Provider=Mondrian;Jdbc=jdbc:sqlserver://<host>\<instanceName>:<port>;jdbc.databaseName=<databaseName>;jdbc.username=<userName>;jdbc.password=<password>;;Catalog=/WEB-INF/schema/bizscore.xml;DataSourceChangeListener=<fully qualified name of the class implementing DataSourceChangeListner interface>;


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.