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

In a message dated 12/25/98 11:33:31 AM Central Standard Time,
holstein13@hotmail.com writes:

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

I have heard from the PC Helpline at SSA that this is a problem several other
clients have experienced, and that 6.002 BPCS was not tested with the latest
ODBC drivers as they came out (the latest Client Access replaced your older
ODBC driver with a newer one, and that was not the ODBC driver used when 6.002
was being developed). You would think Microsoft would manage to make software
that was upwardly compatible, but it seems much more iffy than what IBM does
with OS/400 software. The SSA Helpline can send you the old driver to re-
install on your PC by e-mail. The older driver does appear to work OK with
everything from what I heard.

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