Neither of which require ODBC to access as there are 'native' stages available for each.drostnu wrote:i have oracle and sybase dbs running.
![Confused :?](./images/smilies/icon_confused.gif)
Moderators: chulett, rschirm, roy
Neither of which require ODBC to access as there are 'native' stages available for each.drostnu wrote:i have oracle and sybase dbs running.
Code: Select all
[WEBRSLAC]
Driver=/local/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.so
Description=WEBRSLAC DB
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=127.0.0.1
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=WEBRSLAC
UseCurrentSchema=1
Code: Select all
<WEBRSLAC>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 127.0.0.1
Code: Select all
DSR.MetaGeta(GET.TABLES)(SQLConnect('WEBRSLAC','r_jobs')): BCI Error:
SQLSTATE=08S01,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination
Code: Select all
[ODBC Data Sources]
DB2 Wire Protocol=DataDirect 5.0 DB2 Wire Protocol Driver
dBase=DataDirect 5.0 dBaseFile(*.dbf)
Informix=DataDirect 5.0 Informix
Informix Wire Protocol=DataDirect 5.0 Informix Wire Protocol
Oracle=DataDirect 5.0 Oracle
Oracle Wire Protocol=DataDirect 5.0 Oracle Wire Protocol
WEBRSLAC=DataDirect 5.0 Oracle
SQLServer Wire Protocol=DataDirect 5.0 SQL Server Wire Protocol
Sybase Wire Protocol=DataDirect 5.0 Sybase Wire Protocol
Text=DataDirect 5.0 TextFile(*.*)
Code: Select all
DSR.MetaGeta(GET.TABLES)(SQLConnect('WEBRSLAC','r_jobs')): BCI Error:
SQLSTATE=08001,CODE=12162,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12162: TNS:net service name is incorrectly specified