Could not import metadata through ODBC

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Could not import metadata through ODBC

Post by bala_135 »

Hi,

We could import the metadata through Plugin as well as through Orchestrate schema definitions but not through ODBC. .

My odbc.ini file for one Oracle user(user1) looks like this
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=1
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/odbctrac.sl
TraceFile=/home/dsadm/Ascential/DataStage/branded_odbc/odbctrace.out
UseCursorLib=0

[TEST]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.sl
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=UXJEDB05
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=user1
Password=user1
PortNumber=1521
ProcedureRetResults=0
SID=test1
UseCurrentSchema=1

The corresponding uvodbc.config file entry is as follows

#
[ODBC DATA SOURCES]

<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1

<TEST>
DBMSTYPE = ODBC.

When i try to import the metadata through the ODBC I am able to get the ODBC.ini in the DSN name but when i enter the username and password for the corresponding DSN it returns me the following Error

ERROR - ODBC License file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory .

According to the error messgae i went into the branded_odbc directory and saw the file I could find the IVVM.LIC file in it.

Anything i am missing.Kindly provide me some inputs to proceed further.

Regards,
Bala.
Post Reply