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

["David Shea" <dshea@xxxxxxxxxxxx>]

Do the failing files have an unusually large number of fields?  In the old
days of Rumba, files with over 202 fields would fail going through the ODBC
drivers.  Perhaps you have stumbled across a similar situation?

+++++++++++++++++++++++
Purge and Archive WITHOUT PROGRAMMING with ARCTOOLS.
http://www.arctools.com
+++++++++++++++++++++++

-----Original Message-----
From:   owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com] On Behalf
Of Paul Holstein
Sent:   Friday, December 25, 1998 11:44 AM
To:     BPCS-L@midrange.com
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
+---