RE: Using Client Access to get data from System 21 i nto Access

I use MS Access linked with System21 files all the time. In ODBC, how did
you configure your server? Are you converting your CCSID code.


Rick Shatto
rshatto@xxxxxxxxxxxxx
Work: (323) 264-5200 ext. 4065



-----Original Message-----
From: Kate Healy [mailto:Kate.Healy@xxxxxxxx]
Sent: Tuesday, September 09, 2003 7:55 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Using Client Access to get data from System 21 into
Access


Hi there,

Has anyone ever had problems using Client Access to get data out of an AS400
and into an access database?



Microsoft Access // ODBC Error.

We attempted to import data to a Microsoft Access database using an ODBC
connection via the AS/400 Client software. However, the following error was
encountered:

ODBC - Call Failed,

[IBM}[Client Access ODBC Driver (32 bit)][DB2/400 SQL]PWS006 - Value for
Parameter is not valid. (# -235)

A number of versions of the AS/400 client were used the most recent being
V3. Rel 1. Mod 3.

We tried Machine, System and File DSN as part of the ODBC configuration but
none were successful.

The error is encountered when attempting to Link or import a table (using MS
Access) from select Libraries on the AS 400. The tables from the selected
Library are listed as usual on screen but when the import or link button is
clicked the error is displayed.

Using the same driver with different Libraries works fine.

Any and all suggestions welcome.

Kate Healy
kate.healy@xxxxxxxx