Zend Framework 2, PDO dblib driver, how to change

Question

It seems that ZF2 with the PDO:dblib driver defaults to using the SQL92 SQL decorator. How do I use the DI system to tell it to use the SqlServer decorator instead? Just can't get my head around it.

The issue is that the paginator attempts to use LIMIT/OFFSET syntax which doesn't work in SQL Server.

Another way of phrasing it is how do I customise the Paginator returned from fetchAll() on a table object to use the SqlServer platform?

Chris

Answer 1

OK, well I found there's a much easier way to do it, after much digging through the Zend Framework. Simply set up your database config like this:

'db' => array(
    'driver' => 'Pdo',
    'dsn' => 'dblib:host=xxx;dbname=xxx',
    'username' => 'xxxxxxxx',
    'password' => 'xxxxxxxx',
    'charset' => 'UTF-8',
    'platform' => 'SqlServer'
)

Now I'm getting different errors, will continue the story!