Dynamic_loading(100); with PDO (MS SQL) fails

[WalterE]

$conn=new PDO(“sqlsrv:Server=$hostname;Database=$database”,“$username”,“$password”, $options);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
require_once (“./dhtmlxConnector/codebase/grid_connector.php”);
require_once (“./dhtmlxConnector/codebase/db_pdo.php”);

$grid = new GridConnector($conn,“PDO”);
$grid->enable_log(“./temp2.log”,true);
$grid->dynamic_loading(100);

this fails and produces this error

pdo_sqlsrv_stmt_execute: message = [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘LIMIT’.

which I see reflected on the client.

This may be normal in a way (while Mysql uses LIMIT, I believe MSSQL uses TOP…), but that does not help me…

[WalterE]

This occurs with the latest code found here:

github.com/DHTMLX/connector-php

[Stanislav]

SQL server requires a custom SQL code for selecting subset of rows. It does matter only if you are using dynamic loading. In such case you need to use sqlsrv data adapter instead of PDO

$conn = sqlsrv_connect( $serverName, $connectionInfo);
$grid = new GridConnector($conn,“SQLSrv”);

[WalterE]

SQL server requires a custom SQL code for selecting subset of rows. It does matter only if you are using dynamic loading. In such case you need to use sqlsrv data adapter instead of PDO

$conn = sqlsrv_connect( $serverName, $connectionInfo);
$grid = new GridConnector($conn,“SQLSrv”);

Was that documented anywhere?

What does this mean as far as the rest of my PHP script is concerned? I use the same $conn to call a stored procedure…:

$stmt = $conn->prepare("{CALL X(?)}");
$stmt->bindParam(1, $X, PDO::PARAM_STR | PDO::PARAM_INPUT_OUTPUT, 40);

Does this need also to be changed?

(I’m a bit disappointed I cannot use PDO)

[Stanislav]

Only functionality that is db-driver specific - dynamic data loading. ( PDO doesn’t provide an abstraction for selection limited set of data )