To encrypt ODBC data, IBM recommends the industry-standard TLS encryption protocol (the successor to SSL).
The IBM i ODBC driver for Db2 has become easier to install.
Formerly available only as a download requiring several steps, the driver can now be installed and updated on IBM i with Yum or Access Client Solutions (ACS), as easily as with other IBM i open source packages.
Here are instructions for installing the ODBC driver using Yum.
As ODBC gains popularity for IBM i database access, developers of web applications and APIs need information on defining ODBC database connections. This article demonstrates tips and techniques for effectively using ODBC connection strings in all programming environments, including popular languages such as PHP, Python, and Node.js.
For an example of how connection strings are used in a program, see How to Query IBM i Data with PHP and PDO_ODBC.
Although the classic extensions (ibm_db2, PDO_IBM) and older ODBC continue to work, we prefer PDO_ODBC for several reasons:
We’ve been hearing from clients wondering whether they need commercial connectors to integrate open source technology with Db2, RPG, and COBOL data.
Liam Allan has shown the power of using open source tools that are available to everyone. He recommends accessing IBM i business logic and data using open source tools, without proprietary connectors.
I recently caught up with Seiden Group CTO Stephanie Rabbani about the ODBC driver that’s quickly becoming standard for open source and web connections on Db2 for i.
“Do we upgrade to a paid Zend Server license,
or do we migrate to RPM-based PHP?”
At a recent MAGiC User Group webinar, Alan Seiden and Richard Schoen teamed up to present a tutorial and demo on how to get started with Community “RPM” PHP, sharing several tips picked up during client migrations.
Last week, Perforce announced plans to withdraw Zend Server for IBM i “Basic” by June 2021. Filling the gap is license-free “community” PHP for IBM i, installable in RPM format.
Since last month’s post about free and open PHP on IBM i, we have been helping companies to get started with it.
We’ve seen excellent results with the open PHP package, known as an RPM. Starting with the PHP repository provided by IBM and Zend (Perforce) as a base, we are able to optimize PHP for the needs of each IBM i shop.
Especially appealing to us and our clients: this PHP is 64-bit and leans toward open standards, including ODBC. In exchange for a bit of setup time, you’ll have a system that’s lightweight, flexible, and license-free.