MSSQL Supported?
MSSQL Supported?
djokeefe
Posts: 1Questions: 1Answers: 0
I have spent some time on the site here, read the docs and searched the forums with the latest info on how to get MS SQL working instead of mySQL dating back to 2013.
What is involved with the current version to use MS SQL? Is it just a matter of setting the CF Datasource or does it still involve modifying scripts?
TIA
This discussion has been closed.
Answers
I assume you are referring to the ssp.class.php file for server-side processing with DataTables? That is just an example showing how it might be done - if you want to use it as the basis for your own server-side processing with different features or a different database, you'd need to update it for those requirements.
The biggest change would probably just be in the LIMIT code since it need to be LIMIT and OFFSET in SQL Server. Obviously you'd need to use an SQL Server PDO connection as well.
Allan
MSSQL is supported. A search found my post: https://datatables.net/forums/discussion/comment/86780/#Comment_86780
everything works with MSSQL