Thanks for the reply!
As per your recodmendation i have change the .odbc.ini file and added new DSN connection .The details are :
[Text]
Driver=/opt/datastage801/dev/Server/branded_odbc/lib/VMtxt22.so
Description=DataDirect TextFile(*.*) Driver
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/scratch/DataDirect_5.2/odbc/demo
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS
Addition of new field:
[SERVER_NAME]
Driver=/opt/datastage801/dev/Server/branded_odbc/lib/
odbccurs.so
Description=DataDirect TextFile(*.*) Driver
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/scratch/DataDirect_5.2/odbc/demo
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS
I have change the
Driver name,but still it is not working...as ray suggested i have to add the DSN in odbc.ini but in the driver which driver i have to specifiy ...there are four ".so" files in the lib path .
Following are the names:
Code: Select all
odbctrac.so
odbccurs.so
libodbc.so
libodbcinst.so
Ca you please tell me what exactly i have to add in the odbc.ini file.
Thanks all for your support.I hope that we can resolve this issues
![Laughing :lol:](./images/smilies/icon_lol.gif)