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.
-
Have you tried ODBC or MS sqlsrv drivers?Machavity– Machavity ♦2015-06-09 00:37:40 +00:00Commented Jun 9, 2015 at 0:37
-
I've read this thread and I guess I cannot connect with the sqlsrv 3.2. The ODBC driver gives me the error SQL Server does not exist or access denied but I've configured my server to allow remote connections and I've put the right IP address of the server. I'm still trying with the ODBC driver tho.phper– phper2015-06-09 00:46:21 +00:00Commented Jun 9, 2015 at 0:46
-
Why would you want to work with sql server 2000? use at least 2008 version instead. 2000 version is 6 feet under for quite some time now.Zohar Peled– Zohar Peled2015-06-09 05:45:36 +00:00Commented Jun 9, 2015 at 5:45
-
I'd like to work on a newer version of SQL Server, but the server in my office is not being upgraded. So I need to adapt to it.phper– phper2015-06-16 01:27:00 +00:00Commented Jun 16, 2015 at 1:27
Add a comment
|
1 Answer
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);