Page 1 of 1
Configuration of DSN on Linux for DS
Posted: Mon Oct 03, 2005 5:57 am
by tombastian
Hi,
I am facing a problem with configuration of DSN on Linux. I set the entries in .odbc.ini and uvodbc.config files. I can connect to the Oracle DB from ODBC Stages using the DSN, user name & password. But if I try to import the metadata from DS Manager - "ODBC Definitions" - "Import MetaData (ODBC) window", the DSNs are not getting displayed in the dropdown. It shows the error "Empty DSN. List returned from Host <IP Address> ".
In short, the DSNs are not getting Displayed in the Drop Down for retrieving the meta data but the DSN is working from ODBC (We manually enter the DSN here). If any one can give input on this, it'll be of great help.
Thanks In Advance,
Tom.
Posted: Mon Oct 03, 2005 6:00 am
by ray.wurlod
Like any UNIX machine, you must have created your DSN definitions in .odbc.ini and in uvodbc.config files. Have you done both of these?
Posted: Mon Oct 03, 2005 6:22 am
by Luk
you probably set your settings in uvodbc.config placed in $dshome directory. You must type
in
uvodbc.config placed in
projects/your_project folder.
regards
Posted: Tue Oct 04, 2005 12:14 am
by tombastian
Thanks Luke. It was because, I did not copy the uvodbc.config file to the project directories.
Thanks,
Tom
How to configure DSN in unix
Posted: Wed Oct 05, 2005 2:47 am
by anujgarg
Hi,
I am new to datastage.I have checked odbc.ini and Uvodbc.config and tried to change but it is just showing dsn name only in case of importing table but could not connect to database.Please give the proper details to configure dsn with example,how you have configured it.
Posted: Wed Oct 05, 2005 2:51 am
by Luk
when you configure your DSN both in .odbc.ini and uvodbc.config you are able to see these DSNs both while imprting meta data and while you try to connect to database using ODBC stage
Posted: Wed Oct 05, 2005 3:36 am
by anujgarg
Hi,
While Importing the meta data fro the newly created DSN.I am facing the error
DSR.MetaGeta(GET.TABLES)(SQLConnect('Oracle Wire Protocol','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
The Content of .odbc.ini is
Code: Select all
[Oracle Wire Protocol]
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=199.38.140.189
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=DWTST01
UseCurrentSchema=1
The Content of uvodbc.config is
Code: Select all
<Oracle Wire Protocol>
DBMSTYPE = ODBC
I am unable to determine where i went wrong. All suggestions are welcome.
Thanks,
Anuj
Posted: Wed Oct 05, 2005 4:25 am
by rumu
Hi All,
In uvodbc.config the default entry is
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
so to access universe database through ODBC stage we need to modify
DBMSTYPE =ODBC or we need to enter a separate entry for ODBC like
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 127.0.0.1
Thanks in advance
rumu
Posted: Wed Oct 05, 2005 5:10 am
by anujgarg
In my case, 'Oracle wire Protocol' is the DSN name.In the administration guide it is given that for adding entry in uvodbc.config file
we have to give just DSN name in format <dsn-name> and then
DBMSTYPE = ODBC
to differentiate from universe connection.In my case I am changing the uvodbc.config file in projects/projectname folder while .odbc.ini file in DSEngine.
Thanks,
Anuj