Seiden Group
Modern Development & Open Source for IBM i
  • Link to LinkedIn
  • Link to Mail
  • Home
  • Seiden PHP+
    • Seiden PHP+
    • Install & Learn
    • SmartSupport
    • PHP Migrations & Upgrades
    • Success Stories
    • Free PHP Assessment
    • Documentation
    • What’s New (Changelog)
  • IBM i Services
    • Development
    • Training & Mentoring
    • Open Source Setup & Upgrades
    • SSL/TLS Install & Learn
    • Performance
  • Support
    • Open Source & PHP
    • VS Code for i
    • Developer Support
    • Support Success Stories
  • VS Code for i
    • Support
    • Training
    • Code for i Resource Guide
    • Getting Started Videos
    • Code for IBM i Fridays
  • Free Stuff
    • IBM i Strategy & Tips
    • PHP Upgrade Assessment
    • CNX Valence Assessment
    • VS Code for IBM i Resources
    • Code for IBM i Fridays
    • QCachegrind Download
    • PHP Toolkit for IBM i Resources
    • Qshell on i Library
  • Blog
  • About
    • About Our Team
    • About Alan Seiden
    • Speakers & Sessions
    • In the News
  • Contact
  • 201.447.2437
  • Search
  • Menu Menu

Seiden Group Blog

Q&A: IBM i ODBC Driver

August 28, 2020/4 Comments/in ODBC, Open Source, PHP /by Alan Seiden

Stephanie Rabbini

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.

Steph, looks like ODBC is back! Where has it been for the past 20 years?

I guess it was hibernating! With the ODBC standard, IBM Rochester no longer needs to create and maintain unique adapters for all the new languages coming to the platform. Most languages can already use ODBC. What’s more, IBM already maintained ODBC drivers for Windows and Linux, so why not the IBM i itself? And now Apple Mac computers. Plus, ODBC works really well.

How are you using ODBC with PHP these days?

ODBC is the default driver for Seiden PHP+. Because Zend Server Basic is being discontinued next year, we’re helping lots of clients migrate!

We also maintain and support high quality 64-bit builds of ibm_db2 and PDO_IBM for clients who use the db2_connect() style and PDO_IBM.

Which PHP extensions do you use for ODBC? 

PHP provides a choice of two ODBC extensions: ‘odbc’ and ‘PDO_ODBC.’ We usually prefer PDO_ODBC. Not only is PDO_ODBC compatible with other PDO database extensions, but it does more than the old ‘odbc’ extension. For example, PDO_ODBC can read output parameters from Db2 for i stored procedures.

Any other languages?

I love Python (let us know if you need Python code developed or need training!) and use pyodbc. We have also been developing APIs with Node.js and node-odbc. Oh, and let me know if you’d like to see how I produced beautiful graphs based on IBM i data with the R language and RODBC.

What do other developers say about ODBC being available on IBM i?

They love being able to run the same code from their PCs and on IBM i, connecting to Db2 for i from both. They can use their “local” development tools while programming, then deploy to the i.

How do you install the ODBC driver?

It’s free for IBM i customers. The package has two parts: the unixODBC driver manager and a specific Db2 for i driver. You’ll need your IBM user ID to log in to the Access Client Solutions site and download the package. Official installation instructions:

https://ibmi-oss-docs.readthedocs.io/en/latest/odbc/installation.html

How easy is ODBC to configure?

As a programmer who likes to dive right in, I love simple INI files where I can try all the options. And INI files (odbc.ini and odbcinst.ini, both in /qopensys/etc/) are what unixODBC gives us. There are a ton of options, and best of all, they are well documented.

We often refer to the list of IBM i ODBC Driver Connection String Keywords .

For general unixODBC documentation: http://www.unixodbc.org/odbcinst.html

What about performance?

My testing with Neoload shows better performance with less CPU than the older proprietary drivers! For best speed, I recommend either connection pooling, or persistent connections if your language supports it.

Thanks, Steph! Any other words of wisdom?

I love to help people get started with ODBC and open source on IBM i. Why not save yourself some time? Contact me if you’d like me to walk you though the installation on your system and make sure it all works perfectly!

Tags: AS/400, DB2, i5, IBMi, odbc, pdo_odbc, PHP, Python, System i
Share this entry
  • Share on Facebook
  • Share on X
  • Share on Pinterest
  • Share on LinkedIn
  • Share on Tumblr
  • Share on Reddit
  • Share by Mail
https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png 0 0 Alan Seiden https://www.seidengroup.com/wp-content/uploads/2017/03/SeidenLogo-180.png Alan Seiden2020-08-28 09:59:232025-12-15 12:22:05Q&A: IBM i ODBC Driver
Alan Seiden

About Alan Seiden

Alan works to preserve your investment in IBM enterprise systems by designing and implementing modernization strategies that leverage your existing business logic.

With a passion ...Read More

4 replies
  1. Jon Paris
    Jon Paris says:
    September 23, 2020 at 11:10 am

    The “run the same code on your PC” part is the really attractive thing to me. It would be even more attractive if I could get it to work on my Mac. I have tried several times without success.

    Perhaps Steph could do a follow-up pice to explain how to get this to work?

    Reply
    • Alan Seiden
      Alan Seiden says:
      September 23, 2020 at 3:06 pm

      Hi, Jon, Thanks for your comment. I’ve followed up with you privately about using ODBC on Mac. We can post the result here after our discussion.

      Reply
  2. Dani Szwarc
    Dani Szwarc says:
    September 23, 2020 at 9:54 am

    Thank you for this quick interview.
    As someone who’s always trying to lean about IBM i and open source, this helps me understand the directions I should be taking!

    Reply
    • Alan Seiden
      Alan Seiden says:
      September 23, 2020 at 3:09 pm

      Hi, Dani, thank you for your kind words! I’m glad our interview about ODBC on IBM i is helping build to confidence in this direction.

      Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SUBSCRIBE
Open Thinking
Monthly IBM i Strategy & Tips
  • This field is for validation purposes and should be left unchanged.

IBM i Development

  • RPG, COBOL, SQL, Node,
    PHP, Python, Valance, etc.
  • Modernization. Integration.
  • Web and API Solutions
  • Legacy Maintenance
    ...
LET'S GET IT DONE!

Recent Posts

  • Mitigating the eMudhra Intermediate CA Compromise with IBM i
  • Critical php2shell Security Update Available in Seiden PHP+ Server
  • Moving to IBM i 7.6? An SDA Alternative with VS Code and IBM Bob
  • What’s New with Mapepire Database Connector for IBM i
  • Do You Need IBM i Observability?
  • PHP 8.6 is Coming Soon to IBM i
  • Safer npm installation is on the way for Node.js (and all JavaScript)
  • Protecting IBM i and Web Applications from Modern Threats
  • IBM i: A Natural Platform for Agentic AI
  • PHP on IBM i in 2026: The Modernization Engine

SEIDEN GROUP: Modern Development & Open Source for IBM i

Home   |   Seiden PHP+   |   IBM i Services  |   Support   |   VS Code for i   |   Free Stuff   |   Blog  |   Privacy Policy  |   Contact         201.447.2437

© 2026 Seiden Group, LLC
  • Link to LinkedIn
  • Link to Mail
Link to: 9 Smart Ways to Use IBM i Services Link to: 9 Smart Ways to Use IBM i Services 9 Smart Ways to Use IBM i Services Link to: Seiden Group, Chubu System Bring Business-Ready Open PHP to Japan Link to: Seiden Group, Chubu System Bring Business-Ready Open PHP to Japan Seiden Group, Chubu System Bring Business-Ready Open PHP to Japan
Scroll to top Scroll to top Scroll to top