I am trying to connect to an AS/400 usign a program that our company has devoped.

The errors that i get suggest that there is something wrong with our ODBC connection, i have checked and double checked that the connection is setup correctly.

I ran a trace on the ODBC connection and this is what i am getting....

There is some cvode in here that wont make any sence , our company specifc library codes.

MvxViewGen 72c-754 ENTER SQLExecDirect
HSTMT 00C025A8
UCHAR * 0x01AA02A0 [ -3] "CALL QSYS/QCMDEXC('CALL PGM(MVXCENV/MNS007CL) PARM(*Z *Z 0 *Z *Z )',0000000047.00000)\ 0"
SDWORD -3

MvxViewGen 72c-754 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 00C025A8
UCHAR * 0x01AA02A0 [ -3] "CALL QSYS/QCMDEXC('CALL PGM(MVXCENV/MNS007CL) PARM(*Z *Z 0 *Z *Z )',0000000047.00000)\ 0"
SDWORD -3

DIAG [S1000] [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]CPF0006 - ERRORs occurred in command. (-443)

DIAG [01000] [IBM][Client Access Express ODBC Driver (32-bit)]Extended dynamic support disabled. (30129)

MvxViewGen 72c-754 ENTER SQLERRORW
HENV 00000000
HDBC 00000000
HSTMT 00C025A8
WCHAR * 0x0012F118 (NYI)
SDWORD * 0x0012F2B0
WCHAR * 0x0012ED18
SWORD 512
SWORD * 0x0012F2AC

MvxViewGen 72c-754 EXIT SQLERRORW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00000000
HSTMT 00C025A8
WCHAR * 0x0012F118 (NYI)
SDWORD * 0x0012F2B0 (-443)
WCHAR * 0x0012ED18 [ 99] "[IBM][Client Access Express ODBC Driver (32-bit)]"
SWORD 512
SWORD * 0x0012F2AC (99)


Any help would be great.

i am not an sql programmer and really need help on this matter as soon as possible


Thanks a million