Hi David,
Assuming you're on Windows XP and have iSeries Access and MS Access
installed:
- start MS Access
- open a database or create a new one
- create a new table, selecting Link table
- in the File open window, select Files of type: ODBC Databases. This
will open a "Select Data Source" window.
- select an existing ODBC data source for your iSeries, or click on the
New button.
- if you clicked on the button for a new ODBC data source,
. select the Client Access ODBC driver or iSeries Access ODBC driver
(on my PC they're the same CWBODBC.dll dated 12/3/2004.).
. make up a name for the data source and tell it where to save it;
the default location is simplest.
. click Finish and you'll get to the data source options window.
- under the General tab, be sure to select your iSeries system.
- under the Server tab, select SQL naming convention, your
default library, etc. Also (as Steve Landess mentioned) click on the
Advanced button and set the Commit mode to "Commit immediate (*NONE)".
- under the Translation tab, check the "Convert binary data"
check box.
- click Ok.
. click Ok
You should now see a list of tables in the library you selected when
setting up the data source. Select one by clicking on it, then click
Ok. You'll get a list of fields in the table for you to identify the
unique key. After you click Ok on that, you have an Access table linked
to your iSeries table. You can now create SELECT, INSERT, UPDATE,
DELETE queries over that table.
Contrary to John Arnold's experiences, I had no problem today doing an
INSERT INTO from a local Access table to a linked table on a v4r4 system
and on a v5r4 system using iSeries Access v5r3m0 and MS Access 2000.
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
David FOXWELL wrote:
I would like to know how to do this. Could someone explain please ?
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de tim
Envoyé : mardi 6 mai 2008 22:49
À : 'Midrange Systems Technical Discussion'
Objet : best way to copy records from ms access to iseries
I am trying to copy a table from MS access to the iseries. The table defs are the same on both systems. I've tried "insert into" sql, but I get an error saying "ODBC insert on a linked table failed. Iseries ODBC driver not valid for operation.
midrange.com
