DSXchange

Hi All,

IIS 11.5.2 is installed on Windows 2012 server, ODBC data source were setup on both User DSN and System DSN (with different names) and both connected successfully with SQL server driver.

after running Example command, only the data source from User DSN is able to fetch data; the data source from System DSN can't connect.

Tried to load data from Sql server with both Sql server Enterprise stage and MS OLEDB with the data source from User DSN, got the error as below:

##W IIS-DSEE-TOSH-00049 21:49:49(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set.
>##F IIS-DSEE-TDOD-00004 21:49:49(006) <main_program> Fatal Error: Could not connect to datasource?? (-1; username; datasource; [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified).

Another question is about how to import Sql server table definition into Datastage.

Do you know what is the issue here and how to fix?

Thank you very much for your time.

Best,

DataStage cannot use a user DSN; you'll need to use the system DSN. And you will need to make sure that the DSN used in the job design is correctly spelled and cased.

Ray, thanks, it's fixed.