×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Many people interpret the OP as wanting to run this on IBMi, so that wouldn't be "the Microsoft world ".
-----Original Message-----
From: Matt Olson [mailto:Matt.Olson@xxxxxxxx]
Sent: Monday, March 12, 2018 5:12 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: MS Access Database
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).
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
