Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Another how do I connect to MS SQL from Report Designer 7.0.0-25

  1. #1
    Join Date
    Nov 2016
    Posts
    4

    Default Another how do I connect to MS SQL from Report Designer 7.0.0-25

    Good day

    I have recently downloaded report designer version 7.0.0. I am unable to create a data source to MS SQL server. I have downloaded sqljdbc4.jar and placed it in the \report-designer\lib\jdbc directory. Nothing works the error message is

    Driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' could not be found, make sure the 'MS SQL Server (Native)' driver (jar file) is installed.
    com.microsoft.sqlserver.jdbc.SQLServerDriver

    Funny thing is I downloaded an older copy of Pentaho Report Designer 5.0.1. I follow the exact same steps, use a copy of sqljdbc4.jar, same database. And voilà it worked first time.

    The only documentation I can find for Report Designer is for a flavor of 3.x.x.

    Does anyone know what might have changed in version 7.0.0 from earlier versions?

    cheers

    bob

  2. #2
    Join Date
    Oct 2016
    Posts
    4

    Default

    did you have any luck with this? Upgraded Kettle from v6.1 -> 7.0 and having same issue.

  3. #3
    Join Date
    Nov 2016
    Posts
    4

    Default

    Nope we were looking at Pentaho as a replacement solution. Since I could not figure this out or get support, we abandoned this option. Best of luck

    cheers

  4. #4
    Join Date
    Nov 2009
    Posts
    688

    Default

    Rename the sqljdbc4.jar file to sqljdbc.jar or use the jtds file (then use the MS SQL Server option and not the MS SQL Server (Native))

  5. #5
    Join Date
    Nov 2016
    Posts
    4

    Default

    Quote Originally Posted by johanhammink View Post
    Rename the sqljdbc4.jar file to sqljdbc.jar or use the jtds file (then use the MS SQL Server option and not the MS SQL Server (Native))

    Thanks johanhammink

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.