DSXchange

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

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

After giving the correct port number, we are receiving this error now during bind:

Package creation failed!: 1242

Any ideas on what this error means?

Thanks,
-Anil

You need to set the correct Location Value, run the "WRKRDBDIRE" command on your as400 and use the one that is type *LOCAL.

You also need to set the correct Collection tables.

WRKRDBDIRE. How do you pronounce that?

To pronounce that just do a copy/paste
(and believe me that is not one of my abbreviations)


I know that the bind error 7505 means a connections problem, but anybody know what 7500 mean?

$./bind20 dsnname
Package creation failed!: 7500

7500 means "7500 "Unexpected Network Error. ErrNum = %d1"

The meaning to these error codes are in *.po files. These files are located under /branded_odbc/locale/en_US/LC_MESSAGES.

Thanks anil, the port number was locked (:twisted: unexpected ).

Best Regards.

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

You need to run Bind command without this: "<>".

Something like $./bind20 PRISMDB2CONNECT

good luck!

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.

You need to run . ./dsenv from DSEngine directory, before run bind.

Mat,

Now i get...

Package Creation Failed!:7676

Do u know what this error code means???


PJSimon.

I never saw this number, check the description here:

" in *.po files located under /branded_odbc/locale/en_US/LC_MESSAGES"

and let us know.

Mat,
i looked it up....

7676 : user/password invalid.....

Thanks very much

PJSimon