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

The files do not have an unusually large number of fields.  In fact, the 
driver worked fine on the old AS400 OS and the same database.  Also, I 
am running the latest versions I could find of both Netsoft router and 
Client Access.

--Paul

>In-Reply-To: <19981225164341.13277.qmail@hotmail.com>
>Sender: owner-bpcs-l@midrange.com
>Precedence: bulk
>Reply-To: BPCS-L@midrange.com
>X-List-Name: BPCS Users Mailing List (BPCS-L@midrange.com)
>
>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
>+---


______________________________________________________
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
+---