Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: 4D (or generic database) ODBC connection issues

  1. #1

    Default 4D (or generic database) ODBC connection issues

    Hi all,

    I know 4D is a bit of an obscure database but its the database we have. I am trying to make a solid connection to it in Spoon and can't seem to get it working just right.
    I am currently able to make a connection through the Generic Database type ODBC access type. I am able to send SQL queries through the connection but am getting odd returns. I am only getting numeric data returned (i.e. int, floats and even date/time stamps) but all text type data is coming back as null.

    Does anybody have specific knowledge on connecting to 4D with Spoon or with generic databases presenting similar problems?


    I figured this out (with some help of course). I n the end I needed to revert to a 32 bit set u (i.e. 32 bit java) so I could run the 32 bit ODBC for the 4D database connection.
    Last edited by rmadou; 04-11-2012 at 05:40 PM.

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.