Server side mssql connection

Server side mssql connection

oldano97oldano97 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 ??

Answers

  • allanallan Posts: 63,692Questions: 1Answers: 10,500 Site admin

    Does your PHP server have the sqlsrv PDO driver installed on the Windows PC? The sqlsrv driver is not available for Linux machines - it is supplied by Microsoft and Linux isn't a platform they support for it unfortunately.

    Allan

This discussion has been closed.