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.
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. :)
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.