Hi,
I am trying to import table definition using ODBC. I defined the entry in .odbc.ini and uvodbc.config . I put the uvodbc.config in the respective project directory. But I am getting the error as : ODBC Licence file ( IVVM.LIC or DDVM.LIC) not found in branded odbc directory while importing table definition.
I checked branded odbc directory. All thees files are there. Can anybody help to resolve this issue.
1. Entry in uvodbc.config
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<OFDM>
DBMSTYPE = ODBC
2. Entry in .odbc.ini
[OFDM]
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=ofsd
Password=ofsd
PortNumber=1521
ProcedureRetResults=0
SID=OFDM
UseCurrentSchema=1
Regards,
Param
Error - Licence file not found
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Hi,ds_developer wrote:Sounds like a permissions problem to me. What are the permissions on the IVVM.LIC and DDVM.LIC files and the directory they are in? Can the user you log into Manager with get to these files in a telnet session?
John
permission to these file is "-rwxr-xr-x". I thnk this permission is fine. Is there anything i have to configure. In dsenv file also i have includedbranded_odbc lib path.
Thanks,
Parameswar