Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Updated Workbench: Not finding table

  1. #1
    Join Date
    May 2007
    Posts
    4

    Exclamation Updated Workbench: Not finding table

    Ok, I'm getting an odd error with the new workbench.
    I'm using MSSQL 2000 and I've got the JDBC driver in place. It populates all the dropdown fine, validates the schema find, but when I try and run an MDX query it fails to find the table that the cube is based on. It kicks back the following error.


    [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'dbo.<tablename>'.

    I've spelled the table name correctly, the JDBC has root access... any ideas?

  2. #2

    Default

    The Microsoft driver sucks.

    Try using jTDS http://jtds.sourceforge.net/

    Open Source is better than proprietary/commercial in this case!


    Sherman
    JasperSoft

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.