ZF-12481: PDO Connections to MS-SQL Server using wrong SQL syntax.


All PDO-Connections to SQL-Server are using the SQL92-Platform-Syntax.

This is done by \Zend\Db\Adapter\Adapter.php in the function createPlatformFromDriver.

So in example a simple query to a MS-SQL-Database looks like this an causes an error:

SELECT "Tablename".* FROM "Tablename"

The "native" Driver "SqlServer" for Microsoft-SQL-Server can only be used on windows platforms. This is not applicable in most cases.


ZF 2.0.4

Please report issues in version 2 on Github!