odbc connection

[sri75]

Hi


I added this entry in uvodbc.config

<EPMDV>
DBMSTYPE = ODBC

in .odbc.ini
added the following entry
our database is oracle

[EPMDV]
Driver=/apps/Ascential/DataStage/branded_odbc/lib/VMor820.so
Description=DataDirect 5.00 Oracle
ApplicationUsingThreads=1
LogonID= admin
OptimizeLongPerformance=0
Password=*******
ProcedureRetResults=0
ServerName=dev1.uits.uconn.edu
UseCurrentSchema=1

[EPMDV]
Driver=/apps/Ascential/DataStage/branded_odbc/lib/VMora20.so
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
HostName=dev1.uits.uconn.edu
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=admin
Password=********
PortNumber=1521
ProcedureRetResults=0
SID=EPMDV


when I tried to import table definitions

I got this message

DSR.MetaGeta(GET.TABLES)(SQLConnect('EPMDV','admin')): BCI Error:
SQLSTATE=08001,CODE=12514,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

can you please let me knwo what needs to be done.

but I checked tnsname.ora file.service name is same as in .odbc.ini file

Thanks

[sri75]

HI,

this problem got resolved.I gave host name instead of service name

Thanks