IBM Power Ideas Portal
Hide about this portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Delivered
Workspace IBM i
Categories Open Source and PASE
Created by Guest
Created on Dec 15, 2020

RELATED IDEAS

PHP ODBC connections to MSSQL require FreeTDS

See this idea on ideas.ibm.com

Our websites hosted on the IBMi require PHP connections to MSSQL database servers. This was possible with the Zend Server Free edition (expiring June 2021) with a PHP PDO driver plugin "dblib". With our migration to the RPM based PHP, there is currently no support for PHP PDO drivers with MSSQL connections. This requires users to build FreeTDS themselves, which I am not experienced with.

A similar issue identified with Python is below:
https://bitbucket.org/ibmi/opensource/issues/109/ibm-pyodbc-connection-to-mssql


Use Case:

Using the latest RPM-based PHP version currently available from Zend repo (7.3.14), with the unixODBC driver, and the latest ibm-iaccess odbc driver, there is no support for MSSQL connections.
I am also using Nginx as the web server, but same would apply to Apache, it is a limitation within PHP.


Idea priority Urgent
  • Guest
    Reply
    |     Apr 2, 2021

    PHP capability to communicate with MSSQL has been delivered by the partners at Seiden Group. For information about PHP distributions on IBM i, see http://ibm.biz/ibmi-php

  • Guest
    Reply
    |     Dec 23, 2020

    Thanks for your note Alan. I can confirm that the FreeTDS and PDO_DBLIB extension with CommunityPlus+ PHP from Seiden Group does resolve this issue, and connections to MSSQL are now working correctly! Huge Thanks!!

  • Guest
    Reply
    |     Dec 18, 2020

    PDO_DBLIB (MSSQL with FreeTDS) and many other popular modules are included with CommunityPlus+ PHP (https://www.seidengroup.com/communityplus-php-for-ibm-i/).

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.