ODBC import problem

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

I'm working on a project that involves connecting an NT based tool to the
400.  It needs an ODBC connection.  The guy from the vendor has never seen a
400 and I'm not well versed in ODBC.  (We complement each other perfectly.)

I've played with ODBC a little and have had good luck importing small files
into Excel, Brio, and Crystal Reports.  When we try to set up the ODBC
connection between the NT app and the 400  it dies.    The message returned
to the NT app is the CPF5129, although it looks like that was really in
response to the MCH3601 a bit higher up.

We're on v4r3.  I'm not sure of the PTF level.  I'm willing to entertain any
theory including cosmic rays and planetary conjunction.  

Here's an extract from the job log from the QZDASONINT that dies:

CPIAD02    Information             00    05/17/00   19:20:24   QZBSSECR
QSYS        *STMT    QZBSSECR     QSYS         *STMT 
                                     From module . . . . . . . . :
QZBSSECR                                                      
                                     From procedure  . . . . . . :
QzbsProcessStartServerReq                                     
                                     Statement . . . . . . . . . :   311

                                     To module . . . . . . . . . :
QZBSSECR                                                      
                                     To procedure  . . . . . . . :
QzbsProcessStartServerReq                                     
                                     Statement . . . . . . . . . :   311

                                     Message . . . . :   Servicing user
profile EMA.                                               
MCH3601    Escape                  40    05/17/00   19:20:49   QDBGETM
QSYS        0703     QDBGETM      QSYS         0703  
                                     Message . . . . :   Pointer not set for
location referenced.                                  
CPF9999    Escape                  40    05/17/00   19:20:49   QMHUNMSG
*N       QDBGETM      QSYS         0703  
                                     Message . . . . :   Function check.
MCH3601 unmonitored by QDBGETM at                         
                                       statement *N, instruction X'0703'.

CPF5257    Escape                  70    05/17/00   19:20:49   QDBSIGEX
QSYS        0312     QZDAROI      QIWS         243B  
                                     Message . . . . :   Failure for device
or member QAZDCOLM file QAZDCOLM in                    
                                       library QIWS.

CPF5129    Escape                  50    05/17/00   19:20:50   QDMIFERR
QSYS        01B1     QZDAROI      QIWS         33C6  
                                     Message . . . . :   I/O is not allowed
because the program device or member                   
                                       QAZDCOLM file QAZDCOLM in library
QIWS is in error.                                         
 CPF9999    Escape                  40    05/17/00   19:20:50   QMHUNMSG
*N       QZDAROI      QIWS         33C6  
                                      Message . . . . :   Function check.
CPF5129 unmonitored by QZDAROI at                         
                                        statement *N, instruction X'33C6'.

 

TIA
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---