IIS 11.5 on Windows server failed to connect to SQL server

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cflin
Participant
Posts: 2
Joined: Thu Nov 02, 2017 11:30 pm

IIS 11.5 on Windows server failed to connect to SQL server

Post by cflin »

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,
Do your best!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
cflin
Participant
Posts: 2
Joined: Thu Nov 02, 2017 11:30 pm

Post by cflin »

Ray, thanks, it's fixed.
Do your best!
Post Reply