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

["Paul Holstein" <holstein13@xxxxxxxxxxx>]

Thanks for your comments Joe,

Can MS Access use the ODBC drivers from Microsoft to access the AS400?  
I have heard that this is possible but I have never seen it done.  I 
have always connected with either Netsoft router ODBC driver or Client 
Access ODBC driver (I prefer client access because of the lack of an RDB 
entry).

If anyone has ever connected to the AS400 using only Microsoft's ODBC 
drivers, I would love to hear from you.  Also, maybe someone could shed 
some light on the relationship of these drivers to each other.  My 
impression is that each one is mutually exclusive and that you don't 
need both client access and MS ODBC drivers.

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


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