US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Unable to load the driver: net.sourceforge.jtds.jdbc.Driver SQL SERVER 2008

  1. #1

    Unhappy Unable to load the driver: net.sourceforge.jtds.jdbc.Driver SQL SERVER 2008

    I'm having the exact same problem as http://forums.pentaho.org/showthread...load+driver%3A

    I put sqljdbc.jar in C:\Pentaho\server\biserver-ce-3.5.0.stable\administration-console\jdbc and in
    C:\Pentaho\server\biserver-ce-3.5.0.stable\biserver-ce\tomcat\common\lib. Report works fine in PRD. Duplicated the data source name in PAC as well. Can't get the report to load in the BI Console though:

    Failed to open the connection: java.sql.SQLException: Unable to load the driver: net.sourceforge.jtds.jdbc.Driver

    Any ideas?

    Thanks,
    David

  2. #2

    Smile

    The solutions for me was to get the right "jar" in the right place.

    1) Go to http://sourceforge.net/projects/jtds/ and download the latest Open source JDBC driver
    2) Extract jtds-1.2.4.jar to ~\biserver-ce-3.5.0.stable\biserver-ce\tomcat\common\lib. Probably should do that for ~\biserver-ce-3.5.0.stable\administration-console\jdbc too.
    3 Restart the BI Server (and PAC).

    Should work now.

    Thanks,
    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •