Re: Minimum versions for MS Azure SQL

2016-06-06 20:24 GMT+01:00 Mark Nienberg <[email protected]>:
> I have been connecting to a local MS SQL database via PHP-pdo with FreeTDS
> for some time using CentOS 6. In this case the PHP is 5.3.3 and the FreeTDS
> is 0.91 from the EPEL repository. Now I need to make a similar connection
> to a MS SQL database hosted on the Microsoft Azure cloud. I have not been
> able to do so with the above versions.
>
> I also tested on a CentOS 7 machine, which has PHP 5.4.16 and FreeTDS 0.95.
> Again I did not succeed.
>
> I suppose the issue is related to this PHP - FreeTDS interaction:
>
> https://bugs.php.net/bug.php?id=64338
>
> which seems to indicate a fix in PHP version 5.5.
>
> So then I upgraded the PHP on a test CentOS 6 machine to 5.6 using the Remi
> repository, but that didn't work either, so the problem may be the older
> FreeTDS on that machine.
>
> Does anyone know the minimum versions of PHP and FreeTDS that will connect
> to Azure?
>
> Thanks,
>
> Mark


Surely 0.95 works.
But if I remember you have to enable encrypted login and compile with
GnuTLS/OpenSSL support.
See encryption on http://www.freetds.org/userguide/freetdsconf.htm and
http://www.freetds.org/userguide/odbcconnattr.htm.

Frediano