Hello Herny, one of my clients was able to access DB2/VSE from MS/Excel after installing the appropriate "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" fix. (BTW, it never made to be an APAR).
Have you instlled the "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" fix in your DB2/VM system? If not, I would suggest you call IBM DB2/VSE&VM services to order:
1) any missing APAR/PTFs for your DB2/VM V7.20 system.
2) request to have a "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" FIXTEST.
3) install the above and try again.
I know you will not get too much support from IBM because DB2/VM V7.20 is out of services. However, you still can get all existing APAR/PTF/FIXes, etc. for DB2/VSE 7.20.
Good luck.
...Roland
Henry Wilusz <[EMAIL PROTECTED]> wrote:
Hello
Just a short question to see if anyone has gotten JDBC drivers on a
windows machine to successfully access DB2/VM. We know that the drivers
work with DB2/universal. but fail miserably with DB2/VM. DB2/VM is at
version 7.2
The attempt to access DB2/VM returns a authorization failure message to
the windows machine (incorrect message there) and a data capture dump on
DB2/VM.
The reason for exploring the JDBC angle is that ODBC connections to
this database sometimes hang with no error messages, and we cannot seem
to reproduce the hang conditions.
An interesting part of the DB2 dump is below. Note that the probable
cause section does not tell what the unsupported value was that it is
trying to deal with.
SYMPTOM STRING: MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11
PROBABLE CAUSE OF FAILURE:
DDM VALUE NOT SUPPORTED
If anyone has gotten cold fusion or JDBC to work to DB2/VM, and is
willing to share the secrets, I would like to hear from them
thanks
Henry Wilusz
[EMAIL PROTECTED]
Failure is not an option . . . . .
. . . . . It comes standard with windows
With best regards,
...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268)
197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6
** Life is short. Stop once in a while and smell the roses. **
