I am trying to create DSN on unix,but facing the problem.I have created the 'ora' DSN but it is giving warning and not able to connect to database.
First i have created the DSN in .odbc.ini in DSEngine
And Then i have added DSN in Uvodbc.config in specific Projects folder.[Ora]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMora19.so
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=149.27.178.145
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=DWTST01
UseCurrentSchema=1
Code: Select all
<Ora>
DBMSTYPE = ODBC
I am not able to see the DSN name also while using ODBC stage.DSR.MetaGeta(GET.TABLES)(SQLConnect('Ora','dwd6')): BCI Error:
SQLSTATE=HY000,CODE=7505,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
SQLSTATE=HY000,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination
All suggestions are Welcomed.
Thanks and Regards,
Anuj