Configuration of DSN on Linux for DS

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

[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?

[Luk]

you probably set your settings in uvodbc.config placed in $dshome directory. You must type

Code: Select all

<your_dsn_name>
DBMSTYPE = ODBC

in uvodbc.config placed in projects/your_project folder.

regards

[tombastian]

Thanks Luke. It was because, I did not copy the uvodbc.config file to the project directories.

Thanks,
Tom

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

[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

[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

[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

[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