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
odbc connection
Moderators: chulett, rschirm, roy