As400 ODBC Problem

anilkona · Post by **anilkona** » Tue Jul 12, 2005 4:29 pm

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

ml · Post by ml » Tue Jul 12, 2005 6:20 pm

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

anilkona · Post by **anilkona** » Wed Jul 13, 2005 10:48 am

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

ml · Post by ml » Wed Jul 13, 2005 11:19 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 14, 2005 5:15 am

WRKRDBDIRE. How do you pronounce that?

ml · Post by ml » Thu Jul 14, 2005 8:56 am

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

anilkona · Post by **anilkona** » Thu Jul 14, 2005 9:55 am

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.

ml · Post by ml » Thu Jul 14, 2005 12:57 pm

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

Best Regards.

pjsimon · Post by **pjsimon** » Mon Dec 19, 2005 9:17 am

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

ml · Post by ml » Mon Dec 19, 2005 9:26 am

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

Something like $./bind20 PRISMDB2CONNECT

good luck!

pjsimon · Post by **pjsimon** » Mon Dec 19, 2005 9:38 am

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.

ml · Post by ml » Mon Dec 19, 2005 9:41 am

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

pjsimon · Post by **pjsimon** » Mon Dec 19, 2005 9:49 am

Mat,

Now i get...

Package Creation Failed!:7676

Do u know what this error code means???

PJSimon.

ml · Post by ml » Mon Dec 19, 2005 9:52 am

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.

pjsimon · Post by **pjsimon** » Mon Dec 19, 2005 9:55 am

Mat,
i looked it up....

7676 : user/password invalid.....

Thanks very much

PJSimon