Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Access to MS sql server in linux

  1. #1
    Join Date
    Jun 2010
    Posts
    17

    Default Access to MS sql server in linux

    I am trying to run a transformation that reads a MS sql server data base. Connection done with jdbc
    The MS sql server database is in a server belonging to my local domaind
    When i run the transformation in my laptop (windows 7 logged in to the domain) there is no problem. Tried with spoon and with pan. In both everything is ok.
    When i upload the transformation to a linux server, in the same lan (debian) and run with pan, I get this error:
    2015/12/11 15:49:38 - Cliente-Primavera.0 - Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    2015/12/11 15:49:38 - Cliente-Primavera.0 - Unknown server host name 'EDIDBS'.
    2015/12/11 15:49:38 - Cliente-Primavera.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Erro inicializando step [Cliente-Primave ra]
    [EDIDBS] is the name of the MS sql server.
    I am using PDI 5.4.0.1-130.
    Any suggestions?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Sort out your name resolution issues. Your linux box can't convert EDIDBS into an IP address which is needed to talk to the MS SQL server

  3. #3
    Join Date
    Jun 2010
    Posts
    17

    Default

    Thank you. I replaced the server name with its IP address and everything workerd.

Tags for this Thread

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.