Page 1 of 1

Connecting to AS400 system

Posted: Fri Jul 09, 2010 3:13 am
by SrSoma
Hi,
here we are facing issue in establishing the connection to AS400 system.
The steps we followed are :
1) Changed odbc.ini file and uvconfig.org file. below are the contents.

<<.odbc.ini file>>
[WELCOMETST]
Driver=/usr/iis/ascential/datastage/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
CharsetFor65535=0273
Collection=shareteam
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IANAAppCodePage=106
IpAddress=40.100.400.500
IsolationLevel=CURSOR_STABILITY
Location=TTXXCCA123
LogonID=WELCOMEDS
Password=*******
Option=512
Package=NULLID
PackageOwner=
ServerCharset=37
TcpPort=446
WithHold=1

<<uvodbc.config file>>
<WELCOMETST>
DBMSTYPE = ODBC

After using this it's gave us error

However we are still facing the error as below:

SQLSTATE=08S01,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Connection refused. Verify Host Name and Port Number.

We were suggested to execute <<bind>> command.

Here could someone help us in detailing the steps required for establishing the connectivity, and what is that we are missing.

Appreciate your prompt response.

Thanks.

Posted: Fri Jul 09, 2010 6:24 am
by chulett
One example of how to bind is here.