I faced odbc connect error:
OS:Red Hat 4.1.2-14
DS:8.5
TTU:13.10
TPT:13.10
I configed the dsenv, .odbc.ini .When i tried to test connection by example commend, it recived some errors as below.
Does any one know the question? Thanks.
Code: Select all
[dsadm1@localhost example]$ ./example
./example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : tddemo
Enter the user name : dbc
Enter the password : dbc
SQLSTATE = 28000
NATIVE ERROR = 0
MSG = [Teradata][ODBC Teradata Driver] Not enough information to log on
SQLConnect: Retrying Connect.
SQLSTATE = 28000
NATIVE ERROR = 0
MSG = [Teradata][ODBC Teradata Driver] Not enough information to log on
SQLConnect: Retrying Connect.
SQLSTATE = 28000
NATIVE ERROR = 0
MSG = [Teradata][ODBC Teradata Driver] Not enough information to log on
SQLConnect: Retrying Connect.
my dsenv file:
Code: Select all
#!/bin/sh
####################################################################
#
# dsenv - DataStage environment file
#
# Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2009 All Rights Reserved.
# This is unpublished proprietary source code of IBM Corporation
# The copyright notice above does not evidence any actual or
# intended publication of such source code.
#
# This script is sourced by the DataStage dsrpcd daemon to establish
# proper environment settings for DataStage client connections.
#
# This script may also be sourced by bourne shells to establish
# proper environment settings for local DataStage use.
#
####################################################################
# PLATFORM SPECIFIC SECTION
set +u
if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi
if [ -z "$DSHOME" ]
then
DSHOME=/is/IBM/InformationServer/Server/DSEngine; export DSHOME
fi
if [ -z "$DSRPCD_PORT_NUMBER" ]
then
true
DSRPCD_PORT_NUMBER=31538; export DSRPCD_PORT_NUMBER
fi
if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/is/IBM/InformationServer/Server/PXEngine; export APT_ORCHHOME
fi
#if [ -z "$UDTHOME" ]
#then
UDTHOME=/is/IBM/InformationServer/Server/DSEngine/ud41 ; export UDTHOME
UDTBIN=/is/IBM/InformationServer/Server/DSEngine/ud41/bin ; export UDTBIN
#fi
#if [ -z "$ASBHOME" ] && [ -f "$DSHOME/.asbnode" ]
#then
ASBHOME=`cat $DSHOME/.asbnode`
export ASBHOME
#fi
#if [ -z "$ASBHOME" ]
#then
#ASBHOME=`dirname \`dirname $DSHOME\``/ASBNode
#export ASBHOME
#fi
if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME
#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES
LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/linux-all-x86_64:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LD_PRELOAD=`dirname $DSHOME`/DSComponents/lib/libicui18n.so
export LD_PRELOAD
fi
TWB_ROOT=/opt/teradata/client/13.10/tbuild
TTUPATH=/opt/teradata/client/13.10
#ICUPATH=/opt/teradata/client/13.10/tdicu
ODBCPATH=/opt/teradata/client/13.10/odbc_64
PATH=$TWB_ROOT/bin:$PATH
LD_LIBRARY_PATH=$TWB_ROOT/lib64:$TTUPATH/lib64:$ODBCPATH/lib:$LD_LIBRARY_PATH
NLSPATH=$TWB_ROOT/msg/%N:${ODBCPATH}/msg/%N.cat
export TWB_ROOT PATH LIBPATH NLSPATH
COPLIB=$TWB_ROOT/../lib
COPERR=$TWB_ROOT/../libCode: Select all
[TDDEMO]
Driver=/opt/teradata/client/13.10/odbc_64/lib/tdata.so
Description=DataDirect Teradata
AccountString=
CharacterSet=ASCII
DBCName=192.168.164.129
Database=
EnableDataEncryption=No
EnableLOBs=Yes
EnableReconnect=No
IntegratedSecurity=No
LoginTimeout=20
MapCallEscapeToExec=No
MaxRespSize=8192
Password=dbc
PortNumber=1025
PrintOption=N
ProcedureWithSplSource=Y
ReportCodePageConversionErrors=0
SecurityMechanism=
SecurityParameter=
ShowSelectableTables=Yes
UserID=dbc
my env:
Code: Select all
MANPATH=/opt/teradata/client/13.10/odbc_32/help/man:
DSHOME=/is/IBM/InformationServer/Server/DSEngine
HOSTNAME=localhost.localdomain
TERM=vt100
SHELL=/bin/bash
HISTSIZE=1000
SSH_CLIENT=192.168.164.1 49517 22
LD_PRELOAD=/is/IBM/InformationServer/Server/DSComponents/lib/libicui18n.so
SSH_TTY=/dev/pts/1
USER=dsadm1
LD_LIBRARY_PATH=/opt/teradata/client/13.10/tbuild/lib64:/opt/teradata/client/13.10/lib64:/opt/teradata/client/13.10/odbc_64/lib:/is/IBM/InformationServer/Server/branded_odbc/lib:/is/IBM/InformationServer/Server/DSComponents/lib:/is/IBM/InformationServer/Server/DSComponents/bin:/is/IBM/InformationServer/Server/DSEngine/lib:/is/IBM/InformationServer/Server/DSEngine/uvdlls:/is/IBM/InformationServer/Server/PXEngine/lib:/is/IBM/InformationServer/ASBNode/apps/jre/bin:/is/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/is/IBM/InformationServer/ASBNode/lib/cpp:/is/IBM/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86_64:/opt/teradata/client/13.10/tbuild/lib:/usr/lib
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
APT_ORCHHOME=/is/IBM/InformationServer/Server/PXEngine
NLSPATH=/opt/teradata/client/13.10/tbuild/msg/%N:/opt/teradata/client/13.10/odbc_64/msg/%N.cat
MAIL=/var/spool/mail/dsadm1
PATH=/opt/teradata/client/13.10/tbuild/bin:/opt/teradata/client/13.10/tbuild/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/dsadm1/bin
DSRPCD_PORT_NUMBER=31538
TD_ICU_DATA=/opt/teradata/client/13.10/tdicu/lib
INPUTRC=/etc/inputrc
PWD=/is/IBM/InformationServer/Server/branded_odbc/example
UDTBIN=/is/IBM/InformationServer/Server/DSEngine/ud41/bin
LANG=en_US.UTF-8
COPLIB=/opt/teradata/client/13.10/tbuild/../lib
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/dsadm1
ODBCINI=/is/IBM/InformationServer/Server/DSEngine/.odbc.ini
TWB_ROOT=/opt/teradata/client/13.10/tbuild
ASBHOME=/is/IBM/InformationServer/ASBNode
COPERR=/opt/teradata/client/13.10/tbuild/../lib
LOGNAME=dsadm1
CVS_RSH=ssh
SSH_CONNECTION=192.168.164.1 49517 192.168.164.140 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
UDTHOME=/is/IBM/InformationServer/Server/DSEngine/ud41
G_BROKEN_FILENAMES=1
_=/bin/env
OLDPWD=/is/IBM/InformationServer/Server/branded_odbc