Re: BPCS 6.0.2 Mixed mode and Client Access (ODBC)

[JLR@xxxxxxxx]

Paul,

You may want to try loading client access and the netsoft drivers first
then load the new version of the ODBC drivers from Microsoft.  I have ran
into similiar problems when I load software out of sequence.  There is
really no set sequence, but I have found that Client Access does not work
well with the ODBC drivers from Microsoft.  IBM, the last time I checked
with them, supported version 2.7 ODBC drivers from Microsoft.  I got it to
work by installing Client Access first and installing the netsoft drivers,
then install the lastest version of the ODBC drivers.  We are currently on
V3R1M3 of client access and version 4.1 of the OS/400.

Hopefully the same principals apply in version 3.2M0 of client access.

Let me know what you find out.

Joe Royer




"Paul Holstein" <holstein13@hotmail.com> on 12/25/98 11:43:40 AM

Please respond to BPCS-L@midrange.com
                                                              
                                                              
                                                              
 To:      BPCS-L@midrange.com                                 
                                                              
 cc:      (bcc: Joey L Royer/Atlanta/Packaging/Mead)          
                                                              
                                                              
                                                              
 Subject: Re: BPCS 6.0.2 Mixed mode and Client Access (ODBC)  
                                                              






Tom,

I've had terrible problems with AS/400 OS V4R2 and the ODBC drivers from
both Client Access and Netsoft.

I called Netsoft and they said they never tested the drivers with V4R2.
My problem is only with certain BPCS files.  When using MS Access, I am
getting ODBC call failed messages quite often and I have to restart
Access.  On some files, I am unable to update certain fields.  For
example, I can't update APCINA on the APH file.  Has anyone had similar
problems?  If so, do you have any solutions?

--Paul


>From: "Tom McKeel " <tmckeel@worldnet.att.net>
>Reply-To: BPCS-L@midrange.com
>X-List-Name: BPCS Users Mailing List (BPCS-L@midrange.com)
>
>We have just upgraded our AS/400 OS to V4R2 and our Client Access was
>upgraded to V3R2M0 at the
>same time.  We have not had any problems with the Client Access except
that
>the BPCS Session Manager will
>issue an ODBC error message (when launching Order Entry) after entering
a
>userid and password.
>
>The error has to do with an ODBC incompatability.  Anyone else run into
this
>one?  BTW.  The CEA financials continue to work fine.
>
>
>
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---