MSSQL db connection

boudga

I believe I have made a successful MSSQL connection from PHP with the DataTables Editor config file. However, when I initialise the Editor I get no results and no datatable displayed. Is there some preferred method to determine if the db connection was successful with the data abstraction layer code provided in the lib?

I used the editor debug function for the browser console and saw nothing that jumped out at me as an error. I also have no browser console errors.

Please advise

colin

If you look at the browser's network tab, in the developer tools section, you'll see the traffic to and from the server. Please could you look at the request being made as the table initialises, and see what the server response is. That should give us some clues.

Colin

boudga

OK I have done quite a bit of tweaking and I have a "loading" message appearing in my table. In the broswer developer tools -> Network tab the file the ajax is trying to load is successfully loading the data as I see this in the response:

[
    {
        "citemno": "2PKKTE",
        "cdescript": "2-PACK KITCHEN TOWEL",
        "cproducttype1": "",

etc etc

But it is not getting loaded into the datatable???

allan

Based on that data structure, have you set the ajax.dataSrc option to be an empty string?

Allan

boudga

That resolved my Issue Allan. Thank you!