RE: Offline price load

[LDegnon@xxxxxxxxx]

I had to patch my workstation to SI15176 of Iseries Access for windows. 
There was an issue with ODBC and now it works perfectly.  The new default 
setting for ODBC in server tab/advanced is "Commit  Mode"/Read uncommitted 
*chg.  MAPICS Offline requires "Commit Mode"/Commit Immed *none.  The bug 
was when you change this in the settings, it does not change it under the 
covers.

Thanks to everyone for the response,

Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx 
www.AmPro.com 



Teresa Biby <TBiby@xxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
09/23/2004 06:02 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
"'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
cc

Subject
RE: Offline price load







I tried this with the new 400 OS V5R3 and latest 5788 of Mapics and did 
not
have any trouble.  I linked the MBLKCPP and our own built price book file
and it worked.  I haven't had any ODBC issues since upgrading the OS.  Did
you upgrade the client access express version to 5.3 also?  I don't think
that is necessary but it may be worth a try. 

-----Original Message-----
From: LDegnon@xxxxxxxxx [mailto:LDegnon@xxxxxxxxx] 
Sent: Tuesday, September 21, 2004 12:00 PM
To: Mapics-l@xxxxxxxxxxxx
Subject: Offline price load

Does anyone out there have a stable method for populating the MAPICS 
off-line price files?  I used to use ODBC with Microsoft access to cut and 

paste-append the contents of an Excel spreadsheet into the off-line file. 
Now that I am on our new AS/400 with new O/S and Level 5788 of MAPICS, it 
no longer works.  In fact, I cannot even use ODBC to manually enter or 
modify a record...

Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx 
www.AmPro.com 
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.