As400 ODBC Problem
Moderators: chulett, rschirm, roy
As400 ODBC Problem
We are trying to make a connection to DB2 on AS400 server.
We made an entry in .odbc.ini file and during bind we are receiving this error message:
Package creation failed!: 7505
Any ideas on what 7505 means?
Here are the entries from the ini file:
[SISCO-AS400]
Driver=/ascential/psepm8/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=AS/400
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=XX.XX.x.XX
IsolationLevel=CURSOR_STABILITY
Location=AS/400
LogonID=
Password=
Package=QGPL
PackageOwner=
TcpPort=
WithHold=1
We made an entry in .odbc.ini file and during bind we are receiving this error message:
Package creation failed!: 7505
Any ideas on what 7505 means?
Here are the entries from the ini file:
[SISCO-AS400]
Driver=/ascential/psepm8/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=AS/400
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=XX.XX.x.XX
IsolationLevel=CURSOR_STABILITY
Location=AS/400
LogonID=
Password=
Package=QGPL
PackageOwner=
TcpPort=
WithHold=1
7505 mean that you have a wrong IP or Port number.
To be sure about the port number, you should connect to the AS400 and see the port number for the DRDA listener. DRDA is the communicating protocol for communicatingwith DB2. To determine the correct port number, execute 'NETSTAT' from an AS/400 command line. Chose option 3 to display a list of active ports on the AS/400. Find the entry for DRDA and press F-14 to toggle the display the port number.
good luck
To be sure about the port number, you should connect to the AS400 and see the port number for the DRDA listener. DRDA is the communicating protocol for communicatingwith DB2. To determine the correct port number, execute 'NETSTAT' from an AS/400 command line. Chose option 3 to display a list of active ports on the AS/400. Find the entry for DRDA and press F-14 to toggle the display the port number.
good luck
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My odbc.ini file looks like this.......
[PRISMDB2CONNECT]
Driver=/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=AS/400
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xx.xx
IsolationLevel=CURSOR_STABILITY
Location=AS/400
LogonID=c408260
Password=xxxxxx
Package=ASHCHMPM
PackageOwner=
TcpPort=446
WithHold=1
uvodbc.config
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<PRISMDB2CONNECT>
DBMSTYPE = ODBC
When I do a bind i get the following error.......Does anyone know what it means or am i missing something????....
$ bind20 <PRISMDB2CONNECT>
ksh: 0403-057 Syntax error: `newline or ;' is not expected.
Thanks
PJSimon
[PRISMDB2CONNECT]
Driver=/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=AS/400
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xx.xx
IsolationLevel=CURSOR_STABILITY
Location=AS/400
LogonID=c408260
Password=xxxxxx
Package=ASHCHMPM
PackageOwner=
TcpPort=446
WithHold=1
uvodbc.config
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<PRISMDB2CONNECT>
DBMSTYPE = ODBC
When I do a bind i get the following error.......Does anyone know what it means or am i missing something????....
$ bind20 <PRISMDB2CONNECT>
ksh: 0403-057 Syntax error: `newline or ;' is not expected.
Thanks
PJSimon
mat,
This what i get......
$ ./bind20 PRISMDB2CONNECT
exec(): 0509-036 Cannot load program ./bind20 because of the following errors:
0509-150 Dependent module libVMicu20.a(VMicu20.so) could not be loaded.
0509-022 Cannot load module libVMicu20.a(VMicu20.so).
0509-026 System error: A file or directory in the path name does not exist.
thanks for ur help
PJSimon.
This what i get......
$ ./bind20 PRISMDB2CONNECT
exec(): 0509-036 Cannot load program ./bind20 because of the following errors:
0509-150 Dependent module libVMicu20.a(VMicu20.so) could not be loaded.
0509-022 Cannot load module libVMicu20.a(VMicu20.so).
0509-026 System error: A file or directory in the path name does not exist.
thanks for ur help
PJSimon.