Reputation: 33
Is it possible to integrate PHP 5.6 to SQL Server 2000 Or should I downgrade to PHP 4.x to do this?
I cannot update the server version nor can I convert the database to MySQL.
Upvotes: 0
Views: 2127
Reputation: 33
I've managed to connect PHP 5.6 and SQL Server 2000. In Ubuntu, I used mssql functions and unixodbc drivers. In Windows, I used the SQL Server driver and odbc functions. And I could only use native PHP for it. (I tried with CI but it doesn't have the right config for it)
Here's the connection code for Windows:
$conn = odbc_connect("Driver={SQL Server};Server=".$server.";Database=".$database.";", $user, $password);
Upvotes: 1