Configuration of DSN on Linux for DS
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Fri Jun 04, 2004 5:52 am
- Location: Bangalore
Configuration of DSN on Linux for DS
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
Code: Select all
<your_dsn_name>
DBMSTYPE = ODBC
in uvodbc.config placed in projects/your_project folder.
regards
LUK
-
- Premium Member
- Posts: 41
- Joined: Fri Jun 04, 2004 5:52 am
- Location: Bangalore
How to configure DSN in unix
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.
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.
Hi,
While Importing the meta data fro the newly created DSN.I am facing the error
The Content of uvodbc.config is
I am unable to determine where i went wrong. All suggestions are welcome.
Thanks,
Anuj
While Importing the meta data fro the newly created DSN.I am facing the error
The Content of .odbc.ini isDSR.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
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
Code: Select all
<Oracle Wire Protocol>
DBMSTYPE = ODBC
Thanks,
Anuj
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
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
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
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