Server side mssql connection
Server side mssql connection
I have a table that get data from sql server db with php. I was testing te web site in my local pc with windows and that is my config.php file.
<?php if (!defined('DATATABLES')) exit();
error_reporting(E_ALL);
ini_set('display_errors', '1');
$sql_details = array(
"type" => "Sqlserver",
"user" => "username",
"pass" => "password",
"host" => "host",
"port" => "1433",
"db" => "db",
"dsn" => ""
);
But now I uploaded the web site in a linux web server, and it use mssql driver, I don't know how to make it work whit mssql and i found some code tha is supposed to solve my problem in this page: http://legacy.datatables.net/development/server-side/php_mssql_odbc , but I don't know where this code must to be pasted.
Anyone can help me ??
Answers
Does your PHP server have the
sqlsrv
PDO driver installed on the Windows PC? Thesqlsrv
driver is not available for Linux machines - it is supplied by Microsoft and Linux isn't a platform they support for it unfortunately.Allan