# Add ODBC Driver for IBMi (AS400)

**URL:** <https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182>\
**Category:** Connecting to SQL\
**Created:** [June 11, 2015, 5:57pm UTC](https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182 "2015-06-11T17:57:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andres\_Colodrero](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Andres\_Colodrero](https://community.dreamfactory.com/u/Andres_Colodrero)\
**Post date:** [June 11, 2015, 5:57pm UTC](https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182/1 "2015-06-11T17:57:33Z")

</div>

HI,  
im testing dreamfactory and i want to build an small API on top of IBMi (AS400).

could you add this driver or at least explain me if i can do it?

> **[cooperl/laravel-ibmi](https://packalyst.com/packages/package/cooperl/laravel-ibmi)**
>
> laravel-ibmi is a simple DB2 & Toolkit for IBMi service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework. Plus it also provides Toolkit for IBMi so that you can access IBMi...

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 16, 2015, 6:32pm UTC](https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182/2 "2015-06-16T18:32:30Z")

</div>

What are you connecting to on the IBM i server? A database such as DB2?

The link you provided appears to be a package for Laravel. Since DreamFactory 1.x is based on Yii and not Laravel, I’m not sure I can explain to you how to adapt it.

---

<div class="post-metadata">

**Author:** ![Andres\_Colodrero](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Andres\_Colodrero](https://community.dreamfactory.com/u/Andres_Colodrero)\
**Post date:** [June 16, 2015, 7:50pm UTC](https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182/3 "2015-06-16T19:50:20Z")

</div>

Hi,

I can see that it is possible to use php\_pdo\_ibm.dlll.

i check the documentation, but this driver doesnt work on PHP 5.5.25  
[https://pecl.php.net/package/PDO\_IBM/1.3.3/windows](https://pecl.php.net/package/PDO_IBM/1.3.3/windows).

i didnt find any other PDO for 64Bits windows and php 5.5.

This is the reason the service were not connecting to the AS400 Db2,

I I guess i will need to downgrade php to 5.4 to make it work, but i guess this will affect to DF.

---

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [June 16, 2015, 8:21pm UTC](https://community.dreamfactory.com/t/add-odbc-driver-for-ibmi-as400/1182/4 "2015-06-16T20:21:28Z")

</div>

So it is DB2? I recommend [our blog post on connecting to a DB2 database](https://blog.dreamfactory.com/rest-api-for-db2). [Bitnami provides the PDO\_IBM module already compiled](https://wiki.bitnami.com/components/php#How_to_install_PDO_IBM_module.3f) in [PHP 5.5.25](https://bitnami.com/stack/dreamfactory/changelog.txt), so it would appear that it is indeed possible in your current version of PHP. If you do need to downgrade PHP, [DreamFactory is fine on 5.4.0 and above](https://github.com/dreamfactorysoftware/dsp-core/wiki/Additional-Drivers#php).