Can not see any ODBC Data Source names from ODBC stage
Posted: Mon Mar 24, 2008 1:52 pm
Hi All,
I am using ODBC stage to connect to source(DB2) in a parallel job and it is working absolutely fine. While developing the job, in the ODBC stage, we have to write the Data Source Name and there is button to click to see all the available data source names. This was working fine before I restart the Data stage server and WAS (because of adding a Native DB2 connection in dsenv). After the restart the job is running fine with ODBC. But in any ODBC stage, if I want to see all the available ODBC connection present in the UNIX server, I get an error message -
"An exception has occurred while trying to send the request to the handler. Failed to log on via the authenticatiob service".
But if I just type the Data Source Name, the job runs fine.
Anyone knows how to fix this?
Thanks
I am using ODBC stage to connect to source(DB2) in a parallel job and it is working absolutely fine. While developing the job, in the ODBC stage, we have to write the Data Source Name and there is button to click to see all the available data source names. This was working fine before I restart the Data stage server and WAS (because of adding a Native DB2 connection in dsenv). After the restart the job is running fine with ODBC. But in any ODBC stage, if I want to see all the available ODBC connection present in the UNIX server, I get an error message -
"An exception has occurred while trying to send the request to the handler. Failed to log on via the authenticatiob service".
But if I just type the Data Source Name, the job runs fine.
Anyone knows how to fix this?
Thanks