Re: PHP 7 & connecting to MS SQLServer

Chris, PDO_dblib works for us - thanks so much for the info!

Kim


From: Kim Mitchell
Sent: Wednesday, May 10, 2017 8:02 AM
To: 'web400@xxxxxxxxxxxx' <web400@xxxxxxxxxxxx>
Subject: RE: PHP 7 & connecting to MS SQLServer

Thanks for the info, Chris! I could swear that I heard from Zend last year at COMMON that Zend Server 9.x couldn't be put on IBMi 7.1. That's great news!

I'll give this a shot on our development box. Thanks again for the reply.



* Subject: Re: PHP 7 & connecting to MS SQLServer
* From: "Hiebert, Chris" <chris.hiebert@xxxxxxxxxxxxxx<mailto:chris.hiebert@xxxxxxxxxxxxxx>>
* Date: Tue, 9 May 2017 20:05:28 +0000


________________________________
Just for reference, Zend Server 9.x and PHP 7.x does not require IBMi 7.3.

We are running it on 7.1.


It appears that Zend has included pdo_dblib, you just need to enable it in the server setup.

From the Zend Server "PHP" "Extensions" page.

pdo_dblib
FreeTDS PHP-MSSQL-Sybase DB Access

PDO_DBLIB is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to Microsoft SQL Server and Sybase databases through the FreeTDS libary.


Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.

CONFIDENTIALITY NOTICE: This transmission is intended only for the use of the individual(s) named as recipients. It may contain information that is privileged, confidential and/or protected from disclosure under applicable law. If you are not the intended recipient of this transmission, please notify the sender immediately by telephone. Do not deliver, distribute or copy this transmission, disclose its contents, or take any action in reliance on the information it contains