Server side mssql connection
Server side mssql connection
oldano97
Posts: 10Questions: 4Answers: 0
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 ??
This discussion has been closed.
Answers
Does your PHP server have the
sqlsrvPDO driver installed on the Windows PC? Thesqlsrvdriver is not available for Linux machines - it is supplied by Microsoft and Linux isn't a platform they support for it unfortunately.Allan