DSXchange

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 CacheS...

Thank you very much for all the help you have provided. I was just checking the .odbc.ini....but there are lot of things in that file..i am not sure what exactly i want to add in that file. In that i have seen some heading regarding the ODBC following are the contains in: [ODBC] IANAAppCodePage=4 In...

Thanks for the reply. Actully I have defined DSN in windows, as per steps mentioned in my first post . But by searching in forum I have found that the steps which I have followed are steps of DSN configuration in WIndows, not in UNIX. How to confiure same in UNIX (do I need to have a separatedriver ...

THanks for your reply!
I have not added DSN in the project folder..
Shall i add an entry in the uvodbc.config file as:
<SEVER_NAME>
DBMSTYPE = ODBC
By searching in this forum i have found that for unix OS import we require an external ODBC Driver??

Thanks in Advance!

Hi, We are trying to read EXCEL through use of ODBC: With reference to the post http://www.dsxchange.com/viewtopic.php?t=104985&highlight=Reading+from+excel We have found the post which states: ODBC Stage -Create a system DSN using Microsoft Excel Driver (*.xls) -Select a Workbook. -Import into ...