DataDirect ODBC drivers version 5.0 expired after 15 days
Posted: Tue Feb 17, 2009 4:59 am
Error Message:
----------------------------------
J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]File not found 'IVVM.LIC'.
J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]You are not licensed to use this DataDirect Technologies ODBC Driver under the license you have purchased. If you wish to purchase a license for use with this application, then you may use this driver for a period of 15 days, during which time you are required to obtain a license.
----------------------------------
Can connect to Oracle 10g source and Oracle 10G target by SQL+. We were able to view data in DataStage Designer window on Friday. On Monday, which was 15 days after install of DataStage we received the error. Have a non-root install on AIX, which is per company policy, and we do not have the Oracle client installed on the server, which is also per policy. This requires us to use the DataDirect ODBC drivers to connect.
I have searched posts and researched documentation and feel its not a problem with the driver being expired may be related to the first part of the error message: File not found 'IVVM.LIC'. This file is located in the branded odbc folder but it may not be referenced correctly in DSENV.
DSENV
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH
fi
ORACLE_HOME=/applications/oracle/10.2.0.3
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$DSHOME/lib
LIBPATH=$DSHOME/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH
ORACLE_SID=DMEPM
export ORACLE_HOME ORACLE_SID
Tried both versions of DSENV with LIBPATH for AIX (we are on AIX 5.3)and with LD_LIBRARY_PATH. Got same 15 day expired ODBC driver expired error for both files. We used the Data Direct utility- demoodbc, and got same error. When we used the Test ODBC utility in DataStage on page 3-38 of the Install Guide and we able to successfully connect.
The file IVVM.LIC is in the branded folder and the permissions on the file are rwxr-xr-x.
----------------------------------
J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]File not found 'IVVM.LIC'.
J_Stage_PS_ABS_CODE_TBL_HCM9_EPM9..DRS_SRC_PS_ABS_CODE_TBL: [DataDirect][ODBC Oracle Wire Protocol driver]You are not licensed to use this DataDirect Technologies ODBC Driver under the license you have purchased. If you wish to purchase a license for use with this application, then you may use this driver for a period of 15 days, during which time you are required to obtain a license.
----------------------------------
Can connect to Oracle 10g source and Oracle 10G target by SQL+. We were able to view data in DataStage Designer window on Friday. On Monday, which was 15 days after install of DataStage we received the error. Have a non-root install on AIX, which is per company policy, and we do not have the Oracle client installed on the server, which is also per policy. This requires us to use the DataDirect ODBC drivers to connect.
I have searched posts and researched documentation and feel its not a problem with the driver being expired may be related to the first part of the error message: File not found 'IVVM.LIC'. This file is located in the branded odbc folder but it may not be referenced correctly in DSENV.
DSENV
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH
fi
ORACLE_HOME=/applications/oracle/10.2.0.3
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$DSHOME/lib
LIBPATH=$DSHOME/branded_odbc/lib:$DSHOME/lib:$DSHOME/uvdlls:$DSHOME/java/jre/bin/classic:$DSHOME/java/jre/bin:$LIBPATH
export LIBPATH
ORACLE_SID=DMEPM
export ORACLE_HOME ORACLE_SID
Tried both versions of DSENV with LIBPATH for AIX (we are on AIX 5.3)and with LD_LIBRARY_PATH. Got same 15 day expired ODBC driver expired error for both files. We used the Data Direct utility- demoodbc, and got same error. When we used the Test ODBC utility in DataStage on page 3-38 of the Install Guide and we able to successfully connect.
The file IVVM.LIC is in the branded folder and the permissions on the file are rwxr-xr-x.