DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
alexcol
Participant



Joined: 28 Feb 2011
Posts: 17

Points: 243

Post Posted: Fri Mar 25, 2011 11:42 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
Additional info: Teradata]User identification is not authorized error
Good afternoon
I need yor help because i havent been able to Connect to Tearadata using ds command shell:

connect Teradata_Pro
Enter username for connecting to 'Teradata_Pro' DBMS [dsadm]: dsadm
Enter password for dsadm:
SQLConnect error: Status = -1 SQLState = S1000 Natcode = -3004
[ODBC:-3004] [IBM(DataDirect OEM)][ODBC Teradata Client driver][Teradata]User identification is not authorized.

checking out the 3 ODBC config files files ie in dsenv file there is an entry calling the userbd and passwd called dsadm:

PATH=$PATH/opt/teradata/client/13.0/bin
export ORACLE_HOME=/oracle/product/10.2.0
export ORACLE_SID=xmeta
PATH=$PATH:/oracle/product/10.2.0/bin
export PATH=$PATH:/datastage/IBM/InformationServer/ASBNode/apps/jre/bin
export USERBD=dsadm
export PASSBD=dsadm

Acording to these 2 last lines this is not the authorized user and passwd?
But in the .odbc.ini file theres no information provided with the user and paswd:

[Teradata_Pro]
Driver=/datastage/IBM/InformationServer/Server/branded_odbc/lib/VMtera23.so
Description=DataDirect Teradata
CharacterSet=ASCII
DBCName=10.80.4.20
#Database=SQL_gaguirre
EnableDataEncryption=No
EnableLOBs=Yes
EnableReconnect=No
IntegratedSecurity=No
LoginTimeout=20
MapCallEscapeToExec=No
MaxRespSize=8192
#Password=SQL_gaguirre
PortNumber=1025
PrintOption=N
ProcedureWithSplSource=Y
ReportCodePageConversionErrors=0
ShowSelectableTables=Yes
#UserID=SQL_gaguirre

_________________
ALEJO
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours