Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problem with access 2007 and win server 64bit

  1. #1
    Join Date
    Jun 2011
    Posts
    102

    Default Problem with access 2007 and win server 64bit

    Hi all,
    this is the situation: next week we have to migrate on a new server, and i'm testing if kettle is working well on it. Everything's ok, except for one thing: when i try to write data on an access 2007 db spoon return me this error:
    Code:
     [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
    This error appear beacause access 2007 doesn't support 64bit ODBC driver.

    I think the problem is that spoon point to the 64bit odbc panel (mydrive:\windows\system32\odbcad32.exe) and not to the 32bit (mydrive:\windows\systemWOW64\odbcad32.exe).

    is there a way to "force" kettle to use the second one instead the first one?

    Thanks in advance,
    Andrea

    system configuration
    kettle 4.1.0
    windows server 2008 R2 64bit

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    To solve this problem, I had to use 32-bit Java.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  3. #3
    Join Date
    Jun 2011
    Posts
    102

    Default

    Thanks for the response

  4. #4

    Default

    can you use 32bit java with Pentaho CE version 5?

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.