Neither of which require ODBC to access as there are 'native' stages available for each.drostnu wrote:i have oracle and sybase dbs running.
DSN Names
Moderators: chulett, rschirm, roy
Re: problem
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
so...
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
cool
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
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/.