[ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'offset'.

[gsferro]

Laravel Version

11.23.5

PHP Version

8.2.7

Database Driver & Version

ODBC Driver 18 for SQL Server

Description

App	Version
Laravel	11.23.5
PHP	8.2.7
OS	Win 11
RGBD	Sqlsrv

When calling paginate, it is generating the error below using sqlsrv

UsuariosAutorizados::paginate(2);

SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'offset'. (Connection: sqlsrv, SQL: select * from [usuarios_autorizados] order by [id] asc offset 10 rows fetch next 10 rows only)

Steps To Reproduce

# model
Users::paginate(2);

# view
$users->links()

# url
.../users?page=2

[staudenmeir]

Hi @gsferro, What version of SQL Server are you using? It looks like an older one. Laravel 11 requires SQL Server 2017+.