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

["Paul Holstein" <holstein13@xxxxxxxxxxx>]

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