Page 1 of 1

How to create dsn

Posted: Tue Aug 28, 2007 5:16 am
by arun_kumar
Hi all,

How to create dsn on aixV5.3 from datastage.

I have tried with the following options. like

in
1]/Source [folder]/odbc/aix/tarfiles/odbc.ini

I had made changes.
2]
in /home/<username>/Ascential/DataStage/banded_odbc[folder]/odbc.ini

I had made changes.
3]
in /home/<username>/Ascential/DataStage/banded_odbc[folder]Ascential_tools/odbc.ini


But I am getting the error while working with datastage manager

% Empty DSN:list returned from the host[Host no]. %

I had tried with the above all posiblities,i konwn.Please educate me regarding this topic

Thanx in advance...

Posted: Tue Aug 28, 2007 7:45 am
by chulett
There are two places you need to do edits, none of them where you've tried yet. I'd suggest you undo whatever you did and then read this post:

viewtopic.php?t=112350

How to create DSN on AIX.

Posted: Thu Aug 30, 2007 7:17 am
by arun_kumar
Hi craig,

Thank you so much,I did it.I am facing this probelm from past 4 days.I searched a lot for solution.Your suggestion helped me a lot.

Bye,Have a great day.

Posted: Thu Aug 30, 2007 7:21 am
by chulett
Excellent! Now you just need to mark the post as 'Resolved'. :wink: