Issue while trying to use ODBC stage...
Posted: Mon Aug 20, 2007 7:02 am
Hi,
We have DS installed on Unix(Solaris).I created a dsn (non-wired
protocol) for oracle in DataStage Server 7.5.1a. I have done the
configuration settings in .odbc.ini and uvodbc.config. Also made
the changes required in the uvodbc.config
Projects/<projectname>. I tested the connections and was able
query the database correctly from the DS prompt.
But when i use an odbc stage, I am not getting the dsn in the
dropdown list. Also when I use the ODBC TABLE DEFINITIONS for
import, I am able to see the DSN there but not able to connect
with correct usernames and passwords. Please help me in
resolving this.
We have DS installed on Unix(Solaris).I created a dsn (non-wired
protocol) for oracle in DataStage Server 7.5.1a. I have done the
configuration settings in .odbc.ini and uvodbc.config. Also made
the changes required in the uvodbc.config
Projects/<projectname>. I tested the connections and was able
query the database correctly from the DS prompt.
But when i use an odbc stage, I am not getting the dsn in the
dropdown list. Also when I use the ODBC TABLE DEFINITIONS for
import, I am able to see the DSN there but not able to connect
with correct usernames and passwords. Please help me in
resolving this.