|
|
发表于 2025-10-27 10:00:12
|
显示全部楼层
广东省中山市

sqlserver连接错误,不知是否个人驱动问题:
case '2': // sqlsrv MSSQL
//修改后
$dbName = $dbTitle ?: $config['mssql']['dbname'];
$connectionString = "sqlsrv:Server={$config['mssql']['host']},{$config['mssql']['port']};Database={$dbName};LoginTimeout={$config['mssql']['timeout']}";
$pdo = new PDO($connectionString, $config['mssql']['user'], $config['mssql']['pass'], $pdoOptions);
//修改前
//$dbName = $dbTitle ?: $config['mssql']['dbname'];
//$connectionString = "sqlsrv:Server={$config['mssql']['host']},{$config['mssql']['port']};Database={$dbName}";
//$pdoOptions[PDO::ATTR_TIMEOUT] = $config['mssql']['timeout'];
//$pdo = new PDO($connectionString, $config['mssql']['user'], $config['mssql']['pass'], $pdoOptions);
------------------------------------------------------------------------------------------------------------------------------
sqlservercha询数据执行语句“数量”处语句拼接错误:
sqlserver 数量限制需使用 “TOP 10"+字段方式
.如果 (连接方式 = 2)
字段名 = “ TOP ” + 到文本 (数量) + “ ” + 字段名
.否则
.如果真 (数量 > 0)
.如果 (是否为空 (排序) = 假 且 删首尾空 (排序) ≠ “”)
排序 = 排序 + “ LIMIT ” + 到文本 (数量)
.否则
排序 = “ LIMIT ” + 到文本 (数量)
|
|