Error with sqlserver
Error with sqlserver
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
You have a typo in the configuration file. It should be
Sqlserver
for the driver. Notsqlserver
.Allan
Thanks <3