Error with sqlserver

Error with sqlserver

mRendermRender Posts: 151Questions: 26Answers: 13

Warning: require(C:\inetpub\wwwroot\website\DataTables-1.10.7\extensions\Editor-1.4.2\php/Database/Driversqlserver/Query.php): failed to open stream: No such file or directory in C:\inetpub\wwwroot\website\DataTables-1.10.7\extensions\Editor-1.4.2\php\Bootstrap.php on line 52

Fatal error: require(): Failed opening required 'C:\inetpub\wwwroot\website\DataTables-1.10.7\extensions\Editor-1.4.2\php/Database/Driversqlserver/Query.php' (include_path='.;C:\php\pear') in C:\inetpub\wwwroot\website\DataTables-1.10.7\extensions\Editor-1.4.2\php\Bootstrap.php on line 52

Trying a very simple connection, I get this error. It would seem, just looking at this file structure, that I would need Driver/sqlserver but the file structure is messed up somehow.

<?php
include( "../DataTables-1.10.7/extensions/Editor-1.4.2/php/DataTables.php" );

      $data = Editor::inst( $db, 'tbl_parts', 'id' )
          ->field(
              Field::inst( 'tbl_parts.id' ),
              Field::inst( 'tbl_parts.partnumber' ),
                  Field::inst( 'tbl_parts.customername' ),
              Field::inst( 'tbl_parts.active' )
          
          )
          ->process($_POST)
          ->data();

echo json_encode( $data );

$(document).ready(function() {
    $('#parts').DataTable( {
        dom: 'Tfrtlip',    
        pageLength: -1,
        paging: true,
        lengthChange: true,
        lengthMenu: [ [10, 20, 50, -1], [10, 20, 50, "All"] ],
        info: false,
        idSrc: "tbl_parts.id",
            ajax: "dt_partslist.php",
            columns: [
        { data: "tbl_parts.id" },
        { data: "tbl_parts.partnumber" },
        { data: "tbl_parts.customername" },
        { data: "tbl_parts.active" }
        ],  
        order: [ 1, 'asc' ],
        tableTools: {
            sRowSelect: "os",
            sSwfPath: "../DataTables-1.10.7/extensions/TableTools/swf/copy_csv_xls_pdf.swf"

        }
    } );

} );

Any suggestions?

Working locally.

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,689Questions: 1Answers: 10,500 Site admin
    Answer ✓

    Driversqlserver

    You have a typo in the configuration file. It should be Sqlserver for the driver. Not sqlserver.

    Allan

  • mRendermRender Posts: 151Questions: 26Answers: 13

    Thanks <3

This discussion has been closed.