MS Access can communicate with pretty much any database that has an ODBC driver. Which is pretty much every database on the planet.
There is previous postings about JDBC drivers, that's for the Java world, not the Microsoft world. In the Microsoft world you have your choice of OLEDB, ODBC, or the .NET Drivers to interface with the IBMi. Access has built in interfacing with ODBC only. If you want to use OLEDB you have to write code to do that (no more point and click linking of tables).
Be sure you have the ODBC driver installed (Part of the Client Access for Windows package or previously in the iSeries Access Client install) before you go through the ODBC wizard.
Additionally setup a Machine or User data source to the IBMi with all the proper settings (IBM gives you a lot of settings to set).
-----Original Message-----
From: George Applegate <gappleg8@xxxxxxxxx>
Sent: Monday, March 12, 2018 2:55 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: MS Access Database
Thanks, I learned my something new today! Seriously!
George
(712) 579-5444 (cell)
985 Oak Rd
Harlan, IA 51537
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Monday, March 12, 2018 2:54 PM
To: Midrange Systems Technical Discussion
Subject: RE: MS Access Database
Correct, MS Access can do ODBC to Db2 and create a linked table. The linked table gives a live representation of the Db2 table.
In SQL Server, the "#" is OK if you enclose the column name in square brackets (e.g. [CUSTOMER#]). I can't say about MS Access.
-----Original Message-----
From: George Applegate [mailto:gappleg8@xxxxxxxxx]
Sent: Monday, March 12, 2018 2:44 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>
Subject: RE: MS Access Database
I think it is possible. I have an access program that uses idata. You define the data field in the access database as a "linked odbc" table. At least that's how I did it and it works. I can get you more information if you need it... Define the table(s) as Linked odbc...I hope this makes sense. I was only linking my customer master. I did end up redefining my customer master because if I recall, I couldn't have any fields in it with # signs or something like that. Stupid and weird...but I made it a linked odbc table
George
(712) 579-5444 (cell)
985 Oak Rd
Harlan, IA 51537
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
