Datadirect on AIX to Greenplum: Errors... - Forum - DataDirect Connect - Progress Community

Datadirect on AIX to Greenplum: Errors...

 Forum

Datadirect on AIX to Greenplum: Errors...

  • Hi,

    I'm running DataDirect for Greenplum on AIX 7.1 (64bit). 

    The installation of the driver went well.

    The environment variables are set correctly; LIBPATH

    The ODBC 'ini' files have the correct entry. 

    But when we run the 'example' program that comes with DataDirect we get these errors. 

    • Does this 'example' program really work
    • Do these error messages look familiar 

    Any help is appreciated. 

    example DataDirect Technologies, Inc. ODBC Example Application.

    Enter the data source name : XXXXXXXX

    Enter the user name : YYYYYYYY

    Enter the password : ZZZZZZZZZZZZZZZ

    Enter SQL statements (Press ENTER to QUIT)
    SQL> select version();

    2713Greenplum ODBC driver2726Greenplum ODBC driver.2728
    SQLSTATE = 60
    NATIVE ERROR = 2713
    MSG = [DataDirect][ODBC 20101 driver]2713Greenplum ODBC driver2726Greenplum ODBC driver.

    SQLSTATE = 60
    NATIVE ERROR = 2728
    MSG = [DataDirect][ODBC 20101 driver]2728


    Enter SQL statements (Press ENTER to QUIT)
    SQL>
    Exiting from the Example ODBC program

  • While not the cause the error, we can see by the fact that you are getting error numbers returned instead of the actual messages that something is not quite right in your ODBC environment and the driver can find it's message files.  That's why you are seeing things like 'ODBC 20101 Driver' and the error numbers 2713, 2726, 2728 etc being returned instead of an error message that you can read.

    The following KB article will assist with correcting your ENV so that the message files can be found by the driver.  It won't correct the condition that lead to the error but once you can see the error message the problem may be self-explanatory.

  • It will probably be a lot more helpful if I actually include a link to the KB article this time.  :)

    knowledgebase.progress.com/.../3556

  • Bruce,

    Thanks for the link, but no joy.

    We checked the entries in the INI files and double verified them - they are correct.

    Checked all the ENV variables as well.

    In addition LIBPATH is set correctly and DataDirect drivers are first on the list to prevent library collision.

    tsasct01:/opt/Progress/DataDirect/Connect64_for_ODBC_71/locale/en_US/LC_MESSAGES>env | grep LANG

    LANG=en_US

    tsasct01:/opt/Progress/DataDirect/Connect64_for_ODBC_71/locale/en_US/LC_MESSAGES>env | grep ODBCINST

    ODBCINST=/sasuser/sas/odbcinst.ini

    tsasct01:/opt/Progress/DataDirect/Connect64_for_ODBC_71/locale/en_US/LC_MESSAGES>ll

    total 1692

      4 drwxr-xr-x    2 sas      sasgrp         4096 Jan 21 2015  .

      0 drwxr-xr-x    3 sas      sasgrp          256 Jan 21 2015  ..

     56 -rw-r--r--    1 sas      sasgrp        55881 Oct 22 2013  ddase27.mo

     56 -rw-r--r--    1 sas      sasgrp        54564 Oct 22 2013  ddase27.po

     84 -rw-r--r--    1 sas      sasgrp        85826 Apr 17 2014  dddb227.mo

     84 -rw-r--r--    1 sas      sasgrp        84134 Apr 17 2014  dddb227.po

     48 -rw-r--r--    1 sas      sasgrp        48655 Apr 29 2014  ddgplm27.mo

     48 -rw-r--r--    1 sas      sasgrp        47422 Apr 29 2014  ddgplm27.po

     48 -rw-r--r--    1 sas      sasgrp        47419 Apr 24 2014  ddhive27.mo

     48 -rw-r--r--    1 sas      sasgrp        46198 Apr 24 2014  ddhive27.po

    108 -rw-r--r--    1 sas      sasgrp       108302 Sep 16 2013  ddifcl27.mo

    108 -rw-r--r--    1 sas      sasgrp       107143 Sep 16 2013  ddifcl27.po

     48 -rw-r--r--    1 sas      sasgrp        47411 Apr 24 2014  ddimpala27.mo

     48 -rw-r--r--    1 sas      sasgrp        46190 Apr 24 2014  ddimpala27.po

     12 -rw-r--r--    1 sas      sasgrp        11620 Apr 04 2014  ddmback.mo

     12 -rw-r--r--    1 sas      sasgrp        11581 Apr 04 2014  ddmback.po

     12 -rw-r--r--    1 sas      sasgrp        12274 Jun 02 2014  ddmbackw.mo

     12 -rw-r--r--    1 sas      sasgrp        12235 Jun 02 2014  ddmbackw.po

     52 -rw-r--r--    1 sas      sasgrp        51152 Sep 09 2013  ddmysql27.mo

     52 -rw-r--r--    1 sas      sasgrp        49870 Sep 09 2013  ddmysql27.po

     48 -rw-r--r--    1 sas      sasgrp        47293 Dec 06 2013  ddoe27.mo

     48 -rw-r--r--    1 sas      sasgrp        46082 Dec 06 2013  ddoe27.po

     56 -rw-r--r--    1 sas      sasgrp        56203 Apr 14 2014  ddora27.mo

     56 -rw-r--r--    1 sas      sasgrp        54942 Apr 14 2014  ddora27.po

     48 -rw-r--r--    1 sas      sasgrp        48475 Dec 20 2013  ddpsql27.mo

     48 -rw-r--r--    1 sas      sasgrp        47243 Dec 20 2013  ddpsql27.po

     52 -rw-r--r--    1 sas      sasgrp        52146 Oct 23 2012  ddsfrc27.mo

     52 -rw-r--r--    1 sas      sasgrp        50881 Oct 23 2012  ddsfrc27.po

     52 -rw-r--r--    1 sas      sasgrp        51482 Apr 15 2014  ddsqls27.mo

     52 -rw-r--r--    1 sas      sasgrp        50228 Apr 15 2014  ddsqls27.po

     56 -rw-r--r--    1 sas      sasgrp        55889 Sep 24 2013  ddsyiq27.mo

     56 -rw-r--r--    1 sas      sasgrp        54572 Sep 24 2013  ddsyiq27.po

     44 -rw-r--r--    1 sas      sasgrp        43776 Dec 07 2013  ddtera27.mo

     44 -rw-r--r--    1 sas      sasgrp        42615 Dec 07 2013  ddtera27.po

     20 -rw-r--r--    1 sas      sasgrp        20213 Sep 19 2013  odbc.m

     20 -rw-r--r--    1 sas      sasgrp        19099 Sep 19 2013  odbc.po

  • Hi!

    It looks like the evaluation of your Greenplum ODBC driver has expired.  We will be in touch with you shortly in order to extend your license!

  • Great!

    Sorry but when it comes time to setup drivers on Unix systems like AIX it take about 15 days just to get everything installed.

    Look forward to your response.

  • Well we applied the new licenses for Greenplum.

    No luck same errors.

    So it doesn't appear to be a license issue.

    Any ideas on why this isn't working?

  • Hi Paul.  I will be replying directly to you off of this thread.