Do I need to reconfigure ?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
swades
Premium Member
Premium Member
Posts: 323
Joined: Mon Dec 04, 2006 11:52 pm

Do I need to reconfigure ?

Post by swades »

Hi,
I am accessing DB2 thru ODBC I am getting following error:

DIR_MK..DIR_DPK: DSD.BCIConnect connecting to DBNAME,
call to SQLConnect failed.
SQLSTATE=08S01,
DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]
Connection refused. Verify Host Name and Port Number.
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

Have you tried "Searching"? An exact search on "Connection refused. Verify Host Name and Port Number" yielded posts which actually got resolved.
Here's ONE to start with.

Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

One of the two things, either server address is incorrect or port number is incorrect. Verify them from your dba.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply