Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI 4.1.2 connectivity on Windows 7 OS (64 bit) and (Oracle or mySQL or SQLServer)

  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Default PDI 4.1.2 connectivity on Windows 7 OS (64 bit) and (Oracle or mySQL or SQLServer)

    Hello,
    I have just built a Windows 7 (64 bits) enterprise edition with
    1- mySQL 5
    2- SQLServer 2008 R2
    3-Oracle 11g r2 (32 bits)

    and is unable to connect to any RDBMS for reporsitory creation.
    Please advice
    Thanks

    P.S> I can connect with any SQL tool or ODBC Data Source Administrator to the instance and user

    See oracle Error
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    Error connecting to database [My_SORCL11G] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
    ...
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    Attached Images Attached Images
    Last edited by ishak2020; 02-21-2011 at 03:10 PM. Reason: add screen shots

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

    Default

    Especially for database repositories I would advise against using ODBC. That way you don't have to deal with the correct configuration of that either ;-)

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.