Re: problem
Posted: Fri Aug 18, 2006 11:31 am
Neither of which require ODBC to access as there are 'native' stages available for each.drostnu wrote:i have oracle and sybase dbs running.
Page 2 of 2
so...
Posted: Fri Aug 18, 2006 11:37 am
so i cant really do nothing about it?
http://img529.imageshack.us/img529/9917/dsnemptykm7.jpg
thanks
diego.
http://img529.imageshack.us/img529/9917/dsnemptykm7.jpg
thanks
diego.
Posted: Fri Aug 18, 2006 11:55 am
No, didn't say that. Just said that you don't need to use ODBC to access Oracle or Sybase... unless that's really what you want to do.
First question would be - is your DataStage server on UNIX or Windows? That answer will drive how you set things up.
First question would be - is your DataStage server on UNIX or Windows? That answer will drive how you set things up.
cool
Posted: Tue Aug 22, 2006 8:12 am
im running Datastage on Linux Red Hat server v3.0 Update5.
thanks chulett.
edit:
i have a database called WEBRSLAC running on localhost (127.0.0.1)
so far. i configured the odbc.ini and uvconfig (from Colombia project,
in odbc.ini
in uvconfig
please, and i am getting this error.
Please gimme a help on this.
thanks in advance
regards
thanks chulett.
edit:
i have a database called WEBRSLAC running on localhost (127.0.0.1)
so far. i configured the odbc.ini and uvconfig (from Colombia project,
in odbc.ini
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
thanks in advance
regards
now
Posted: Tue Aug 22, 2006 11:20 am
now im using another driver for WEBRSLAC
im using DataDirect 5.0 Oracle instead DataDirect 5.0 Oracle Wire Protocol, and it gaves me another error different
so i checked the TNSNAMES.ORA and its fine
WEBRSLAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = WEBRSLAC)
)
)
so its fine.
please give me a hand.
regards
Diego/.
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
WEBRSLAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = WEBRSLAC)
)
)
so its fine.
please give me a hand.
regards
Diego/.