RE: Mac and IBM i + ODBC (was: Fonts in ACS)

I don't have a Mac, but I'd start with the IBM provided ODBC driver package for Mac https://www.ibm.com/support/pages/odbc-driver-ibm-i-access-client-solutions

LG

Markus

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Patrik Schindler
Sent: Freitag, 13. Mai 2022 09:44
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Mac and IBM i + ODBC (was: Fonts in ACS)

Hello Jack,

Am 11.05.2022 um 18:33 schrieb Jack Woehr via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

Mac is a pretty decent platform for interaction with IBM i.

Indeed!

Another hobbyist friend lately asked me if it might be possible to tie FileMaker via ODBC to the IBM i (and older machinery and OS releases). FileMaker saw extensive use in the 1990's and later, but was pushed back to a niche solution when everything was expected to run in a browser window.

https://urldefense.com/v3/__https://en.wikipedia.org/wiki/FileMaker__;!!CqVFughQ-RE!n6jW8ecYbxx2cOgRuZqoCoprN-YB-x2sBWEYLcVLF9ka6gXP6MEGTD1dxW-3yIOciuGuT1PDfhxd9t0S$

ODBC is largely absent in modern macOS releases. There is an applications which can be installed to get a data source point'n click interface, but in the end, I ran out of time before I to got it to run. My friend needed to move on. The main problem was that FileMaker gave errors about not finding the shlibs.

I guess UnixODBC might be a free and good solution. It works well on Linux with the latest IBM i ODBC libraries installed in /opt/ibm/iSeriesAccess/lib64/.

There is a also a vendor, Actualtech, who once had a "connector" for the Mac to IBM i. Asking them, they state that connections to IBM i do no longer work because of changes Apple introduced with MacOS Catalina (10.15).

Has anyone successfully used FileMaker as a graphical front end to IBM i databases on recent macOS releases? Probably on M1 based Macs?

:wq! PoC

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!CqVFughQ-RE!n6jW8ecYbxx2cOgRuZqoCoprN-YB-x2sBWEYLcVLF9ka6gXP6MEGTD1dxW-3yIOciuGuT1PDftWJAJwx$
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!CqVFughQ-RE!n6jW8ecYbxx2cOgRuZqoCoprN-YB-x2sBWEYLcVLF9ka6gXP6MEGTD1dxW-3yIOciuGuT1PDfu77eMpe$ .

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.com/v3/__https://amazon.midrange.com__;!!CqVFughQ-RE!n6jW8ecYbxx2cOgRuZqoCoprN-YB-x2sBWEYLcVLF9ka6gXP6MEGTD1dxW-3yIOciuGuT1PDfkv1atHl$