Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: PRD connection to SQL Server

  1. #1

    Default PRD connection to SQL Server

    Getting a message "Failed to open the connection: java.sql.SQLException: Unable to get information from SQL Server:". Did some Googling and arrived at "Why do I get a java.sql.SQLException: "Unable to get information from SQL Server" when trying to connect to an SQL Server instance?" http://jtds.sourceforge.net/faq.html#instanceGetInfo

    Anyway, turned on "SQL Server Browser" but still getting message.

    Any ideas?
    David

  2. #2
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    I've read about some problembs between the JTDS driver included with the distribution and the latest versions of SQL Server. If you're using MSSQL > 2000, you may want to try upgrading the driver.

    A long shot, but easy enough to try...

    Cheers!
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

  3. #3

    Default

    Thanks for the reply. I'm using SQL Server 2008. Also, using what I think is the latest version of sqljdbc.jar.

    David
    Attached Images Attached Images  

  4. #4
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    I'd give JTDS a shot. It works like a charm: http://sourceforge.net/projects/jtds...t.zip/download

    Just be sure to remove the older version.
    (en) Path to Pentaho knowledge: (1:Search the Wiki > 2:Search the Forums > 3:Ask) or (1:Get a Subscription)
    (es) El camino al conocimiento en Pentaho: (1:Buscar en la Wiki > 2:Buscar en los Foros > 3:Preguntar) o (1:Comprar una Subscripción)

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.