Connecting to AS400 system
Posted: Fri Jul 09, 2010 3:13 am
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.
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.