Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Progress 9.x JDBC in PDI 4.0

  1. #1
    Join Date
    Jun 2009
    Posts
    13

    Default Progress 9.x JDBC in PDI 4.0

    Due to decisions outside my control , we are still running a Progress 9.1e database for one of our business systems

    I have happily used PDI 3.2 JDBC connection on a WinXP box using:
    + Copied progress.jar and jdbc.jar from Progress path to ..\libext\JDBC path
    + Copied JdbcProgress.dll and procli92.dll from Progress path to ..\libswt\win32
    + Generic Database connection:
    +++ Custom Connection URL: "jdbc:jdbcprogress:T:my_ip_addressort_nbr:db_name"
    +++ Custom Driver Class Name: "com.progress.sql.jdbc.JdbcProgressDriver"

    I am able to run 3.2 right now, connecting to Progress database just fine.

    I attempted to set up the exact same connection in PDI 4.0 (I have double-checked my files and settings 4 or 5 times), and I get
    "No suitable driver found for jdbc:jdbcprogress:T....."

    Does 4.0 find the dll files in a different way/path than 3.2?

  2. #2
    Join Date
    Jun 2009
    Posts
    13

    Default

    Not really looking for someone to say "Here's how you hook up Progress", I already have it working with v 3.2.

    Was just hoping that someone could tell me if the method/path that PDI is looking for these 3rd party .dll or .jar files has changed from 3.2 to 4.0/4.1?

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's possible since the application launcher has changed a bit.

  4. #4
    Join Date
    Jun 2009
    Posts
    13

    Default

    This is working again in the 4.1 version released on 11/30.

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It's also fixed in 4.0.2

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.