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




Sorry Paul but I cannot help you there.  We are using Microsoft Access to
access BPCS to pull data off the AS400 in order to create reports, but we
had to buy an ODBC driver.  We are using a driver from Hit Software.

Sorry I cannot be more of a help.

Joe Royer





"Paul Holstein" <holstein13@hotmail.com> on 12/28/98 08:25:36 PM

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)  
                                                              






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



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