DSN Names

[chulett]

i have oracle and sybase dbs running.

Neither of which require ODBC to access as there are 'native' stages available for each.

[drostnu]

so i cant really do nothing about it?



http://img529.imageshack.us/img529/9917/dsnemptykm7.jpg

thanks

diego.

[chulett]

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.

[drostnu]

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

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

in uvconfig

Code: Select all

<WEBRSLAC>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 127.0.0.1

please, and i am getting this error.

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

Please gimme a help on this.

thanks in advance

regards

[drostnu]

now im using another driver for WEBRSLAC

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(*.*)

im using DataDirect 5.0 Oracle instead DataDirect 5.0 Oracle Wire Protocol, and it gaves me another error different

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

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/.