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?

    Rmadou

    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.