DataTables w/ MS SQL Server 2014
DataTables w/ MS SQL Server 2014
rcotterj
Posts: 2Questions: 1Answers: 0
I'm trying to utilize DataTables with Server Side Processing, and all of the documentation I find refers to ssp.class.php for MySQL and doesn't use the sqlsrv PHP drivers. Does DataTables support AJAX requests to MS SQL 2014 now? If so, where can I find the documentation and necessary class files?
Thank you for your assistance in advance.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
DataTables itself supports Ajax requests to anywhere, since it doesn't matter what the server-side environment is, as along as it can accept an HTTP request and respond with JSON.
The demo server-side processing script (SSP class) does indeed only support MySQL since that I what I use for the demos. You could modify that script for SQL Server, create your own or use one that someone else has created (I'm not sure if there are any, but a little googling might find one).
DataTables is a client-side Javascript library so I don't plan to introduce code or support for server-side scripts (other than the commercial Editor software, which does support SQL Server out of the box).
Allan
Allan,
Thank you for the response. I greatly appreciate the response.