What are we using to connect to SQL Server from 'Nix these days?

dalecosp

PHP.net wrote:
This extension is not available anymore on Windows with PHP 5.3 or later.

SQLSRV, an alternative extension for MS SQL connectivity is available from Microsoft: » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx.

SQLSRV is a Windows-based solution. Is there no way to access SQL Server from a 'Nix system anymore?

NogDog

I'm confused: you're asking what to use on UNIX/Linux, but the warning is that it's not available in PHP on Windows? In any case, according to http://php.net/manual/en/ref.pdo-dblib.php:

If it is not possible to use SqlSrv, you can use the PDO_ODBC driver to connect to Microsoft SQL Server and Sybase databases, as the native Windows DB-LIB is ancient, thread un-safe and no longer supported by Microsoft.

dalecosp

You don't seem too confused. That's an answer and looks viable.

I may have mis-interpreted what I read, but I have script running mssql_* functions from a couple years ago. We recently updated the underlying OS, and in so doing all 3rd-party software and libraries were updated. SQL Server on the Winbox reported "Connection opened but invalid login packets sent" --- a little more searching revealed that the driver was "packet flooding" the server, (trying to remember the correct term) near as I can tell, so I'm looking for an alternate means (driver?) to test with.